JDE to VCP Collection: Sales Orders Are Not Collected From Staging To Base Table

(Doc ID 2228454.1)

Last updated on DECEMBER 18, 2017

Applies to:

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


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

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

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

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


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