My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.