FSG Drilldown Diagnostic – Oracle EBS SQL Report

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

Overview

Troubleshooting report for FSG journal drilldown issues. Checks gl_balances, posted/unposted journals, period status, account properties, and flex value security for a given account and period. Use the GL segment parameters to filter to the specific account combination that is not drilling down.

Report Parameters

Ledger, Period, GL_SEGMENT1, GL_SEGMENT2, GL_SEGMENT3, GL_SEGMENT4, GL_SEGMENT5, GL_SEGMENT6, GL_SEGMENT7, GL_SEGMENT8, GL_SEGMENT9

Oracle EBS Tables Used

gl_code_combinations_kfv, gl_ledgers, gl_balances, gcck, gl_je_headers, gl_je_lines, gl_period_statuses, gl_periods, gl_code_combinations

Report Categories

Enginatics

AP Accounted Invoice Aging, GL Balance Drilldown, GL Account Distribution Analysis, GL Account Analysis, GL Code Combinations

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
Blitz Report™ XML Import FSG_Drilldown_Diagnostic.xml
Full SQL on Enginatics www.enginatics.com/reports/fsg-drilldown-diagnostic/

© 2026 Enginatics