FND Lookup Values Comparison between environments – 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
Compares lookup values between the local and a remote database environment
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, Code contains, Language Code, Remote Database, Exclude Language Code, Show Differences only
Oracle EBS Tables Used
fnd_lookup_values, fnd_lookup_values@
Report Categories
Related Reports
GL Balance by Account Hierarchy
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 | Example |
| Blitz Report™ XML Import | FND_Lookup_Values_Comparison_between_environments.xml |
| SQL Source | FND Lookup Values Comparison between environments.sql |
| Full Report 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
© Enginatics GmbH