My Oracle Support Banner

Edit Rates In Worksheet Loader Not Working In R13 (Doc ID 2424667.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Oracle Fusion Benefits Cloud Service - Version and later
Information in this document applies to any platform.


Edit Rates in Worksheet Loader not working in R13

The spreadsheet loader is not returning data after filling in the criteria parameters and clicking Search. We have even tried to search on one specific rate name and receive no data. In trying to test the upload functionality of the loader we found that the new Copy Calculation Method Data to All Rates that was introduced in R13 has removed the following Calculation Method columns that are necessary to change rates - Value (which is a required column in R12), Minimum Election Value, Increment, Maximum Election Value, Default Value, Annual Minimum Election Value, and Annual Maximum Election Value. When attempting to upload the data it is trying to apply session date instead of using the effective date used in the row and the parameters. We now have no way to upload our 2019 Open Enrollment rates. There is no work around available at this time.

User should be able to search and have the rates appear in the spreadsheet so they can edit and upload

The issue can be reproduced at will with the following steps:
1. Benefits Administration > Plan Configuration > Rates and Coverages > Standard Rates > Edit Rates in Workbook.
2. Once clicking on the Edit Rates in Workbook button it launches the Upload_Rates document.
3. Once the document is downloaded we click Review and Unprotect Sheet, choose the following:
  a) Calculation method from the Calculation Formula LOV (i.e. Flat Amount)
  b) Rate Display Type from the LOV (i.e. Pre Tax)
  c) Status from the LOV (i.e. Active)
4. Click the Edit Rates tab, and click Search.
5. The spreadsheet should retrieve all the rates that meet the criteria, but we get no data.


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

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