Tuesday 16 April 2024

Rest API to Create a AP Invoice in Oracle Fusion

 Rest API :

https://<Host>/fscmRestApi/resources/11.13.18.05/invoices

example URI:

https://abcd123-test.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices

Method : Post 

Json payload

{
    "InvoiceNumber": "AND_Unmatched_Invoice",
    "InvoiceCurrency": "USD",
    "InvoiceAmount": 2212.75,
    "InvoiceDate": "2019-02-01",
    "BusinessUnit": "Testing BU",
    "Supplier": "INV Global Market Intelligence LLC",
    "SupplierSite": "Main",
    "InvoiceGroup": "01Feb2019",
    "Description": "Office Supplies",
    "invoiceLines": [
        {
            "LineNumber": 1,
            "LineAmount": 2112.75,
            "invoiceDistributions": [
                {
                    "DistributionLineNumber": 1,
                    "DistributionLineType": "Item",
                    "DistributionAmount": 2112.75,
                    "DistributionCombination": "653-83300000-610-100-000-0000"
                }
            ]
        },
        {
            "LineNumber": 2,
            "LineType": "Freight",
            "LineAmount": 100,
            "ProrateAcrossAllItemsFlag": true
        }
    ]
}


Post response 201Created

Thursday 25 January 2024

Rest API Payload to create a Party or a organization and site

 Rest URL:   https://<Host>/crmRestApi/resources/11.13.18.05/hubOrganizations

Payload:

{
    "PartyNumber": "98791",
    "OrganizationName": "Test_98791",
    "PartyUsageCode": "EXTERNAL_LEGAL_ENTITY",
    "SourceSystemReference": [
        {
            "SourceSystem": "SalenticaEngageCRM",
            "SourceSystemReferenceValue": "98791",
            "StartDate": "2023-09-09"
        }
    ],
    "Address": [
        {
            "StartDateActive": "2012-09-09",
            "AddressType": "BILL_TO",
            "Address1": "123 Mayfield Road",
            "City": "Cleveland",
            "Country": "US",
            "PostalCode": "44113",
            "State": "OH"
        }
    ]
}