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 10, 2024
Applies to:
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]
Oracle Spares Management - 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.
- 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
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 |
Changes |
Cause |
Solution |
References |