Tech Trainings

Oracle Cloud ERP – Sales Order Header EFF Creation Using REST API

October 4, 2020 by admin

-Sample Payload

{
    "SourceTransactionNumber": "XXORATRAININGS_0015",
    "SourceTransactionSystem": "OPS",
    "SourceTransactionId": "XXORATRAININGS_015",
    "BusinessUnitName": "US1 Business Unit",
    "BuyingPartyName": "ABC Application Software",
    "BuyingPartyContactName": "Stella Danzig",
    "TransactionType": null,
    "RequestedShipDate": "2019-10-19T20:49:12+00:00",
    "RequestedFulfillmentOrganizationName": null,
    "PaymentTerms": "30 Net",
    "TransactionalCurrencyName": "US Dollar",
    "RequestingBusinessUnitName": "US1 Business Unit",
    "FreezePriceFlag": false,
    "FreezeShippingChargeFlag": false,
    "FreezeTaxFlag": false,
    "SubmittedFlag": false,
    "SourceTransactionRevisionNumber": 1,
	
	"additionalInformation":[{
			"Category":"DOO_HEADERS_ADD_INFO",
			"HeaderEffBXXORATRAININGSprivateVO":[
			{
				"ContextCode":"XXORATRAININGS",
				"userdetails":"---SCM---IMPL--"
			}
			],
			"HeaderEffBPricingHeaderInformationprivateVO":[ {
				"ContextCode":"PricingHeaderInformation",
				"saleschannel":"ORA_DIRECT"
			} ]
		}] ,
	
    "billToCustomer": [
        {
            "PartyName": "ABC Application Software",
            "AccountNumber": "26360",
            "Address1": "292 BROKAW RD",
            "City": "Santa Clara",
            "State": "CA",
            "PostalCode": "95050",
            "County": "SANTA CLARA",
            "Province": null,
            "Country": "US",
            "ContactName": "Stella Danzig",
            "ContactFirstName": "Stella",
            "ContactLastName": "Danzig"
        }
    ],
    "shipToCustomer": [
        {
            "PartyName": "ABC Application Software",
            "PartyNumber": "26360",
            "PartyId": 100000000395795,
            "ContactId": 100000000395849,
            "ContactNumber": "1032",
            "ContactName": "Stella Danzig",
            "ContactFirstName": "Stella",
            "ContactMiddleName": null,
            "ContactLastName": "Danzig",
            "SiteId": 300000047368514,
            "Address1": "292 BROKAW RD",
            "City": "Santa Clara",
            "County": "SANTA CLARA",
            "PostalCode": "95050",
            "Country": "US"
        }
    ]
}

BI Query

SELECT
    dha.order_number,
    dheb.eff_line_id,
    dheb.header_id,
    dheb.context_code,
    dheb.attribute_char1    ,
    dha.creation_date,
    dha.created_by
FROM
    fusion.doo_headers_eff_b    dheb,
    fusion.doo_headers_all      dha
WHERE
        1 = 1
    AND dha.header_id = dheb.header_id(+)
    AND dha.order_number = '97388'

Comments |0|