No Start Date And End Date Fields In The Postal Code Ranges In Load Service Areas Workbook
(Doc ID 2172286.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Fusion Benefits Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Benefits - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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
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