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 FEBRUARY 11, 2024

Applies to:

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.

• Oracle TeleService: Cannot create Service Request
• Oracle TeleService: Cannot create Task in Service Request Form
  
• Oracle Spares Management: Cannot create Parts Requirement
• Oracle Depot Repair: Cannot create Depot Repair Order
• Oracle Field Service Admin Portal: Open Task, enter Debrief line and submit

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:

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.)

• <Patch:16587433>
  
• <Patch:17855988>
• <Patch:18265289>:R12.CS.B 
• <Patch:24946680>:R12.CS.B
• <Patch:26786698>:R12.CS.B
  
  

Cause

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