ORA-06508 in API module PAY_ELEMENT_ENTRIES_F and Package PQP_GB_AD_EE Invalid after R12 Apprentice Patch 22710861
Last updated on MARCH 28, 2016
Applies to:Oracle HRMS (UK) - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 version, Install / Upgrade Issues
After applying the R12 Apprentice Solution Patch 22710861:R12.PAY.B to the environment the following error appears on different screens:
APP-PER-51938: The system cannot find the program unit being called. This could be because the application API pre-processor has not been run.
Contact your system administrator quoting the following details: Error ORA-06508 in API module PAY_ELEMENT_ENTRIES_F at hook After Insert.
This error appears because the package PQP_GB_AD_EE is invalid after the patch with the following :
PLS-00302:component 'G_RETRO_SKIP_FLAG' must be declared
The issue can be reproduced at will with the following steps:
1. Apply patch 22710861:R12.PAY.B - Apprentice Solution Patch
2. Add/modify element input values in different screens
3. Compile invalid objects
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms