My Oracle Support Banner

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:

Date strings must be in the format 'yyyy/mm/dd'.

Also the following error can be seen in the log file when trying to generate Total Compensation Statement (BENTCSSP module: Total Compensation Statement Process):

Error in date format:ORA-20001: Value exceeded allowable range (line 16 of TCC_TCS_XXX_XXX_24)
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

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