Rates Upload Spreadsheet Not Uploading Any Rates (Doc ID 1594324.1)

Last updated on DECEMBER 13, 2020

Applies to:

Goal

On : 11.1.5.0.0 version, Manage Benefits-Manage Benefit Plans, Programs, and Events

Rates Upload Spreadsheet not uploading any rates

Q1: When trying to upload all the benefit plan rates starting from 1st Jan 2014 after downloading the rates, none of the rates are getting uploaded into the system. The status of the uploaded rows says "Successfully Uploaded". However, none of the rates got updated in the system and the old rate values still remain.

navigation steps below:

1) Login to Fusion Application
2) Navigate to Navigator>Benefits>Plan Configuration
3) Click on Manage Benefit Rates under Manage Rates and Coverages so that the standard rates tab is highlighted.
4) Change the effective As of Date field to 1/1/2014 and click on search after choosing any plan name in the plan name field.
5) Once the results of standard rates of chosen plan gets puled, click on 'Edit Rates in Workbook' button. I believe you can also skip step 4 and directly click on edit rates in workbook.
6) Once the workbook opens, give the effective date as 1/1/2014 and download the rate rows after applying any required filter like name of the standard rate followed by % and status of 'Active'
7) Update the rate value column alone, and click on upload button.
8) At the end once the process completes, all the rows show as Successfully Uploaded. But none of the rate rows are updated in the application.


or


Q2: When primary and secondary rates are being simultaneously updated, the spread sheet upload is failing without any obvious error.
 

Solution

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