Supply Data From ASCP Is Not Getting Loaded Into Demantra During Plan Data Load. (Doc ID 1638865.1)

Last updated on MARCH 30, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2015***

Symptoms

On : 7.3.1 version, LoadData

When attempting to load supply_plan_data, the rows are not created and
the following error occurs in collaborator.log file.

ERROR
-----------------------
"ODPM-70446: Failed to update combination:[Item-1001000, Organization-org:301, Supplier Site-0, Demand Class-0, Sub Inventory-S301001:1041]"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. launch ascp plan

2. launch plan scenario data from demantra collaborator workbench in sop login

3. wait for the workflow to complete

4. check that data . Data is available in the worksheet.

5. add a new supplier site in the ASCP plan

6. launch plan scenario data from demantra collaborator workbench for the same plan

7. Data is not available in the worksheets and it is not getting loaded in the supply_plan_data table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Supply data not loaded fully in demantra, which leads to wrong sales and operation planning in the system.

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