When working with Oracle Fusion Cloud, Descriptive Flexfields (DFFs) provide a powerful way to capture additional business-specific information without customizing the application. Often, there’s a need to update these DFFs programmatically — especially on transactional entities like Payables Invoices.
Oracle Fusion provides REST APIs that make it straightforward to integrate and update such information. In this post, we’ll walk through how to update Descriptive Flexfields (DFFs) on Invoices using the REST API.
✅ Prerequisites
Before we begin, make sure you have the following:
-
User access with necessary roles such as
Accounts Payable Supervisoror a custom role with REST access. -
DFF segments defined and deployed for the Invoice entity.
-
Knowledge of the context code and segment names of the DFFs you want to update.
🔍 Step 1: Understand the REST Endpoint
To update an invoice DFF, the REST API endpoint is:
PATCH /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceDff/{InvoiceId}Source:https://docs.oracle.com/en/cloud/saas/financials/25b/farfa/op-invoices-invoicesuniqid-child-invoicedff-invoiceid-patch.html
invoicesUniqID and InvoiceId both are Invoice IDs. You can use Get Invoice API to get it:
GET /fscmRestApi/resources/11.13.18.05/invoices
Source: https://docs.oracle.com/en/cloud/saas/financials/25b/farfa/op-invoices-get.html
fields: InvoiceId,InvoiceNumber will display only these fields
links: canonical will hide the global links
onlyData: true will hide links in each JSON object
q: InvoiceNumber=IAC5297279 will show only this invoice
Now after getting the InvoiceID, you now use the GET DFF API to see structure of DFF:
GET /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceDff
Now, use the DFF Update API:
Comments
Post a Comment