Mass Update for Rates Errors out with Message ''SQL error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 occurred processing stored SQL for Content 805:PDW_MASS_UPD_RATES_CNT''
(Doc ID 2309534.1)
Last updated on JULY 07, 2020
Applies to:Oracle Compensation Workbench - Version 12.2.4 and later
Oracle Advanced Benefits - Version 12.2.4 and later
Oracle Human Resources - Version 12.2.4 and later
Oracle Applications Desktop Integrator - Version 12.2.6 and later
Oracle HCM Configuration Workbench - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.
Preparation for a Mass Update of Rates.
When press to download the rates and received the below error
Errors out with message
''SQL error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 occurred processing stored SQL for Content 805:PDW_MASS_UPD_RATES_CNT''
Steps to Reproduce:
1. Navigate to US HRMS Responsibility
2. Select Total Compensation Setup wizard
3. Select Health and Welfare Program
4. Click Mass Update of Rates
Enter Date - 27-DEC-2017
Select PDW Employee Benefits Program
Date Track Mode - Make changes from effective date onwards
Select Plan Type - Medical
Plan - Health Plan II
5. Hit Go and Click on Download to Spreadsheet
6. Click Create
And the error displays
Fixed in BneCreateDocumentCO.java 120.0.12020000.22 or higher
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