ORA-06508 in API module PAY_ELEMENT_ENTRIES_F and Package PQP_GB_AD_EE Invalid after R12 Apprentice Patch 22710861

(Doc ID 2118047.1)

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.

Symptoms

On : 12.1.3 version, Install / Upgrade Issues

Problem Statement:

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 :

ERROR
PLS-00302:component 'G_RETRO_SKIP_FLAG' must be declared

 

STEPS
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


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