Create AP Invoice rest api in Oracle Fusion ERP

You can easily create AP invoices using Create AP Invoice rest API in Oracle fusion

The rest APIs are

/fscmRestApi/resources/11.13.18.05/invoices

to query an invoice you can use the query parameter in postman

https://*******************.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/invoices?q=InvoiceNumber= โ€œINV201โ€

Sample payload to create ap invoice

{
    "InvoiceNumber": "IDC203",
    "InvoiceCurrency": "USD",
    "InvoiceAmount": 2212.75,
    "InvoiceDate": "2019-02-01",
    "BusinessUnit": "US1 Business Unit",
    "Supplier": "Lee Supplies",
    "SupplierSite": "Lee US1",
    
    "InvoiceGroup": "01Feb2019",
    "Description": "Office Supplies"
   
,
   
    "invoiceLines": [{
        "LineNumber": 1,
        "LineAmount": 2112.75,
   
        "invoiceDistributions": [{
            "DistributionLineNumber": 1,
            "DistributionLineType": "Item",
            "DistributionAmount": 2112.75,
            "DistributionCombination": "101.10.22100.000.000.000"
   
        }]
        },
        {
            "LineNumber": 2,
            "LineType": "Freight",
            "LineAmount": 100,
            "ProrateAcrossAllItemsFlag": true
        }]
   
}

SQL to query the invoice

select * from ap_invoices_all order by creation_date desc

select * from ap_invoice_lines_all where invoice_id = 300000241093306

Refer oracle doc here

More fusion apps tech

wpsadmin
We will be happy to hear your thoughts

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart