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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms