Ep_load_mdp_level(0) Is Failing Even After Applying Patch 25420760 (Doc ID 2292473.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.6.1 and later
Information in this document applies to any platform.

Symptoms

This is change is for enabling Proport call for considering parallelization parameters to improve performance.
For this we have applied the db patch <Patch 25420760>: GENERIC 12.2.6.X DATABASE PLATFORM PATCH as suggested by Development, it seems the patch is not working.

The program ep_load_mdp_level(0) is failing with following error even after applying patch 25420760
 

ERROR
"-20003 ORA-20003: Error in PACKAGE BODY Z_COLLECT line 480 executing ACTIVE_PROC_DYN('ep_load_mdp_level(0)’)"

"-20002 ORA-20002: -20003 ORA-20003: Error in PROCEDURE EP_LOAD_MDP_LEVEL line 2321 executing dynamic_proc('proport('ma', TO_CHAR( vi_run_full_proport))') BEGIN ep_load_mdp_level(0); END;”

"-20003 ORA-20003: Error in PROCEDURE EP_LOAD_MDP_LEVEL line 2321 executing dynamic_proc('proport('ma', TO_CHAR( vi_run_full_proport))’)"

"-6550 ORA-06550: line 1, column 30:PLS-00201: identifier 'VI_RUN_FULL_PROPORT' must be declared
ORA-06550: line 1, column 7:PL/SQL: Statement ignored BEGIN proport('ma', TO_CHAR( vi_run_full_proport)); END;"


STEPS TO REPRODUCE
1. Applied patch 25420760
2. Populated T_SRC_SALES_TMPL with history data.
3. executed active_proc_dyn('ep_load_sales’); --> Completed Successfully
4. executed active_proc_dyn('mdp_add(''MDP_LOAD_ASSIST'')’); --> Completed Successfully
5. executed active_proc_dyn('ep_load_mdp_level(0)’); --> Error Out


BUSINESS IMPACT
Due to this issue, we cannot use parallelization parameters to improve performance.

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