GL Period Status – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports
Overview
Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an accounting period should be opened, use the CAC Accounting Period Status report, as it has more reporting options and features.
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
Period From, Period To, Ledger, Chart of Accounts, Application
Oracle EBS Tables Used
fnd_application_vl, gl_ledgers, hr_operating_units, gl_periods, xxen_report_org_access, gl_period_statuses, org_organization_definitions, org_acct_periods
Report Categories
Related Reports
INV Material Account Distribution Detail, AP Accounted Invoice Aging, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Lot and Locator OPM Value (Period-End), CAC OPM Batch Material Summary, CAC OPM WIP Account Value, CAC Accounting Period Status, CAC Material Account Alias with Lot Numbers
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 | GL_Period_Status.xml |
| SQL Source | GL Period Status.sql |
| Full Report on Enginatics | www.enginatics.com/reports/gl-period-status/ |
GL Period Status - Case Study & Technical Analysis
Executive Summary
The GL Period Status report provides a centralized view of the accounting period statuses across all Oracle EBS modules (GL, AP, AR, PO, INV, etc.). It allows finance managers and system administrators to quickly verify which periods are Open, Closed, or Permanently Closed for specific ledgers and operating units. This report is a critical tool for managing the month-end close process efficiently.
Business Use Cases
- Month-End Close Monitoring: Provides a single dashboard to check if all subledgers (Payables, Receivables, Inventory) have been successfully closed before closing the General Ledger.
- Troubleshooting Posting Errors: Helps identify if a transaction failed to post because a specific module’s period was accidentally closed or never opened.
- Audit Compliance: Documents the precise status of periods at a given point in time, proving that periods were closed in a timely manner.
- Multi-Org Management: Essential for shared service centers managing dozens of entities, allowing them to see the status of all ledgers in one list.
Technical Analysis
Core Tables
GL_PERIOD_STATUSES: The primary table storing the status (O=Open,C=Closed,F=Future,N=Never Opened) for each application and period.FND_APPLICATION_VL: Resolves the Application ID to a name (e.g., “General Ledger”, “Payables”).GL_LEDGERS: Defines the ledger context.HR_OPERATING_UNITS: Links subledger statuses to their respective Operating Units.ORG_ACCT_PERIODS: (For Inventory) Stores the specific period statuses for Inventory Organizations.
Key Joins & Logic
- Cross-Module Aggregation: The query likely unions data from
GL_PERIOD_STATUSES(for financial modules) andORG_ACCT_PERIODS(for inventory) to provide a unified view. - Status Decoding: Translates the internal status codes (O, C, F, N, P) into user-friendly descriptions.
- Hierarchy Resolution: Links Inventory Orgs to Operating Units and Operating Units to Ledgers to allow filtering at any level of the organization structure.
Key Parameters
- Period From/To: The range of periods to check.
- Ledger: Filter by specific ledger.
- Application: Filter by specific module (e.g., show only “Payables” status).
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