Compensation Item Rule Error "Date strings must be in the format 'yyyy/mm/dd'"
(Doc ID 1557512.1)
Last updated on JUNE 10, 2021
Applies to:Oracle Compensation Workbench - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.
When attempting to use a Compensation Item Rule for the Total Compensation Statement in the outbound variable 'COMPENSATION_DATES' when more than 23 dates are returned, the following error occurs:
Also the following error can be seen in the log file when trying to generate Total Compensation Statement (BENTCSSP module: Total Compensation Statement Process):
Cause: Caused by Oracle error 6502 occurring during the execution of the formula which is raised when an arithmetic conversion error, or string truncation error occurs. This can also be caused by invalid dates, for example 39-DEC-1991, 24-MAR-5000
Action: Check your formula for possible invalid dates, numbers or strings greater than 255 characters in length.
The issue can be reproduced at will with the following steps:
1. Go to responsibility US Super HRMS Manager.
2. Write Compensation Item Rule and attach it to a Compensation Item in Total Compensation Statement.
3. Attempt to Generate Employee Statements.
Error occurs on the Error Report.
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