ER: Import Header Level Attributes using the FBDI Order Import Process (Doc ID 2200423.1)

Last updated on FEBRUARY 10, 2019

Applies to:

Goal

The following template is used by FBDI to import orders :- http://docs-uat.us.oracle.com/cloud/latest/scmcs_gs/OEFSC/Import_Sales_Orders_433316_fbdi_16.htm#433316

The tab - DOO_ORDER_HEADERS_ALL_INT - does not allow the following attributes to be entered:

Payment Term Code
Payment Term
Shipping Service Level Code
Shipping Service Level
Shipping Mode Code
Shipping Mode
Shipment Priority Code
Shipment Priority

These values can be entered on DOO_ORDER_LINES_ALL_INT

These attributes should be imported at header level and then used at line level when processing the order.

i.e. Currently

1. A customer may enter a large order with many lines
2. In each line the attributes are entered.
3. If a change is then made at the header level, the attribute value is sourced from the line (which has not changed).

Requirement

1. Import Attribute values at Header Level
2. Make Change to attribute at Header Level - through UI
3. The attribute value is then sourced from Header Level and each line does not have to be changed

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.