My Oracle Support Banner

No Start Date And End Date Fields In The Postal Code Ranges In Load Service Areas Workbook (Doc ID 2172286.1)

Last updated on OCTOBER 17, 2022

Applies to:

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


On : 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

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