Import Process	Import Sales Orders
UCM	scm/sourceSalesOrder/import
Interface Table	Base Table/View
DOO_ORDER_HEADERS_ALL_INT DOO_ORDER_LINES_ALL_INT DOO_ORDER_ADDRESSES_INT DOO_ORDER_BILLING_PLANS_INT DOO_ORDER_CHARGES_INT DOO_ORDER_CHARGE_COMPS_INT DOO_ORDER_DOC_REFERENCES_INT DOO_ORDER_HDRS_ALL_EFF_B_INT DOO_ORDER_LINES_ALL_EFF_B_INT DOO_ORDER_LOT_SERIALS_INT DOO_ORDER_MANUAL_PRICE_ADJ_INT DOO_ORDER_PAYMENTS_INT DOO_ORDER_SALES_CREDITS_INT DOO_ORDER_TXN_ATTRIBUTES_INT DOO_PROJECTS_INT	DOO_HEADERS_ALL DOO_LINES_ALL DOO_FULFILL_LINES_ALL DOO_ORDER_ADDRESSES

Import Process of Sales Order

Please download the file SourceSalesOrderImportTemplate.xlsm from this location:

https://docs.oracle.com/en/cloud/saas/supply-chain-management/21b/oefsc/order-management.html#importsalesorders-3179

SourceSalesOrderImportTemplate.xlsm   à has 15 sheets, out of which the main sheets are below:

DOO_ORDER_HEADERS_ALL_INT

DOO_ORDER_LINES_ALL_INT

DOO_ORDER_ADDRESSES_INT

Before filling up the data in this sheet, please make use of the below queries to populate the values.

For SHIP_TO

* Address Use Type	SHIP_TO
**Party Identifier	PARTY_ID from HZ_PARTIES
**Party Site Identifier	PARTY_SITE_ID from  hz_party_sites
Party Contact Name	PARTY_NAME from HZ_PARTIES (Party Contact)

For BILL_TO

* Address Use Type	BILL_TO
**Customer Identifier	CUST_ACCOUNT_ID From HZ_CUST_ACCOUNTS
**Customer Name	PARTY_NAME FROM HZ_PARTIES
**Account Site Identifier	ORIG_SYSTEM_REFERENCE from HZ_CUST_SITE_USES_ALL

--PARTY Details
 SELECT 
hps.party_site_number , 
 HP.PARTY_ID, HP.PARTY_NUMBER, HP.PARTY_NAME,
 HCA.STATUS ACCOUNT_STATUS,
 HCA.ACCOUNT_NUMBER, 
 HCA.CUST_ACCOUNT_ID,
 hcasa.PARTY_SITE_ID,
 hcasa.CUST_ACCT_SITE_ID,
 hcasa.ORIG_SYSTEM_REFERENCE HCASA_ORIG_SYSTEM,
 hl.country,
 hl.address1,
 hl.POSTAL_CODE,
 hcsu.SITE_USE_CODE,
 hcsu.ORIG_SYSTEM_REFERENCE  HCC_ACC_SU_ORIG

FROM  
    fusion.hz_cust_accounts          hca,
    fusion.hz_cust_acct_sites_all    hcasa,
    fusion.hz_cust_site_uses_all     hcsu,
    fusion.hz_party_sites            hps,
    fusion.hz_locations              hl,
    fusion.hz_parties                hp
	
WHERE 1=1
    AND hp.party_id = hca.party_id
    AND hcsu.cust_acct_site_id = hcasa.cust_acct_site_id
    AND hps.party_site_id = hcasa.party_site_id
    AND hps.location_id = hl.location_id
	and hcsu.SITE_USE_CODE in ('BILL_TO','SHIP_TO')
	and hp.party_name ='Business World'
	and hps.party_site_number  = '1032'
	and hl.country ='US'

Purging Job Details

Job Name : Delete Orders from Interface Tables

Parameters :

Batch Name      

Source System 

Orders Uploaded Prior to the Following Number of Days Ago    

Order Interface Status