Updating Data Model Immediately After Upgrading To 7.1.1 With No Changes Errors ORA-20001 ORA-20002 ORA-24344 (Doc ID 457152.1)

Last updated on MARCH 22, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 7.1.1 in Test:
Users upgraded from 6.2.6 to 7.1.1 and applied patch 6119487 RUP#7110002. As a test, without
making any changes they ran Update Model. However the following errors were returned:

ORA-20001: ORA-20001: ORA-20002: ORA-24344: success with compilation error
Error in PACKAGE BODY DATA_MODEL line 3536

dynamic_ddl( 'create or replace procedure "ep_load_main"
is
begin
--prepare_data(160);
replace_apostrophe;
ep_cProblem with procedure EP_BUILD_MODEL !!

When they check for invalid procedures and try to recompile them, they will not compile:

Proport
Line: 873 Column: 14 Error: PLS-00103: Encountered the symbol "2"

Chaining
Line: 112 Column: 7 Error: PLS-00905: object DP.PROPORT is invalid
Line: 112 Column: 7 Error: PL/SQL: Statement ignored


Delete_Invalid_Gl_Population
Line: 29 Column: 29 Error: PLS-00201: identifier 'PROMOTION_LEVELS' must be declared
Line: 28 Column: 17 Error: PL/SQL: SQL Statement ignored
Line: 34 Column: 23 Error: PLS-00201: identifier 'PROMOTION_LEVELS' must be declared
Line: 33 Column: 20 Error: PL/SQL: SQL Statement ignored
Line: 44 Column: 22 Error: PLS-00364: loop index variable 'REC2' use is invalid
Line: 44 Column: 4 Error: PL/SQL: Statement ignored
Line: 60 Column: 30 Error: PLS-00364: loop index variable 'REC' use is invalid
Line: 60 Column: 4 Error: PL/SQL: Statement ignored
Line: 76 Column: 11 Error: PLS-00417: unable to resolve "IS_PROMOTION" as a column
Line: 74 Column: 4 Error: PL/SQL: SQL Statement ignored

Ep_load_main
Line: 18 Column: 2 Error: PLS-00905: object DP.MDP_ADD is invalid
Line: 18 Column: 2 Error: PL/SQL: Statement ignored

MDP_ADD
Line: 582 Column: 10 Error: PLS-00905: object DP.PROPORT is invalid
Line: 582 Column: 10 Error: PL/SQL: Statement ignored
Line: 590 Column: 10 Error: PLS-00905: object DP.PROPORT is invalid
Line: 590 Column: 10 Error: PL/SQL: Statement ignored

manuals_populate_ins
Line: 582 Column: 10 Error: PLS-00905: object DP.PROPORT is invalid
Line: 582 Column: 10 Error: PL/SQL: Statement ignored
Line: 590 Column: 10 Error: PLS-00905: object DP.PROPORT is invalid
Line: 590 Column: 10 Error: PL/SQL: Statement ignored

exec_manuals_ins_integration
Line: 10 Column: 7 Error: PLS-00905: object DP.MANUALS_INS_INTEGRATION is invalid
Line: 10 Column: 7 Error: PL/SQL: Statement ignored

DP.MANUALS_INS_INTEGRATION
Error(1446,2): PLS-00103: Encountered the symbol "2"

STEPS
The issue can be reproduced at will with the following steps:
1. Upgrade from 6.2.6 to 7.1.1
2. Go into the Business Modeler and update the model without making any changes - error occurs
3. Review and try to recompile all invalid procedures

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