ODPM-00067: [Query Profile Table BIIO_SUPPLY_PLA_15_1224_50 does not Exist in Database !] 12.2.4.1 (Doc ID 1970284.1)

Last updated on MAY 14, 2015

Applies to:

Oracle Demantra Demand Management - Version 12.2.4.1 to 12.2.4.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version, LoadData

When attempting to run Download Plan Scenario Data workflow,
the following error occurs.

ERROR
-----------------------
2014-12-04 09:05:38,380 PST [http-bio-8080-exec-12] ERROR integration.process:
ODPM-00086: Validation Error in profile 'Supply Plan Data (WO)_1224_50', Profile Disabled.
ODPM-00067: [Query Profile Table 'BIIO_SUPPLY_PLA_15_1224_50' does not Exist in Database !]
ODPM-00067: [Query Profile Table 'BIIO_SUPPLY_PLA_15_1224_50_ERR' does not Exist in Database !]
2014-12-04 09:05:38,396 PST [http-bio-8080-exec-12] ERROR integration.process:
ODPM-00086: Validation Error in profile 'Other Plan Zone Data_1224_50', Profile Disabled.
ODPM-00067: [Query Profile Table 'BIIO_OTHER_PLAN_80_1224_50' does not Exist in Database !]
ODPM-00067: [Query Profile Table 'BIIO_OTHER_PLAN_80_1224_50_ERR' does not Exist in Database !]
2014-12-04 09:05:38,849 PST [http-bio-8080-exec-12] ERROR integration.process:
ODPM-00086: Validation Error in profile 'Purge SPF Fleet Data_1224_50', Profile Disabled.
ODPM-00067: [Query Profile Table 'BIIO_PURGE_SPF__91_1224_50' does not Exist in Database !]
ODPM-00067: [Query Profile Table 'BIIO_PURGE_SPF__91_1224_50_ERR' does not Exist in Database !]
2014-12-04 09:05:46,302 PST [http-bio-8080-exec-12] ERROR integration.process:
ODPM-00086: Validation Error in profile 'Scenario Price_1224_50', Profile Disabled.
ODPM-00067: [Query Profile Table 'BIIO_Scenario_P_98_1224_50' does not Exist in Database !]
ODPM-00067: [Query Profile Table 'BIIO_Scenario_P_98_1224_50_ERR' does not Exist in Database !]


The upgrade has replaced data profile 'Supply Plan Data (WO)' with ' 'Supply Plan Data (WO)_1224_50' however has not created the biio tables
'BIIO_SUPPLY_PLA_15_1224_50' and 'BIIO_SUPPLY_PLA_15_1224_50_ERR'. This is resulting in failure of 'Download Data' step.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Upgrade from 12.2.3 to 12.2.4 and then to 12.2.4.1
2.Run Downloading Plan Scenarios workflow
3. Log into Collaborator Workbench
4. Go to Dashboard: Supply Review worksheet
5. Right click on your plan
6. Go to Method, and run Load scenario data method. This will call Download Plan Scenario Data workflow .

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pull dependent demand back from ASCP

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