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

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

Symptoms

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

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