FND Lookup Values – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Lookup types and values, for example to find a lookup type for a particular lookup code value or meaning.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Type, View Application, Code contains, Meaning contains, Description contains, Creation Date From, Creation Date To, Created By, Language Code, Missing Translation to Lang Code, DFF Display
Oracle EBS Tables Used
fnd_application_vl, fnd_lookup_types_vl, fnd_lookup_values, fnd_languages
Report Categories
Related Reports
INV Item Upload, GL Balance by Account Hierarchy, GL Account Analysis, AP Invoice Upload
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Lookup Values 27-Jul-2018 212911.xlsx |
| Blitz Report™ XML Import | FND_Lookup_Values.xml |
| SQL Source | FND Lookup Values.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-lookup-values/ |
Executive Summary
The FND Lookup Values report is the standard dictionary for all lookup codes in the system. It allows you to search for codes, meanings, or descriptions across all lookup types.
Business Challenge
- Configuration Review: Checking the list of available values for a dropdown list (e.g., “Payment Terms” or “Vendor Types”).
- Translation Gap Analysis: Finding lookup codes that are missing translations in a multi-language environment.
- Search: Finding which Lookup Type contains a specific code (e.g., finding where ‘NET30’ is defined).
The Solution
This Blitz Report lists the full lookup definition:
- Type: The parent Lookup Type.
- Code: The internal code stored in the database.
- Meaning: The user-visible text.
- Description: Additional details.
- Effectivity: Start/End dates and Enabled flag.
Technical Architecture
The report queries FND_LOOKUP_TYPES_VL and FND_LOOKUP_VALUES. It handles the language join to show translations.
Parameters & Filtering
- Type: Filter by the specific lookup type (e.g.,
YES_NO). - Meaning contains: Search for a specific text string across all lookups.
- Missing Translation to Lang Code: A powerful filter to find codes that exist in the base language but not in the target language.
Performance & Optimization
- Volume: There are thousands of lookup types. Always filter by Type or Application to avoid a massive export.
FAQ
- Q: Can I see System lookups?
- A: Yes, this report shows all lookups (System, User, and Extensible).
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH