JDE to VCP Collection: Sales Orders Are Not Collected From Staging To Base Table
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
STEPS TO REPRODUCE
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