Oracle Cloud ERP – Sales Order FBDI
| 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:
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
Comments |0|
Category: OracleSaaS