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 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.

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 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

Changes

 Fixed on
bne java/oa/createdoc/webui BneCreateDocumentCO.java 120.0.12020000.22 or higher

Cause

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