Variable WRITE_REC8 not initialized at line 494 of IE_P35_DETAIL (Doc ID 2220026.1)

Last updated on JULY 11, 2017

Applies to:

Oracle HRMS (Ireland) - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

After RUP 9 and 2016 year end patches for Ireland, when running the IE P35 XML Report, customer is getting the following error :

NO_OF_CONTEXTS = 1

Variable WRITE_REC8 not initialized at line 494 of IE_P35_DETAIL

Cause: An attempt has been made to use a local variable before it was ini
tialized. This is normally detected by the verifier, but in certain case

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: The status of this assignment action was invalidly updated

This error may be caused by an internal problem or by poor SQL scripts. Contact
 your System Administrator.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.PAY_ASSIGNMENT_ACTIONS_BRU", line 60
ORA-04088: error during execution of trigger 'APPS.PAY_ASSIGNMENT_ACTIONS_BRU'

SQL_NO 591
TABLE_NAME PAY_ASSIGNMENT_ACTIONS
APP-PAY-06881: Error ORA-20001: The status of this assignment action was invalidly updated

This error may be caused by an internal problem or by poor SQL scripts. Contact your System Administrator.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.PAY_ASSIGNMENT_ACTIONS_BRU", line 60
ORA-04088: error during execution of trigger 'APPS.PAY_ASSIGNMENT_ACTIONS_BRU'
 has occurred in table PAY_ASSIGNMENT_ACTIONS at location 591

Cause: an oracle error has occurred. The failure was reported on table PAY_ASSIGNMENT_ACTIONS at location 591 with the error text ORA-20001: The status of this assignment action was invalidly updated


 
STEPS
The issue can be reproduced at will with the following steps:
1. Apply RUP 9 and 2016 year end legislative patch for Ireland
2. Run IE P35 XML Report with an End Date of 31 Dec 2016 and 53 Weeks = Yes
3. Notice the above error

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