FND Lookup Values Comparison between environments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Compares lookup values between the local and a remote database environment
Report Parameters
Type, Code contains, Language Code, Remote Database, Exclude Language Code, Show Differences only
Oracle EBS Tables Used
Report Categories
Related Reports
CAC Inventory Pending Cost Adjustment - No Currencies, FND Concurrent Requests 11i, CAC Inventory Lot and Locator OPM Value (Period-End)
Running This SQL Without Blitz Report
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.
Download & Import Options
| 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/ |
Executive Summary
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.
Business Challenge
- 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.
The Solution
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.
Technical Architecture
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.
Parameters & Filtering
- Remote Database: The name of the database link to the other environment.
- Show Differences only: Toggle to hide matching records and focus on discrepancies.
Performance & Optimization
- Network: Performance depends on the speed of the database link. Filter by specific Lookup Types to improve speed.
FAQ
- Q: Do I need a DB Link?
- A: Yes, this report requires a valid database link to the target environment.
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
© 2026 Enginatics