Adding Variable Rates Is Not Uploading Wtih The Effective Date As Entered In The Spreadsheet (Doc ID 2434872.1)

Last updated on MARCH 12, 2024

Applies to:

Goal

Oracle Fusion Benefits Cloud Service
Release 11.13.18.05.0

Adding Variable Rates is not uploading with the effective date as entered in the spreadsheet

Upgraded to R13. is not allowing client to upload variable rates for 01-JAN-1951, instead it is using the system date 13-AUG-2018. This not what is outlined in the R13 white paper:

Creating and Editing Variable Rate Profiles and Adding them to Standard
Rates
Use the two worksheets in the workbook to:
• Create and edit your variable rate profiles in the variable rate profiles worksheet.
• Associate existing and newly uploaded variable rate profiles with standard rates in the standard Rates worksheet.

On both worksheets:
1. Select a calculation method. The calculation method for all rows must match the calculation method for the workbook, which you selected in the Search section. Mismatches result in errors when you upload your data.
2. Optionally, enter an effective as-of date. The download process uses the date as a constraint when downloading either the variable rate profiles or the standard rates. The upload process uses it to set the effective date for the new and edited profiles and edited standard rates. If you leave this field blank, the upload process sets the current date, also known as the system date, as the effective date.

Client has several variable rates that need to be created with an effective date of 01-JAN-1951. How do they correct this to get the rates to load? Do they load as the today's date and Oracle corrects the date back to 1951? this does not make sense, Client has over 100+ variable rates that need to be created today.

"Changes are effective as of date" is message from process.

Solution

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