S&OP Workflow "Download Plan Scenarios" Does Not Load Plan Data (Doc ID 1275312.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 to 7.3.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 04-Mar-2013***

Symptoms


On version 7.3.0:

Find the workflow "Download Plan Scenarios" was run, but does not load any plan data. No records found in SUPPLY_PLAN table or in the Workbench Supply Review dashboard

EXPECTED BEHAVIOR
--------------------------------------
Expect records to be found in SUPPLY_PLAN data table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the ASCP Plan in the Planning ERP instance
2. Log into Demantra Workflow Manager
3. Submit 'Download Plan Scenarios' workflow.
4. The workflow completes without error, but no plan is seen in the table SUPPLY_PLAN.
5. Login into Collaborator workbench, no plan is seen in the Supply Review dashboard.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot generate data for S&OP


There are no errors seen in the Collaborator or Integration log files.

The BIIO_SUPPLY_PLAN_ERR table shows the following error:

[ODPM-10421: Population Attribute, Error:ODPM-10422: Invalid Population,ODPM-10057: Object is not valid :ODPM-10228: Filter Level]

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