My Oracle Support Banner

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 FEBRUARY 15, 2019

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.

Symptoms

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

Changes

 Fixed in BneCreateDocumentCO.java 120.0.12020000.22 or higher

Cause

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
Symptoms
Changes
Cause
Solution
References

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