PJI_PJP_SUM_ROLLUP Object Is Invalid After EBS System Migration - PLS-00201: Identifier 'SYSTEM.PA_NUM_TBL_TYPE' Must Be Declared
(Doc ID 3013534.1)
Last updated on APRIL 05, 2024
Applies to:
Oracle Project Planning and Control - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
PJI_PJP_SUM_ROLLUP is invalid after the EBS System migration.
Run the following SQL statement. Errors are shown.
SQL> alter package apps.PJI_PJP_SUM_ROLLUP compile body;
Warning: Package Body altered with compilation errors.
SQL>
SQL> show err
Errors for PACKAGE BODY APPS.PJI_PJP_SUM_ROLLUP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
5101/25 PLS-00201: identifier 'SYSTEM.PA_NUM_TBL_TYPE' must be declared
SQL> SQL>
Replication steps:
1. Perform the EBS System migration.
2. PJI_PJP_SUM_ROLLUP is invalid after the EBS System migration.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |