FND Lookup Upload creates and updates Oracle EBS lookup types and their lookup codes from Excel, for User and Extensible lookup types, in your current session language. Add new codes to an existing lookup type, create new lookup types with their codes, or update the meanings, descriptions, tags, enabled status and active dates of existing codes.
When to use it
- Mass-load new lookup codes into an existing User or Extensible lookup type.
- Create one or more new lookup types together with their codes.
- Re-label lookup codes by updating their meanings and descriptions in bulk.
- Disable lookup codes, or set an end date to retire them.
- Load translated meanings and descriptions by uploading in a session of the target language.
- Copy user-defined lookups between environments by downloading from one and uploading to another.
Before you start
- Access to the upload in Blitz Report.
- The lookup type is a User or Extensible type. System lookup types cannot be maintained, and in Extensible types the seeded codes are protected.
- To create a new lookup type, you know its meaning and owning application.
Choose a template
| Template | Use it for |
|---|---|
| Lookup Codes – Create/Update Lookup Codes only (default) | Adding or updating lookup codes under an existing lookup type. |
| Lookup Types – Create/Update Lookup Types and Codes | Creating new lookup types, or changing the meaning or description of an existing User lookup type, together with their codes. Adds the Owning Application, Type Meaning, Type Description and descriptive flexfield columns. |
Step 1 – Set the parameters
Open FND Lookup Upload in Blitz Report, choose the template and set the parameters:
| Parameter | Meaning |
|---|---|
| Upload Mode | Create opens an empty sheet; Create, Update (default) downloads existing codes for editing and lets you add new ones; Update only updates existing codes and rejects rows for codes that do not exist. |
| Create Empty File | Yes downloads an empty sheet whatever the mode, for example to paste translations for an Update upload. Defaults to Yes for Create. |
| View Application | The application the lookup types are registered under (Application Object Library for most user lookups). |
| Lookup Type | The lookup type(s) to download. |
| Lookup Type Like | Downloads all lookup types whose name contains this text. |
| Owning Application | Restricts the download to lookup types owned by this application. |
Unless you create an empty file, enter a Lookup Type or Lookup Type Like.
Step 2 – Run to download the Excel file
Click Run. The Excel file downloads and opens with one row per existing lookup code, or an empty sheet.
Step 3 – Enter or change the lookup codes
Lookup Type, View Application and Lookup Code identify a code and cannot be changed on a downloaded row. Change the Meaning, Description, Tag, Enabled Flag or Start Date Active / End Date Active of a downloaded row, or add rows with the Lookup Type, View Application, Lookup Code and a Meaning that is unique within the lookup type. New rows default Enabled Flag to Yes and Start Date Active to today. New lookup types and codes are stored in upper case. To create a new lookup type, use the Lookup Types template and also enter the Owning Application and Type Meaning.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.
Step 5 – Upload the file
In Blitz Report click Upload and select the saved file. This submits the upload request, which creates or updates each lookup type and code.
Step 6 – Review the result report
When the request completes, a result report opens listing every uploaded row with its status and message.
What’s produced
- Lookup types and lookup codes created or updated in your current language.
- A result report listing every row with a status (success or error) and a message.
Common questions
Can I delete a lookup code or type?
No. The upload only creates and updates. To retire a code, set its End Date Active or set Enabled Flag to No.
Which language are meanings and descriptions written in?
The language of your session. To load translations, download an empty file (Create Empty File = Yes), paste the codes with their translated meaning and description, and upload in Update mode from a session in that language, so no new codes are created by mistake.
Why is my system lookup type rejected?
Only User and Extensible lookup types can be maintained. System lookup types are not editable.
Why can’t I update a code in an Extensible lookup type?
Seeded codes in Extensible types are protected; you can only add and maintain your own codes.
Can I change the meaning of an existing lookup type?
Yes for User lookup types, using the Lookup Types template. The meaning and description of System and Extensible types, and the owning application of any type, cannot be changed.
Why was my lookup code stored in upper case?
New lookup types and codes are converted to upper case, as in the Lookups window. Existing mixed-case types and codes keep their case.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Invalid View Application | The View Application is not a registered application. | Pick the View Application from the list. |
| Invalid Lookup Type – You cannot create a new Lookup Type in this Mode | Upload Mode is Update and the lookup type does not exist. | Check the lookup type name, or create it in Create or Create, Update mode with the Lookup Types template. |
| Lookup Code … does not exist. Upload Mode Update does not create new Lookup Codes | Upload Mode is Update and the code is new. | Correct the code, or upload in Create, Update mode. |
| Type Meaning, Description, and Owning Application must be specified for a new Lookup Type | A new lookup type without its Type Meaning or Owning Application. | Use the Lookup Types template and fill Type Meaning and Owning Application. |
| Cannot Modify System Lookup Types | The lookup type is a System type. | Only User and Extensible types can be maintained. |
| Cannot Modify Seeded Lookup Codes in this Lookup Type | The code is a seeded code in an Extensible type. | Maintain only your own codes in that type. |
| Lookup Type Meaning and Description cannot be modified for System and Extensible Lookup Types | A changed Type Meaning or Type Description on a System or Extensible type. | Leave the type-level columns unchanged. |
| Lookup Type Application cannot be modified | A changed Owning Application on an existing lookup type. | Keep the existing owning application. |
| Meaning cannot be duplicated across Lookups | Another code in the same lookup type already uses this Meaning. | Enter a unique Meaning. |
| The following fields exceed the maximum size | A value is longer than allowed (Lookup Type and Lookup Code 30, Meaning 80, Description 240, Tag 150 characters). | Shorten the listed values. |