FND Tables and Columns – 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

Registered FND tables, columns, primary keys and their flexfields

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

Table Name, Column Name like, Key Columns only

Oracle EBS Tables Used

fnd_application_vl, fnd_tables, fnd_columns, fnd_primary_key_columns, fnd_primary_keys, fnd_descriptive_flexs_vl

Report Categories

Enginatics

FND Flex Value Sets, Usages and Values, FND Descriptive Flexfield Table Columns, FND Audit Setup, FA Mass Additions Upload, FA Mass Additions Upload 11i, Blitz Report Parameter DFF Table Validation, FA Asset Book Details, FND Descriptive Flexfields, INV Item 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 Example
Blitz Report™ XML Import FND_Tables_and_Columns.xml
SQL Source FND Tables and Columns.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-tables-and-columns/

Executive Summary

The FND Tables and Columns report serves as a dynamic data dictionary for the Oracle EBS application. It lists registered tables, their columns, primary keys, and associated descriptive flexfields. This is an invaluable resource for developers, report writers, and data analysts.

Business Challenge

Oracle EBS has thousands of tables. Finding the correct table name, column name, or understanding the primary key structure for a specific entity can be challenging. Documentation is not always up to date with custom extensions or specific patch levels.

The Solution

This report provides an “as-built” view of the database schema as registered in the Application Object Library (AOL). It helps users:

Technical Architecture

The report queries the AOL dictionary tables: fnd_tables, fnd_columns, fnd_primary_keys, and fnd_descriptive_flexs. This ensures the information matches exactly what the application “knows” about the database.

Parameters & Filtering

Performance & Optimization

The report is optimized for metadata querying. Searching by Column Name like with a leading wildcard (e.g., %ID) may be slower than searching by Table Name.

FAQ

Q: Does this include custom tables? A: It includes any custom tables that have been registered in EBS using the AD_DD package or the “Register Table” form. It will not show custom tables that exist in the database but are not registered in AOL.

Q: Why don’t I see a specific view? A: This report focuses on Tables. While some views are registered in fnd_tables, many are not.

© Enginatics GmbH