Invoices

Manages key supplier invoice data, including header, lines, distributions, installments, and descriptive flexfields for payables processing.

Table Specific Information

Select

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

For example, the following query is processed server side:

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

Insert

Create an invoice.

INSERT INTO [Cdata].[Financials].[Invoices] (InvoiceNumber,InvoiceCurrency,InvoiceAmount,InvoiceDate,BusinessUnit,Supplier,SupplierSite,Requester,InvoiceGroup,Description) VALUES ('AND_Unmatched_Invoice','USD',2212.75,'2019-02-01','Vision Operations','Advanced Network Devices','FRESNO','Johnson,Mary','01Feb2019','Office Supplies')

If you want to add child views/tables along with the parent table, you can add the child in following ways:

Using TEMP table:

INSERT into InvoicesinvoiceLinesinvoiceDistributions#TEMP(DistributionLineNumber,DistributionCombination,DistributionAmount,DistributionLineType,CUReferenceNumber) values (26,'101.10.60230.462.000.000',3.25,'Item',1)
INSERT into InvoicesinvoiceLinesinvoiceDistributions#TEMP(DistributionLineNumber,DistributionCombination,DistributionAmount,DistributionLineType,CUReferenceNumber) values (27,'101.10.60230.462.000.000',83.25,'Item',2)
INSERT into InvoicesinvoiceLines#TEMP(invoiceDistributions,LineNumber,DistributionCombination,LineAmount,CUReferenceNumber) values ('InvoicesinvoiceLinesinvoiceDistributions#TEMP',46,'101.10.60230.462',3.25,1)
INSERT into InvoicesinvoiceLines#TEMP(invoiceDistributions,LineNumber,DistributionCombination,LineAmount,CUReferenceNumber) values ('InvoicesinvoiceLinesinvoiceDistributions#TEMP',47,'101.10.60230.462',36.25,2)
INSERT INTO [Cdata].[Financials].[Invoices] (InvoiceNumber,InvoiceCurrency,InvoiceAmount,InvoiceDate,BusinessUnit,Supplier,SupplierSite,Requester,InvoiceGroup,Description,invoiceLines) VALUES ('AND_Unmatched_Invoice','USD',2212.75,'2019-02-01','Vision Operations','Advanced Network Devices','FRESNO','Johnson,Mary','01Feb2019','Office Supplies','InvoicesinvoiceLines#TEMP')

Note : you can use CUReferenceNumber to map the child views/tables to their parent. For example, invoiceLines having CUReferenceNumber 1, will have the child aggregates having CUReferenceNumber 1.

Directly providing the aggregate:

INSERT INTO [Cdata].[Financials].[Invoices] (InvoiceNumber,InvoiceCurrency,InvoiceAmount,InvoiceDate,BusinessUnit,Supplier,SupplierSite,Requester,InvoiceGroup,Description,invoiceLines) VALUES ('AND_Unmatched_Invoice','USD',2212.75,'2019-02-01','Vision Operations','Advanced Network Devices','FRESNO','Johnson,Mary','01Feb2019','Office Supplies','[
  {
    "LineNumber": 3,
    "LineAmount": 54.25,
    "DistributionCombination": "101.10.60230.462"
  }
]')

Update

The Oracle Fusion Cloud Financials API uses 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 the following way:

Update [Cdata].[Financials].[Invoices] set Description='abcd' where InvoiceUniqId=454545454;

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

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

Update [Cdata].[Financials].[Invoices] set Description='abcd' where InvoiceId=454545454 and Supplier='abc';

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

Delete

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

If you want to delete a record directly using the id (without any other filter), you can delete the record in the following way:

Delete from [Cdata].[Financials].[Invoices] where InvoiceUniqId=454545454;