JDE to VCP Collection: Sales Orders Are Not Collected From Staging To Base Table (Doc ID 2228454.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

Sales orders are not collected from staging to base table

We are collecting sales orders from JDE to ASCP. Some sales orders are collected but more sales orders are failed in validation and not collected.

Error message in msc_st_sales_orders table


ERROR
Demand_Id or Demand_source_header_id cannot be null.Please resubmit the record with a non-null value for Demand_id or Demand_source_header_id


STEPS TO REPRODUCE
1. Run the Collect Planning Data concurrent request.
2. See the error message in the msc_st_sales_orders staging table

BUSINESS IMPACT
Due to this issue, users cannot collect sales orders of any kind into VCP for planning purposes.

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