Several Invalid Objects Noticed After Upgrading From 4.5.3 to 4.6.2 Using RDBMS 12c (Doc ID 2118292.1)

Last updated on MARCH 18, 2016

Applies to:

Oracle Clinical - Version 5.1.0 and later
Information in this document applies to any platform.

Symptoms

While using RDBMS 12c, the upgrade from 4.5.3 to 4.6.2 appears to complete successfully however several invalid objects remaining after the upgrade.

Errors for PACKAGE BODY RXC.RDC_ZF_DCI_ACCESS:
55/4 PL/SQL: SQL Statement ignored
55/29 PL/SQL: ORA-01031: insufficient privileges

Errors for PACKAGE BODY RXC.TRACKACTIVITIES:
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00201: identifier 'TRACKACTIVITIES' must be declared
1/18 PLS-00304: cannot compile body of 'TRACKACTIVITIES' without its Specification

Errors for PACKAGE BODY RXC.RXC_DCI_BOOK_RULES_API:
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00201: identifier 'RXC_DCI_BOOK_RULES_API' must be declared
1/18 PLS-00304: cannot compile body of 'RXC_DCI_BOOK_RULES_API' without its specification

Errors for PACKAGE BODY RXC.RDC_REPORT_XML_GENERATION:
4428/3 PL/SQL: Statement ignored
4428/33 PLS-00201: identifier
'RXC_RESPONSE_LOBS.FETCH_RESPONSE_VERSION_LOB' must be declared
4454/3 PL/SQL: Statement ignored
4454/33 PLS-00201: identifier
'RXC_RESPONSE_LOBS.FETCH_RESPONSE_CURRENT_LOB' must be declared

Errors for PACKAGE BODY RXC_REP.REPLINVSITE:
168/5 PL/SQL: SQL Statement ignored
193/12 PL/SQL: ORA-00904: "EXPECTED_ENROLLMENT_RATE": invalid identifier

Errors for TRIGGER RXA_DES.PATIENT_STATUSES$ARI:
2/20 PL/SQL: Item ignored
2/20 PLS-00201: identifier 'RXA_DES.PATIENT_POSITION_TY' must be
declared
10/3 PL/SQL: SQL Statement ignored
10/10 PL/SQL: ORA-00904:
"RXA_DES"."PATIENT_POSITIONS_PCK"."CREATE_PATIENT_POSITION_PS":
invalid identifier
62/3 PL/SQL: Statement ignored
62/6 PLS-00320: the declaration of the type of this expression is incomplete or malformed

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