Bookshelf v7.8: Order Integration EAM Mappings

Integration is provided between Oracle Order and the Siebel Order business object, as shown in Table 19 and Table 20.

Entity Mapping

Attribute Mapping

Table 20. Account Attribute Mapping
Siebel Field	Oracle Base Column	Siebel to Oracle Integration	Oracle to Siebel Integration
Siebel Field (Order Entry - Orders)	Oracle Base Column (SO_HEADERS_ALL)	Siebel to Oracle Integration (SIE_HEADERS_INTERFACE_ALL)	Oracle to Siebel Integration (SIE_HEADERS_ALL_V)
Id	ORIGINAL_SYSTEM_REFERENCE	ORIG_SYSTEM_ REFERENCE	ORIG_SYSTEM_REFERENCE
Order Number	PURCHASE_ORDER_NUM	PURCHASE_ORDER_NUM	PURCHASE_ORDER_NUM
Order Date	DATE_ORDERED	DATE_ORDERED	DATE_ORDERED
Pricing Date	CONVERSION_DATE	CONVERSION_DATE	CONVERSION_DATE
Ship to Account Integration Id	SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7)	SHIP_TO_CUSTOMER_ID	SHIP_TO_CUSTOMER_ID
Account Integration Id	CUSTOMER_ID	CUSTOMER_ID	CUSTOMER_ID
Bill To Account Integration Id	INVOICE_TO_SITE_USE_ID (See Address Mapping for R10.7)	INVOICE_CUSTOMER_ID	INVOICE_TO_CUSTOMER_ID
Bill To Address Integration Id	INVOICE_TO_SITE_USE_ID (See Address Mapping for R10.7)	INVOICE_ADDRESS_ID
Ship To Address Integration Id	SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7)	SHIP_ADDRESS_ID	SHIP_ADDRESS_ID
Requested Ship Date	DATE_REQUESTED_CURRENT	DATE_REQUESTED_CURRENT	DATE_REQUESTED_CURRENT
Ship To Contact Integration Id	SHIP_TO_CONTACT_ID	SHIP_TO_CONTACT_ID
Contact Integration Id	ORDERED_BY_CONTACT_ID	ORDERED_BY_CONTACT_ID	ORDERED_BY_CONTACT_ID
Number before "-" in: Price List Integration Id	PRICE_LIST_ID	PRICE_LIST_ID
Bill To Contact Integration Id	INVOICE_TO_CONTACT_ID	INVOICE_TO_CONTACT _ID
Ship Instructions	SHIPPING_INSTRUCTIONS	SHIPPING_INSTRUCTIONS	SHIPPING_INSTRUCTIONS
Organization Integration Id	ORG_ID	ORG_ID	ORG_ID
Comments	PACKING_INSTRUCTIONS		PACKING_INSTRUCTIONS
Integration Id	HEADER_ID		HEADER_ID
Back Office Order Number	ORDER_NUMBER		ORDER_NUMBER
Status	NAME (SO_RESULTS)	ORDER_STATUS (through EAI Value Map Oracle Order Status)	STATUS (SIE_ORDER_HEADER_STATUS_V)
Hold Flag			Calculated based on the existence of row in SIE_ORDER_HEADER_HOLDS_V
Created By	CREATED_BY	CREATED_BY (through value map Oracle User ID)
Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY (through value map Oracle User ID)
Created	CREATION_DATE	CREATION_DATE
Updated	LAST_UPDATE_DATE	LAST_UPDATE_DATE
Currency Code	CURRENCY_CODE	CURRENCY_CODE	CURRENCY_CODE
Order Type	ORDER_TYPE_ID SO_ORDER_TYPES_ALL.NAME	ORDER_TYPE (through EAI Value Map Oracle Order Type)
Tax Exempt	TAX_EXEMPT_FLAG	TAX_EXEMPT_FLAG (through EAI Value Map Oracle Tax Exempt Flag)	TAX_EXEMPT_FLAG (through EAI Value Map Oracle Tax Exempt Flag)
Tax Exempt Reason	TAX_EXEMPT_REASON_CODE	TAX_EXEMPT_REASON_ CODE (through EAI Value Map Tax Exempt Reason)	TAX_EXEMPT_REASON_CODE (through EAI Value Map Tax Exempt Reason)
Payment Method	PAYMENT_TYPE_CODE	PAYMENT_TYPE_CODE (through EAI Value Map Oracle Payment Type Code)	PAYMENT_TYPE_CODE (through EAI Value Map "Oracle Payment Type Code)
Order Priority	SHIPMENT_PRIORITY_CODE	SHIPMENT_PRIORITY_ CODE (through EAI Value Map Oracle Shipment Priority Code)	SHIPMENT_PRIORITY_CODE (through EAI Value Map Oracle Shipment Priority Code)
Carrier Type	SHIP_METHOD_CODE	SHIP_METHOD_CODE (through EAI Value Map Oracle Ship Method Code)
Freight Terms	FREIGHT_TERMS_ CODE	FREIGHT_TERMS_CODE (through EAI Value Map Oracle Freight)	FREIGHT_TERMS_CODE (through EAI Value Map "Oracle Freight")
Freight Terms Info	FOB_CODE	FOB_CODE (through EAI Value Map Oracle Fob Code)	FOB_CODE (through EAI Value Map Oracle Fob Code)
Payment Term Integration Id	TERMS_ID	TERMS_ID
Primary Position Contact Id	SALESREP_ID	SALESREP_ID (through EAI Value Map Oracle Sales Rep ID)
Siebel Field (Order Entry - Line Items)	Oracle Base Column (SO_LINES_ALL)	Siebel to Oracle Integration (SIE_LINES_INTERFACE_ ALL)	Oracle to Siebel Integration (SIE_LINES_ALL_V)
Order Number	SO_HEADERS_ALL. PURCHASE_ORDER_ NUM		PURCHASE_ORDER_NUM (SIE_HEADERS_ALL_V)
Line Number	LINE_NUMBER	LINE_NUMBER	LINE_NUMBER
Quantity Requested	ORDERED_QUANTITY	ORDERED_QUANTITY	ORDERED_QUANTITY
Due Date	DATE_REQUESTED_ CURRENT	DATE_REQUESTED_ CURRENT	DATE_REQUESTED_CURRENT
Base Price	LIST_PRICE	LIST_PRICE	LIST_PRICE
Item Price	SELLING_PRICE	SELLING_PRICE
Product Integration Id	INVENTORY_ITEM_ID	INVENTORY_ITEM_ID	INVENTORY_ITEM_ID
Organization Integration Id	ORG_ID	ORG_ID
Quantity Shipped	SHIPPED_QUANTITY
	TAX_CODE	TAX_CODE	TAX_CODE (SIE_LINES_ALL_V)
Number before "-" in: Price List Integration Id	PRICE_LIST_ID	PRICE_LIST_ID
Id	ORIGINAL_SYSTEM_ LINE_REFERENCE	ORIGINAL_SYSTEM_LINE_ REFERENCE	ORIGINAL_SYSTEM_LINE_ REFERENCE
Ship To Address Integration Id (Order Entry - Orders)	SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7)	SHIP_ADDRESS_ID	SHIP_TO_ADDRESS_ID
Account Integration Id (Order Entry - Orders)	SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7)	SHIP_TO_CUSTOMER_ID	See bug 12-57RW00
Contact Integration Id (Order Entry - Orders)	SHIP_TO_CONTACT_ID	SHIP_TO_CONTACT_ID	See bug 12-57RW00
Created By	CREATED_BY	CREATED_BY (through value map Oracle User ID)
Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY (through value map Oracle User ID)
Created	CREATION_DATE	CREATION_DATE
Updated	LAST_UPDATE_DATE	LAST_UPDATE_DATE
Product Unit of Measure	UNIT_CODE	UNIT_CODE (through EAI Value Map Oracle Unit of Measure)	UNIT_CODE (through EAI Value Map Oracle Unit of Measure)
Carrier Code	SHIP_METHOD_CODE	SHIP_METHOD_CODE (through EAI Value Map Oracle Ship Method Code)
Source Inventory Loc Integration Id (Order Entry - Orders)	WAREHOUSE_ID	WAREHOUSE_ID
Order Priority (Order Entry - Orders)	SHIPMENT_PRIORITY_CODE	SHIPMENT_PRIORITY_CODE
Payment Term Integration Id (Order Entry - Orders)	TERMS_ID	TERMS_ID
Calculate Price Flag (Order Entry - Line Items)		CALCULATE_PRICE (value is calculated depending on Siebel Field Item Price, if Item Price is not null, set it to Y, and otherwise set it to N)
Integration Id	LINE_ID		LINE_ID
Quantity To Invoice	QUANTITY_TO_ INVOICE		QUANTITY_TO_INVOICE
Status	NAME (SO_RESULTS)		STATUS (SIE_ORDER_LINE_ STATUS_V)
Hold Flag			Calculated based on the existence of integration component SIE_ORDER_LINE_HOLDS_V
Ship Method	SHIP_METHOD_CODE		SHIP_METHOD_CODE (through EAI Value Map Oracle Ship Method Code)
Order Priority (Order Entry - Orders)	SHIPMENT_PRIORITY_CODE	SHIPMENT_PRIORITY_ CODE (through EAI Value Map Oracle Shipment Priority Code)	SHIPMENT_PRIORITY_CODE (SIE_LINES_ALL_V) (through EAI Value Map Oracle Shipment Priority Code)
Siebel Field (Order Entry - Line Items)	Oracle Base Column (SO_PRICE_ ADJUSTMENTS) (See Price Adjustment Mapping for R10.7)	Siebel to Oracle Integration (SIE_PRICE_ ADJUSTMENT_INT)	Oracle to Siebel Integration
Calculated Net Discount Percent	PERCENT	PERCENT
Number after "-" in: Price List Integration Id (Order Entry - Orders)	DISCOUNT_ID	DISCOUNT_ID
Volume Discount Integration Id	DISCOUNT_LINE_ID	DISCOUNT_LINE_ID
Id	LINE_ID	ORIGINAL_SYSTEM_LINE_ REFERENCE
Id (Order Entry - Orders)	HEADER_ID	ORIGINAL_SYSTEM_ REFERENCE
Created By	CREATED_BY	CREATED_BY (through value map Oracle User ID)
Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY (through value map Oracle User ID)
Created	CREATION_DATE	CREATION_DATE
Siebel Field (Order Entry - Line Item Actions - "Schedule")	Oracle Base Column	Siebel to Oracle Integration	Oracle to Siebel Integration (SIE_SCHEDULE_QUANTITIES_V)
Line Item Action Type			Schedule
Actual Start Date	SCHEDULE_DATE (SO_LINES_ALL, SO_LINES_DETAILS)		DATE_SCHEDULE
Quantity	ORDERED_QUANTITY (SO_LINES_ALL, SO_LINE_DETAILS)		SCHEDULE_QUANTITY
Integration Id	LINE_ID (SO_LINES_ALL), LINE_DETAIL_ID (SO_LINE_DETAILS)		SCHEDULE_LINE_ID
Line Item Action Number	LINE_ID (SO_LINES_ALL), LINE_DETAIL_ID (SO_LINE_DETAILS)		SCHEDULE_LINE_ID
Siebel Field (Order Entry - Line Item Actions - "Ship")	Oracle Base Column (SO_PICKING_LINES_ALL)	Siebel to Oracle Integration	Oracle to Siebel Integration (SIE_SHIPMENT_QUANTITIES_V)
Line Item Action Type			Ship
Actual Start Date	DATE_SHIPPED (SO_PICKING_HEADERS_ALL)		DATE_SHIPPED
Quantity	SHIPPED_QUANTITY		SHIPPED_QUANTITY
Integration Id	PICKING_LINE_ID		PICKING_LINE_ID
Line Item Action Number	PICKING_LINE_ID		PICKING_LINE_ID

Address Mapping for R10.7

Oracle uses RA_ADDRESSES_ALL to store all the addresses and RA_SITE_USES_ALL to store all the site use information about addresses. If the dataflow is from Siebel Applications to Oracle Applications, all the address and site use data go to Oracle interface table SO_HEADERS_INTERFACE_ALL (or SO_LINES_INTERFACE_ALL) first after passing our pre-validation program.

Then the Oracle concurrent program will read the records in SO_HEADERS_INTERFACE_ALL, complete the corresponding insert/update on RA_ADDRESSES_ALL and RA_SITE_USES_ALL, and finally complete the association between base table SO_HEADERS_ALL (or SO_LINES_ALL) and base table RA_SITE_USES_ALL, and the association between base table RA_SITE_USES_ALL and base table RA_ADDRESSES_ALL.

If the dataflow is from Oracle Applications to Siebel Applications, SIE_HEADERS_ALL_V (or SIE_LINES_ALL_V) contains the de-normalized information about addresses and site use.

Price Adjustment Mapping for R10.7

Price Adjustment Mapping is used only from Siebel Applications to Oracle Applications. In Oracle Applications, base table SO_PRICE_ADJUSTMENTS is the intersection table of Oracle Order, Oracle Price List and Oracle Discount. The corresponding Oracle interface table is SO_PRICE_ADJUSTMENTS_INTERFACE.

The data regarding pricing and discount is mapped to a Siebel buffer table at Oracle side SIE_PRICE_ADJUSTMENTS_INT, then passes through the prevalidation procedure to check for any errors in the data, and then to Oracle interface table SO_PRICE_ADJUSTMENTS_INTERFACE. At last, the Oracle concurrent program is started to import data from the interface table to the base table.

Status Mapping for R10.7

Information about order status is stored in base table SO_RESULTS in Oracle Applications, while in Siebel Applications, this type of information is stored in the field Status.