Importing User Address Using Update Person.xlsx for Address Type and National Identifier (Doc ID 1630538.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

File Based Loader, when using "Update person.xlsx" there are no values in the drop down lists for either "Address Type" or "National Identifier". When the user enters a value for these fields manually, the following error is displayed in Excel. Due to this, users cannot complete data load or changes.

"The value you entered is not valid. A user has restricted values that can be entered into this cell."

Scenario:
1. Navigator > Data Exchange > Initiate Data Load > Update person.xlsx
2. Goto the Address Type cell, and open the Drop down
3. Notice there is no value, enter a value manually and error is displayed


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms