FND Lookup Upload creates and updates Oracle EBS lookup types and their lookup codes from Excel, for user and extensible lookups, in your current language. Add new codes to an existing lookup type, create new user 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 lookup type.
- Create one or more new user lookup types with their codes in a single template.
- Re-label lookup codes by updating their meanings and descriptions in bulk.
- Enable or disable lookup codes, or set an end date to retire them.
- Populate the descriptive flexfield attributes on lookup codes.
- Move user-defined lookups between environments by downloading from one and uploading to another.
Before you start
- Blitz Report is installed and you are signed in to a responsibility that can maintain lookups (Application Developer or System Administrator level).
- The lookup type is a User or Extensible type – system lookups cannot be maintained, and seeded codes in extensible types are protected.
- To create a new lookup type, you have 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 – adds the owning application, type meaning and type description columns – together with their codes. |
Step 1 – Choose a template and mode, set the parameters and download
In Blitz Report, open FND Lookup Upload, choose your template, and set the parameters:
| Parameter | Purpose |
|---|---|
| Mode | Create (new only), Create, Update (download and update existing, or add new), or Update (update codes under existing types only). Default is Update. |
| View Application | The application whose lookups you are working with. |
| Lookup Type / Lookup Type Like | The lookup type(s) to download – exact, or by wildcard. |
| Owning Application | Optionally filter by the application that owns the lookup type. |
Run the upload to download and open the Excel file. Each row is automatically handled as a create or an update depending on whether the code already exists.
Step 2 – Enter the lookup codes
On each row the Lookup Type, View Application and Lookup Code identify the code – these cannot be changed on an existing code. Enter the Meaning (required, and unique within the lookup type), a Description and Tag, the Enabled Flag, and the Start / End Date Active. To create a new lookup type (Lookup Types template) also fill the Owning Application, Type Meaning and Type Description.
Step 3 – Validate and Save
Click Validate and Save. This checks for missing required values and runs any extra validation the upload defines, then saves the file. Correct anything it flags before continuing.
Step 4 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates each lookup type and code. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated lookup types and their codes.
- 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 the Enabled Flag to No.
Why can’t I change a code’s lookup type or view application on update?
Those are the code’s identity. Changing them is rejected – create a new code instead.
Why is my system lookup type rejected?
Only User and Extensible lookup types can be maintained. System lookups are not editable here.
I can’t update a code in an extensible type – why?
Seeded codes in extensible types are protected; you can only add or maintain your own user-added codes.
Why was my Meaning rejected as duplicate?
A meaning must be unique among the codes of a lookup type; another code already uses it.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Invalid View Application | The View Application does not match a registered application. | Pick the View Application from the list. |
| You cannot create a new Lookup Type in this Mode | Mode is Update but the lookup type does not yet exist. | Switch Mode to Create or Create, Update and use the Lookup Types template. |
| Type Meaning and Owning Application must be specified for a new Lookup Type | Creating a new type without its required type-level fields. | Use the Lookup Types template and fill Type Meaning and Owning Application. |
| Cannot modify system lookup types / seeded codes | Trying to change a system type, or a seeded code in an extensible type. | Only maintain User types and your own user-added codes. |
| Meaning cannot be duplicated across lookups | The Meaning is already used by another code in the same type. | Use a unique Meaning. |