Demantra Ebs Full Download Failed - ORA-00936: missing expression when executing DYNAMIC_MDP_ADD procedure and ORA-20002 ORA-24344 (Doc ID 1333216.1)

Last updated on AUGUST 29, 2017

Applies to:

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

Symptoms

When attempting to the "EBS Full Download" Workflow the following error occurs.

ERROR
-----------------------
2011-06-22 16:34:10,277 GMT [WFProcess_12] FATAL workflow.general: ORA-20002: -24344 ORA-24344: success with compilation error
ORA-06512: at "DEM73.SEND_ERR_MESSAGE", line 19
ORA-06512: at "DEM73.DYNAMIC_DDL", line 27
ORA-06512: at "DEM73.PROPORT", line 955
ORA-06512: at "DEM73.CHAINING", line 169
ORA-06512: at line 1



STEPS
1. Demantra Workflow Manager
2. Run the "EBS Full Download" Workflow

The same error also occurs when running mdp_add('mdp_load_assist') manually

SQL> begin
2 mdp_add('mdp_load_assist');
3 end;
4 /
begin
*
ERROR at line 1:
ORA-20002: -24344 ORA-24344: success with compilation error
ORA-06512: at "DEM73.SEND_ERR_MESSAGE", line 19
ORA-06512: at "DEM73.DYNAMIC_DDL", line 27
ORA-06512: at "DEM73.MDP_ADD", line 776
ORA-06512: at line 2



When trying to compile DYNAMIC_MDP_ADD procedure:

SQL> alter procedure DYNAMIC_MDP_ADD compile;
Warning: Procedure altered with compilation errors.

SQL> show errors;
Errors for PROCEDURE DYNAMIC_MDP_ADD:

LINE/COL ERROR
-------- ----------------------------------------------------
70/4 PL/SQL: SQL Statement ignored
77/34 PL/SQL: ORA-00936: missing expression
82/4 PL/SQL: SQL Statement ignored
88/30 PL/SQL: ORA-00936: missing expression

SQL>

The "EBS Full Download" WF was running successfully until yesterday. THERE is NO customization involved.  There are sales ( Item and Location combination) in SALES_DATA but NOT in MDP_MATRIX

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