Download Plan Scenario Data Doesn’T Bring Any Data To Demantra (Doc ID 956434.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 2.5.9 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sept-2013***


Symptoms

Customer is running Download Plan Scenarios and notices that no data gets loaded if the
volume of data to load is very large

Steps:
======
Initially they created a ASCP plan with 60 orgs.
Run the workflow 'Download Plan Scenario' which populate supply_plan.
Login to Demantra Workflow Manager and launch workflow "Download Plan
Scenarios".
Login to Collaborator workbench as sop/sop. On right side in "Dashboard
Supply Review", right click ASCP Plan and click "Load Scenario Data".

However, when they create a supply plan with 2 orgs, the data gets loaded
into the supply_plan_data table. The number of records created in the
biio_other_plan_data is 115. When the data got inserted into the
supply_plan_data table , it created ~ 1,100,000 records for all combinations
and items. They see a lot of null rows in terms of supply data. They have
provided the supply_plan_table which I am uploading with the Bug.

When they created a supply plan with 3 org, they get 3 million rows in the
supply_plan_data table. When they have 4 org in the Plan, the data does come
into the interface tables, but at the end of the process, it gets wiped out
and no data is loaded. So once the volume of data is increased (like the
initial attempt to load with 60 orgs) no data gets loaded. No errors are
there in the integration logs, collaboration logs and the db_exception logs






.

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