| layout | default |
|---|---|
| title | FND Lookup Values Comparison between environments | Oracle EBS SQL Report |
| description | Compares lookup values between the local and a remote database environment – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Lookup, Values, Comparison, fnd_lookup_values |
| permalink | /FND%20Lookup%20Values%20Comparison%20between%20environments/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Compares lookup values between the local and a remote database environment
Type, Code contains, Language Code, Remote Database, Exclude Language Code, Show Differences only
CAC Inventory Pending Cost Adjustment - No Currencies, FND Concurrent Requests 11i, CAC Inventory Lot and Locator OPM Value (Period-End)
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | FND_Lookup_Values_Comparison_between_environments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-lookup-values-comparison-between-environments/ |
The FND Lookup Values Comparison between environments report is a migration validation tool. It compares the lookup configurations between the current instance (e.g., PROD) and a remote instance (e.g., DEV) via a database link.
- Migration Verification: Ensuring that all new lookup codes created in DEV have been successfully migrated to PROD.
- Drift Analysis: Identifying configuration changes made directly in PROD that are missing from DEV.
- Sync Check: Verifying that lookup descriptions match across environments.
This Blitz Report compares the two datasets:
- Match: Identifies codes that exist in both but have different descriptions or enabled statuses.
- Missing: Identifies codes that exist in one environment but not the other.
The report uses a DB Link to query the remote FND_LOOKUP_VALUES table and compares it with the local table using MINUS or FULL OUTER JOIN logic.
- Remote Database: The name of the database link to the other environment.
- Show Differences only: Toggle to hide matching records and focus on discrepancies.
- Network: Performance depends on the speed of the database link. Filter by specific Lookup Types to improve speed.
- Q: Do I need a DB Link?
- A: Yes, this report requires a valid database link to the target environment.
- 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
© 2026 Enginatics