Fail To Execute Proport_j ORA-06512 java.sql.SQLException: ORA-04043 (Doc ID 821293.1)

Last updated on SEPTEMBER 08, 2016

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 Production:
Find that the following error occurs in the collaborator.log

ERROR
ERROR appserver.update.process :: Fail to execute PROPORT_J for
T_UPDATE_10708_38414872000
java.sql.SQLException: ORA-04043: object DYN_PROP_040309035246_316 does not
exist
ORA-06512: at"SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "OCD_DPPD.ACT_DINAMIC_SQL_0", line 10
ORA-06512: at "OCD_DPPD.CHECK_AND_DROP", line 76
ORA-06512: at "OCD_DPPD.PROPORT_J", line 558
ORA-06512: at line 1 at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

STEPS
The issue can be reproduced at will with the following steps:
1. Open Collaborator.log
2. Find the error below:

ERROR appserver.update.process :: Fail to execute PROPORT_J for
T_UPDATE_10708_38414872000
java.sql.SQLException: ORA-04043: object DYN_PROP_040309035246_316 does not
exist
ORA-06512: at"SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "OCD_DPPD.ACT_DINAMIC_SQL_0", line 10
ORA-06512: at "OCD_DPPD.CHECK_AND_DROP", line 76
ORA-06512: at "OCD_DPPD.PROPORT_J", line 558
ORA-06512: at line 1 at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

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