Order Compliance
When an Oracle E-Business Suite sales order is synchronized, a corresponding transaction is created in Oracle Global Trade Management having the same ID as the sales order. If the Oracle E-Business Suite sales order has a line hierarchy, the line hierarchy is carried over to the Oracle Global Trade Management transaction. For Order Synchronization, Oracle Global Trade Management assumes that the related items and parties have been synched and are available in Oracle Global Trade Management. Some of the major fields get mapped to the Oracle Global Trade Management transaction as per the following mapping table:
| Oracle E-Business Suite Source | Oracle E-Business Suite Element | Oracle Global Trade Management Element | Details |
|---|---|---|---|
|
OE_ORDER_HEADERS_ALL.order_number NUMBER |
order_line.order_number | GtmTransaction/ GtmTransactionGid/Gid/Xid |
order_number appended with “_O” Ex: 34525_O |
|
Wsh_itm_request_control.order_line_number VARCHAR2(100) |
order_line.order_line_number | GtmTransaction / GtmTransactionLine /LineObjectGid | Line Number of the Line; e.g. 1.2 |
|
OE_ORDER_HEADERS_ALL.ordered_date; DATE |
order_line.ordered_date | GtmTransaction /ExportDate | Export Date on transaction |
|
OE_ORDER_LINES_ALL.ordered_qty NUMBER |
order_line.ordered_quantity | GtmTransaction / GtmTransactionLine /Quantity/QuantityValue |
Quantity ordered on the line. Will be stroed against “EBS QUANTITY” as Quantity Qualfier. |
| OE_ORDER_LINES_ALL.UOM; VARCHAR2(3) | order_line. ordered_quantity_uom | GtmTransaction / GtmTransactionLine /Quantity/UOM | Unit of measure of the ordered quantity , EA (each), DZ (dozen) |
| OE_ORDER_LINES_ALL.line_number; NUMBER | order_line.line_number | GtmTransaction / GtmTransactionLine /Remark/RemarkText | This creates a remark in the trade transaction with qualifier as ‘LINE_NUMBER’ and remark text as line_number. |
| OE_ORDER_LINES_ALL.link_to_line_id NUMBER | order_line.link_to_line_id |
If a line has a parent, link_to_line_id represents the parent’s line id. This element is used form the transaction line hierarchy Link_to_line_id appended with “_O” Ex : 6215_O |
|
|
OE_ORDER_LINES_ALL.unit_selling_price NUMBER |
order_line.unit_selling_price | GtmTransaction / GtmTransactionLine / Currency/CurrencyValue/ FinancialAmount/ MonetaryAmount | Saved as a currency with currency type as ‘PRICE PER UNIT’ |
| OE_ORDER_LINES_ALL.inventory_item_id NUMBER | order_line.Item_Id |
GtmTransaction/ GtmTransactionLine/ ItemGid/Gid/Xid |
Items should be created in advance of this. They will not be created on the fly via this flow. Item sync should be utilized to create Oracle Global Trade Management items with the same ID from Oracle E-Business Suite |
|
MTL_PARAMETERS.organization_code VARCHAR2(3) |
Order_line.ship_from_org_code (This is inventory Organization Code e.g. CA , M1) |
GtmTransaction/ GtmTransactionLine/ InvolvedParty/ ContactRef/ ContactGid/Gid/Xid |
This is stored as an involved party on transaction line with qualifier as ‘SHIP_FROM’ |
Entire default mapping given in the StyleSheetContent ‘DEFAULT_ORDER_COMPLIANCE_STYLESHEET’ is used by the system to generate Oracle Global Trade Management XML for inserting order data as Oracle Global Trade Management trade transaction unless it is overridden. The sample EBS and transformed GTM XMLs appears in the Appendix: XML Samples chapter, in the Order Compliance section.