CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

InvoicesinvoiceDff

Supports organization-specific data fields on invoices, leveraging descriptive flexfields for custom reporting or validations.

Table-Specific Information

Select

The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Financials].[InvoicesinvoiceDff] WHERE InvoiceId = 10003

Insert

Create an InvoicesinvoiceDff.

You need to provide InvoicesUniqId, instead of InvoicesInvoiceId, to insert the invoiceDff. 

INSERT INTO [Cdata].[Financials].[InvoicesinvoiceDff](InvoicesUniqId,[__FLEX_Context_DisplayValue],[__FLEX_Context]) VALUES (45,'My Group 2','My Group 2')

Update

The Oracle Fusion Cloud Financials API uses InvoicesUniqId instead of InvoicesInvoiceId and InvoiceUniqId instead of InvoiceId as a path parameter in the URL to update the record.

If you want to update a record directly using the Id (without any other filter), you can update the record in one of the following ways: 

UPDATE [Cdata].[Financials].[InvoicesinvoiceDff] SET MyDescription='asdw' WHERE InvoiceUniqId=45 AND InvoicesUniqId=45

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use InvoiceId instead of InvoiceUniqId and InvoicesInvoiceId instead of InvoicesUniqId. You can update the record in the following way: 

UPDATE [Cdata].[Financials].[InvoicesinvoiceDff] SET MyDescription='asdw' WHERE InvoicesInvoiceId=45 AND MyDescription='aaaa'

Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.

Columns

Name Type ReadOnly Description
InvoicesInvoiceId [KEY] Long True

Unique identifier for the invoice associated with the descriptive flexfield, used to link the flexfield data to its corresponding invoice.

InvoicesUniqId [KEY] String True

Unique identifier to be used for insert, update, and delete operations, preferred over InvoicesInvoiceId to manage descriptive flexfield data.

InvoiceId [KEY] Long False

The unique identifier for the invoice to which the descriptive flexfield data is linked, used to track and manage the flexfield's association.

InvoiceUniqId [KEY] String True

Use this unique identifier for insert, update, and delete operations to handle flexfield data, providing a more flexible approach than InvoiceId.

MyDescription String False

Custom description of the invoice, providing additional information or context related to the descriptive flexfield.

MyDate Date False

Custom date field for the invoice's descriptive flexfield, capturing a relevant date associated with the invoice.

DsComments String False

Custom comments related to the descriptive flexfield, allowing users to add further context or explanations regarding the invoice.

_FLEX_Context String False

Context name for the descriptive flexfield, helping define the purpose or use of the flexfield in relation to the invoice.

_FLEX_Context_DisplayValue String False

Display value for the descriptive flexfield context, providing a human-readable version of the context name for better user understanding.

Finder String True

Search term or identifier used to locate and retrieve specific descriptive flexfield records, aiding in efficient data retrieval.

CUReferenceNumber Int False

Reference number used to map child aggregates to parent tables, linking descriptive flexfield data with other related entities.

EffectiveDate Date True

Date parameter used to fetch resources that are effective as of a specified start date, ensuring time-sensitive data is retrieved accurately.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454