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


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

https://******************* “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

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
100% Free SEO Tools - Tool Kits PRO
Cloud Technologies Blog
Compare items
  • Total (0)
Shopping cart