ODS Load Does Not Bring Sales Order Line Number Information

(Doc ID 1561161.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

JDE-VCP integration
JDE 9.0 - AIA 3.1 - VCP 12.1.3.8

Collect Planning Data does not bring Sales Order Line Number data from MSC_ST_SALES_ORDERS.LINE_NUM to MSC_SALES_ORDERS.LINE_NUM. MSC_ST_SALES_ORDERS.LINE_NUM has valid line number information, but MSC_SALES_ORDERS.LINE_NUM value is blank/null.
Issue was duplicated internally with sample data Sales Order 2904.

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