My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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***


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

Expect records to be found in SUPPLY_PLAN data table.

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.

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]


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.