Getting Errors When Generating Total Compensation Statements When Using Fast Formula That Exceeds 255 Character Limit
Last updated on JANUARY 04, 2018
Applies to:Oracle Compensation Workbench - Version 11.5.10 and later
Information in this document applies to any platform.
On 22.214.171.124 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:
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 eachPay 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