Search Results gl_acct_typ




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).
  • Table: GL_ACCT_TYP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TYP,  object_name:GL_ACCT_TYP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table consists of four pre-defined General Ledger account types which are used to classify accounts into four broad categories. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_TYP , 

  • Table: GL_ACCT_TYP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TYP,  object_name:GL_ACCT_TYP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table consists of four pre-defined General Ledger account types which are used to classify accounts into four broad categories. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_TYP , 

  • Table: GL_ACCT_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MST,  object_name:GL_ACCT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information. ,  implementation_dba_data: GMF.GL_ACCT_MST , 

  • Table: GL_TEXT_HDR 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_TEXT_HDR,  object_name:GL_TEXT_HDR,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Table used to store text types for GL ,  implementation_dba_data: GMF.GL_TEXT_HDR , 

  • Table: GL_TEXT_HDR 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_TEXT_HDR,  object_name:GL_TEXT_HDR,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Table used to store text types for GL ,  implementation_dba_data: GMF.GL_TEXT_HDR , 

  • Table: GL_ACCT_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MST,  object_name:GL_ACCT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information. ,  implementation_dba_data: GMF.GL_ACCT_MST ,