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''
Last updated on OCTOBER 30, 2017
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 XX 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
bne java/oa/createdoc/webui BneCreateDocumentCO.java 120.0.12020000.22 or higher
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