My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

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


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.

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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