Last updated on MARCH 08, 2017
Applies to:Oracle Advanced Benefits - Version 11.5.10 and later
Information in this document applies to any platform.
*** Archived on 20-Apr-2015 ***
On 220.127.116.11 in Production:
When attempting to run the Total Compensation Statement Generate Employee Statement process for one employee to retrieve the 401 ER Match for more than 23 pay periods, the following error occurs:
ORA-06502: PL/SQL: numeric or value error
error in date format:ORA-20001: ORA-6503 occurred at line 15 of formula XX 401k Flat ER TCS Element
Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are given where available
Action: Please refer to your system administrator.
Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Created PL/SQL Function to retrieve the amount of 401k ER Match paid for and Employee for each
Pay Period in a Statement Period.
2. Created Formula Function to call the PL/SQL Function created above.
3. Created Fast Formula of type 'Compensation Item Rule' to call the Formula Function from above.
4. Created Compensation Item and assigned the 'Compensation Item Rule' created above.
When the statement is run for an Employee for more than 23 Pay Periods, the Generated Employee
Statement Process errors out when trying to retrieve the 401 ER Match.
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