Tech Trainings

Oracle Cloud ERP – Create AP Invoice Using REST API and UI

October 15, 2020 by admin

1. Create/View Invoices : Navigation:Payables –Invoice
2. Get an invoice using REST API :

/fscmRestApi/resources/11.13.18.05/invoices/{InvoiceId}

https://ucf1-zrgs-fa-ext.oracledemos.com/fscmRestApi/resources/11.13.18.05/invoices/300000210791416

3. Create an Invoice using REST API

/fscmRestApi/resources/11.13.18.05/invoices

https://ucf1-zrgs-fa-ext.oracledemos.com/fscmRestApi/resources/11.13.18.05/invoices

3.Query :

select * from ap_invoices_all order by creation_date desc

select * from ap_invoice_lines_all where invoice_id = 300000210773443

Tools Used

1.Notepad++ — https://notepad-plus-plus.org/
2.Postman — https://www.postman.com/downloads/

--JSON Header Request Paylaod

{
    "InvoiceNumber": "XX_REST_INV_001",
    "InvoiceCurrency": "USD",
    "InvoiceAmount": 2212.75,
    "InvoiceDate": "2020-10-15",
    "BusinessUnit": "US1 Business Unit",
    "Supplier": "ABC Consulting",
    "SupplierSite": "ABC US1",
    "Requester": null,
    "InvoiceGroup": null,
    "Description": "--Invoice Created using REST API"
}

--JSON Header and Lines Request Payload
 {
    "InvoiceNumber": "XX_REST_INV_006",
    "InvoiceCurrency": "USD",
    "InvoiceAmount": 2500,
    "InvoiceDate": "2020-10-15",
    "BusinessUnit": "US1 Business Unit",
    "Supplier": "ABC Consulting",
    "SupplierSite": "ABC US1",
    "Requester": null,
    "InvoiceGroup": null,
    "Description": "--Invoice Created using REST API",
	
	  "invoiceLines": [{
        "LineNumber": 1,
        "LineAmount": 2000.00,
		"Description": "Line 1 Description",
   
        "invoiceDistributions": [{
            "DistributionLineNumber": 1,
            "DistributionLineType": "Freight",
            "DistributionAmount": 2000.00,
            "DistributionCombination": "101.10.62510.120.000.000"
   
        }]
        },
        {
            "LineNumber": 2,
            "LineType": "Item",
            "LineAmount": 500,
			"Description": "Line 2 Description",
            "ProrateAcrossAllItemsFlag": true
        }]
	
}

Comments |0|