My Oracle Support Banner

Getting Errors When Generating Total Compensation Statements When Using Fast Formula That Exceeds 255 Character Limit (Doc ID 605254.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Compensation Workbench - Version 11.5.10 and later
Information in this document applies to any platform.


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 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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.