Search Results gl_acct_cls




Overview
Explore in AI Chat

Overview

The GL_ACCT_CLS table is a user-defined reference table within the Oracle E-Business Suite (EBS) Process Manufacturing Financials (GMF) module. Its primary role is to provide a classification mechanism for general ledger accounts, specifically for reporting and analytical purposes. As explicitly noted in the official documentation, this table is a core component of the GMF architecture but is not utilized under an Oracle Financials Integrated setup. This distinction is critical for implementations where GMF operates in a standalone or non-integrated mode with the core Oracle General Ledger (GL). The table enables financial managers to group accounts into custom categories, facilitating specialized internal reporting that aligns with manufacturing cost analysis and management requirements beyond standard financial statements.

Key Information Stored

The central data element stored in the GL_ACCT_CLS table is the account class code, which serves as the unique identifier and primary key for each classification. While the provided metadata does not list all columns, the structure typically includes fields such as the ACCT_CLASS_CODE (the primary key), a descriptive name (e.g., ACCT_CLASS_NAME), an enabled flag, and creation/update audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The ACCT_CLASS_CODE is a VARCHAR2 column that is referenced by other GMF tables to associate specific general ledger accounts with these user-defined reporting categories.

Common Use Cases and Queries

The primary use case for GL_ACCT_CLS is generating custom financial reports for process manufacturing management. For instance, a company might create account classes like "RAW_MATERIAL_VAR", "LABOR_EFFICIENCY", or "OVERHEAD_ABSORPTION" to track and report on manufacturing variances. A common query would involve joining this table to the account master table to list all accounts within a specific class for a report extract.

  • Sample Query: SELECT ga.segment1, ga.segment2, gac.acct_class_code, gac.description FROM gl_acct_mst ga, gl_acct_cls gac WHERE ga.acct_class_code = gac.acct_class_code AND gac.acct_class_code = 'PROD_OVERHEAD';
  • Administrative Use: System administrators may query the table to audit setup: SELECT acct_class_code, description, enabled_flag FROM gl_acct_cls ORDER BY acct_class_code;

Related Objects

The GL_ACCT_CLS table has a direct and essential relationship with the GL_ACCT_MST (Account Master) table, as defined by the foreign key constraint. The ACCT_CLASS_CODE column in GL_ACCT_MST references the primary key in GL_ACCT_CLS, enforcing referential integrity for account classifications. This relationship is fundamental to the GMF data model. Other related objects would likely include GMF-specific reporting views or interfaces that consume account classification data. Crucially, in an integrated Oracle Financials setup, this table and its relationships are bypassed, with classification likely managed through standard GL features like flexfield qualifiers or reporting hierarchies.