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