Records With Constrained Forecast Are Not Getting Loaded To Supply Plan Data Table ODPM-00075 (Doc ID 1610541.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Customer is on 7314 and is running the download supply plan data for constrained plan
They are running it by way of

a. Login to Demantra Workflow Manager and launch workflow "Download Plan Scenarios".
b. Login to Collaborator workbench as sop/sop. On right side in "Dashboard Supply Review", right click ASCP Plan and click "Load Scenario Data".


However the data is erroring out with the error in the biio_other_plan_data table

[ODPM-00075: Invalid Member LEVEL1-Plan Scenario]
[ODPM-00075: Invalid Member LEVEL4-Demand Class]


The biio_purge_plan_err also shows the following

[ODPM-00075: Invalid Member LEVEL1-Plan Scenario]



BIIO_purge_plan_resource_err shows

[ODPM-00075: Invalid Member LEVEL1-Linked Scenario]




biio_resource_capacity_err shows

[ODPM-00075: Invalid Member LEVEL1-Scenario Resource]


Solution

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