Skip to content

GL Period Status

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

GL Period Status

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
GL Period Status.sql
GL Period Status.sql
 
 
README.md
README.md
 
 

README.md

layout default
title GL Period Status | Oracle EBS SQL Report
description Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Period, Status, fnd_application_vl, gl_ledgers, hr_operating_units
permalink /GL%20Period%20Status/

GL Period Status – Oracle EBS SQL Report

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

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.

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, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, gl_period_statuses, org_organization_definitions, org_acct_periods

Report Categories

Enginatics

Related Reports

CAC Receiving Expense Value (Period-End), CAC OPM Batch Material Summary, CAC Receiving Account Detail, CAC Inventory Periods Not Closed or Summarized, CAC Receiving Account Summary, CAC Missing Receiving Accounting Transactions, CAC Missing Material Accounting Transactions, CAC Missing WIP Accounting Transactions

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 None
Blitz Report™ XML Import GL_Period_Status.xml
Full SQL 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) and ORG_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

© 2026 Enginatics