[Fusion] Oracle Fusion REST API to update Invoices Descriptive Flexfields

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 Supervisor or 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:

The Cool Fox