Order Import Does Not Import SOLD_TO_PHONE_ID Column In OE_ORDER_HEADERS_ALL Table (Doc ID 2124041.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Find that SOLD_TO_PHONE_ID column on OE_ORDER_HEADERS_ALL is not imported by Order Import Program.
When populating column SOLD_TO_PHONE_ID in OE_HEADERS_IFACE_ALL and running Order Import,
order imports successfully but the SOLD_TO_PHONE_ID is not getting populated in OE_ORDER_HEADERS_ALL table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load the Order Import interface tables including value in column SOLD_TO_PHONE_ID in OE_HEADERS_IFACE_ALL table.
2. Log Into Order Management Responsibility.
3. Run Order Import program.
4. Check data for the order in SOLD_TO_PHONE_ID in OE_ORDER_HEADERS_ALL table

Cause

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