System Error: "ORA-06508: PL/SQL: could not find program unit being called: APPS.CSP_PARTS_REQUIREMENT" and Package Compile Error: "PLS-00302: component 'G_RESCHEDULE' must be declared" (Doc ID 1576316.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Spares Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
cspvprqb.pls, cspgscib.pls, CSXSRISR

Symptoms

ORA-06508 PL/SQL : Could not find program unit being called error in APPS.CSP_PARTS_REQUIREMENT or APPS.CSP_CSH_INT_PVT packages showing in system or when trying to recompile after applying a patch.

Error

ORA-04063: Package body "APPS.CSP_PARTS_REQUIREMENT" has errors
ORA-06508: PL/SQL : Could not find program unit being called : "APPS.CSP_PARTS_REQUIREMENT". Please contact your system administrator

Full Error on Package Compilation

The error indicates that a dependent object can't be found or referenced therefore the package will be invalid.  On trying to compile the invalid object the error causing the issue will show as:

PLS-00302: component 'G_RESCHEDULE' must be declared

 

Steps to Reproduce

This error may show in the system in the following scenarios, after a patch and/or when trying to compile the CSP_PARTS_REQUIREMENT or CSP_CSH_INT_PVT Packages.

In all the scenarios where the ORA-06508 error is seen in the system, it indicates that a dependent object can't be found or referenced in the package CSP_PARTS_REQUIREMENT.  In order to find the underlying error you need to try and compile the invalid object.

 

 A) Check Package Review Invalid Packages

Run command at SQL prompt:

SELECT object_name,status,owner,OBJECT_TYPE
FROM dba_objects
WHERE object_name='CSP_PARTS_REQUIREMENT';

 

Results show the package body is INVALID

OBJECT_NAME                             STATUS   OWNER  OBJECT_TYPE
------- ------------------------------ ---------- --------- ---------------
CSP_PARTS_REQUIREMENT           VALID     APPS      PACKAGE
CSP_PARTS_REQUIREMENT           INVALID  APPS      PACKAGE BODY

 OR

SELECT object_name,status,owner,OBJECT_TYPE
FROM dba_objects
WHERE object_name='CSP_SCH_INT_PVT';

 

Results returned invalid package body

OBJECT_NAME                             STATUS   OWNER  OBJECT_TYPE
-------------------------------------- ---------- --------- ---------------

CSP_CSH_INT_PVT                       VALID     APPS     PACKAGE
CSP_CSH_INT_PVT                       INVALID  APPS     PACKAGE BODY

 

B) Try to compile Invalid Objects

Run the command at the SQL prompt:

SQL> ALTER PACKAGE CSP_PARTS_REQUIREMENT COMPILE body;

This will show the package body compilation errors.

Warning: Package Body altered with compilation errors.

 

C) Show Package Body Compilation Errors

Run the command at the SQL prompt:

SQL> show error

Results show the actual error in the package

Errors for PACKAGE BODY CSP_PARTS_REQUIREMENT:

PL/SQL: Statement ignored
PLS-00302: component 'G_RESCHEDULE' must be declared
PL/SQL: Statement ignored
PLS-00302: component 'G_RESCHEDULE' must be declared

 OR

Errors for PACKAGE BODY CSP_SCH_INT_PVT;

PLS-00302: component 'G_RESCHEDULE' must be declared
PL/SQL: Statement ignored
PLS-00302: component 'G_RESCHEDULE' must be declared
PL/SQL: Statement ignored

 

Changes

This is known to occur after one or all of the following patches have been applied:(but may not be limited to these.)

 

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