PAY_US_ACTION_ARCH is Invalid After Patch 22882493:R12.PAY.B (Doc ID 2195046.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Payroll - Version 12.1.3 and later
Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms



When attempting to apply <patch 22882493> :WK PSD BAL ADJ ARE NOT ARCHIVING CURRENT, RESIDENT PSD BAL ADJ IS,
the following package PAY_US_ACTION_ARCH becomes invalid and compiles with error:

ERROR
-----------------------

SQL> ALTER PACKAGE PAY_US_ACTION_ARCH COMPILE BODY;
Warning: Package Body altered with compilation errors.
SQL> sho errors;
Errors for PACKAGE BODY PAY_US_ACTION_ARCH:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6799/7 PL/SQL: SQL Statement ignored
6837/26 PL/SQL: ORA-00904: "PPP"."RUN_RESULT_ID": invalid identifier
6883/7 PL/SQL: SQL Statement ignored
6919/24 PL/SQL: ORA-00904: "PPP"."RUN_RESULT_ID": invalid identifier



Changes

 Apply <patch 22882493> :WK PSD BAL ADJ ARE NOT ARCHIVING CURRENT, RESIDENT PSD BAL ADJ IS

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