Last updated on AUGUST 19, 2016
Applies to:Oracle Fusion Benefits Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Data Load
No Start Date and End Date fields in the Postal Code Ranges in Load Service Areas Workbook
There is no ability to populate Start and End Dates in the Manage Postal Code Ranges and Service Areas workbook. These are available for loading the Postal Code ranges themselves, but not for loading the Postal Code Ranges into the Service Areas as it automatically takes the start and end date of the Postal Code Range itself.
This is not a feasible solution as some postal code ranges are used in multiple Service Areas with different effective dates. The only way to change the effective date via Plan Configuration is to scroll down to the correct postal code range within the selected Service Area. Again, this is unacceptable when there are 25,000 postal code ranges.
Start Date and End Date fields in the Postal Code Ranges in Load Service Areas Workbook.
The issue can be reproduced at will with the following steps:
1. Initiate spreadsheet loader for loading postal code ranges
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms