FND Histogram Columns – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Data from table fnd_histogram_cols, which Oracle uses to identify columns which are expected to have highly skewed data, for example a status column having a large number of closed, but only a small number of open records. The Gather Schema and Gather Table Statistics concurrent programs use this information to create additional histrogram statistics for these columns.

To add a column to this table, use the following API: declare l_table_name varchar2(30):=’AP_INVOICES_ALL’; l_column_name varchar2(30):=’ORG_ID’; begin for c in ( select fpi.application_id from fnd_oracle_userid fou, fnd_product_installations fpi where xxen_util.instring(xxen_api.object_owner_type(l_table_name),’.’,1)=fou.oracle_username and fou.oracle_id=fpi.oracle_id ) loop fnd_stats.load_histogram_cols( action =>’INSERT’, appl_id =>c.application_id, tabname =>l_table_name, colname =>l_column_name, commit_flag =>’Y’); end loop; end;

Report Parameters

Application, Table Name

Oracle EBS Tables Used

fnd_histogram_cols, fnd_application_vl, fnd_product_installations, fnd_oracle_userid

Report Categories

Enginatics

FND Lookup Search, FND Audit Setup, FND Applications, FND Data Groups, CAC Accounting Period Status, CAC Interface Error Summary, FND Concurrent Requests 11i, FND Concurrent Requests, 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 FND Histogram Columns 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import FND_Histogram_Columns.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-histogram-columns/

© 2026 Enginatics