Search Results gl_acct_typ_pk




Overview
Explore in AI Chat

Overview

The GL_ACCT_TYP table is a foundational reference table within the Oracle E-Business Suite (EBS) Process Manufacturing Financials (GMF) module. It defines a fixed set of four pre-defined General Ledger account types, providing a high-level classification system for financial accounts. Its primary role is to categorize accounts into broad categories for use within the GMF-specific financial architecture. A critical implementation note from the documentation is that this table is explicitly not used with Oracle Financials integrated setup. This indicates its purpose is specific to the standalone or legacy configuration of Process Manufacturing Financials, rather than the integrated Oracle General Ledger (GL) module.

Key Information Stored

The table's structure is relatively simple, centering on a code and a description for each account type. The primary key is enforced on the ACCT_TYPE_CODE column, ensuring the uniqueness of each type identifier. A unique constraint also exists on the ACCT_TYPE column, preventing duplicate descriptive names. The four pre-defined rows typically represent core financial statement classifications, such as Asset, Liability, Revenue, and Expense, though the exact values are defined by the GMF application's seed data. The table also includes a TEXT_CODE column, which serves as a foreign key to the GL_TEXT_HDR table, allowing for descriptive flexfield associations to store additional context-sensitive attributes for each account type.

Common Use Cases and Queries

The primary use case is as a validation and reporting reference within GMF transactions and master data setups. When defining accounts in the related GL_ACCT_MST table, the ACCT_TYPE_CODE must correspond to a valid value in GL_ACCT_TYP. Common queries involve listing the available types or joining to account master data for reporting. For instance, a basic query to retrieve all account types would be: SELECT acct_type_code, acct_type FROM gmf.gl_acct_typ ORDER BY 1;. A more practical reporting query might join to the account master to summarize accounts by their high-level type: SELECT gat.acct_type, COUNT(*) FROM gmf.gl_acct_mst gam, gmf.gl_acct_typ gat WHERE gam.acct_type_code = gat.acct_type_code GROUP BY gat.acct_type;. Since the table is not used in integrated setups, these queries are relevant only in pure GMF environments.

Related Objects

  • GL_ACCT_MST: This is the primary child table. It stores the detailed chart of accounts, and its ACCT_TYPE_CODE column is a foreign key referencing GL_ACCT_TYP, enforcing that every account is assigned one of the four valid types.
  • GL_TEXT_HDR: The TEXT_CODE column in GL_ACCT_TYP is a foreign key to this table, enabling descriptive flexfield functionality to capture additional, user-defined information for each account type classification.
  • The table has a primary key constraint (GL_ACCT_TYP_PK on ACCT_TYPE_CODE) and a unique constraint (GL_ACCT_TYP_U1 on ACCT_TYPE).