Search Results gl_acct_mst




Overview
Explore in AI Chat

Overview

The GL_ACCT_MST table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for a company's specific Chart of Accounts. This table is central to financial accounting within the GMF environment, storing the definitive list of all general ledger accounts available for transactional posting. In an integrated setup with Oracle Financials, this table is populated with Oracle Financials account data during the configuration of Account Mapping, thereby linking manufacturing and financial operations.

Key Information Stored

The table's primary identifier is the ACCT_ID column, which forms the primary key GL_ACCT_MST_PK. A unique key constraint (GL_ACCT_MST_U1) also exists on the combination of CO_CODE (Company Code) and ACCT_NO (Account Number), enforcing uniqueness at the company level. Beyond these keys, the table stores descriptive and classificatory attributes for each account. Critical columns include ACCT_CLASS_CODE, ACCT_TYPE_CODE, and ACCT_USAGE_CODE, which are foreign keys to their respective reference tables (GL_ACCT_CLS, GL_ACCT_TYP, GL_ACCT_USG). Other significant fields are TEXT_CODE for descriptive text, QUANTITY_UM for the unit of measure (linked to SY_UOMS_MST), and a foreign key to GL_PLCY_MST via CO_CODE for company policy linkage.

Common Use Cases and Queries

A primary use case is the validation and reporting of the Chart of Accounts. Financial analysts and system administrators frequently query this table to audit account setup, generate account listings, or troubleshoot mapping issues. Common SQL patterns include retrieving all active accounts for a specific company or joining with reference tables to get full descriptive information. For example:

  • SELECT acct_no, acct_name FROM gl_acct_mst WHERE co_code = :company_code ORDER BY acct_no;
  • SELECT a.acct_no, a.acct_name, c.meaning as account_class FROM gl_acct_mst a, gl_acct_cls c WHERE a.acct_class_code = c.acct_class_code AND a.co_code = :company_code;

The table is also integral to transactional processes in GMF, where its ACCT_ID is referenced to determine the correct general ledger account for distribution lines in procurement (PO_DIST_DTL) and subledger accounting (GL_SUBR_LED, GL_SUBR_TST).

Related Objects

GL_ACCT_MST is a central hub with numerous dependencies. It is referenced by several key transactional and setup tables. Primary foreign key relationships are established with the reference tables GL_ACCT_CLS, GL_ACCT_TYP, GL_ACCT_USG, GL_PLCY_MST, GL_TEXT_HDR, and SY_UOMS_MST. Crucially, its data is directly utilized by the account mapping table (GL_ACCT_MAP via ACCT_ID) and the account validation table (GL_ACCT_VAL via CO_CODE and ACCT_NO). Transactionally, it is referenced by procurement distributions (PO_DIST_DTL) and GMF subledger tables (GL_SUBR_LED, GL_SUBR_TST). The GL_ACCT_KEY table also holds a foreign key reference to it, linking account keys to the master account definition.

  • 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 , 

  • 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_ACCT_CLS 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_CLS,  object_name:GL_ACCT_CLS,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: User-defined Account classes. These classes are used to classify accounts and are used for reporting purposes only. Note that this table is not used under Oracle Financials Integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_CLS , 

  • 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_KEY 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_KEY,  object_name:GL_ACCT_KEY,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: *NOT USED* ,  implementation_dba_data: GMF.GL_ACCT_KEY , 

  • Table: GL_ACCT_KEY 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_KEY,  object_name:GL_ACCT_KEY,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: *NOT USED* ,  implementation_dba_data: GMF.GL_ACCT_KEY , 

  • 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_USG 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_USG,  object_name:GL_ACCT_USG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the user-defined Acount Usages. These codes are used for reporting purposes only. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_USG , 

  • Table: GL_ACCT_USG 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_USG,  object_name:GL_ACCT_USG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the user-defined Acount Usages. These codes are used for reporting purposes only. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_USG , 

  • Table: GL_ACCT_VAL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_VAL,  object_name:GL_ACCT_VAL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains validation codes assignment to Accounts. The Accounts may only be auto-generated with the Accounting unit with same Validation codes. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_VAL , 

  • Table: GL_ACCT_CLS 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_CLS,  object_name:GL_ACCT_CLS,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: User-defined Account classes. These classes are used to classify accounts and are used for reporting purposes only. Note that this table is not used under Oracle Financials Integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_CLS , 

  • Table: GL_SUBR_LED 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_SUBR_LED 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_SUBR_TST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST,  object_name:GL_SUBR_TST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Update. ,  implementation_dba_data: GMF.GL_SUBR_TST , 

  • 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_VAL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_VAL,  object_name:GL_ACCT_VAL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains validation codes assignment to Accounts. The Accounts may only be auto-generated with the Accounting unit with same Validation codes. This table is not used with Oracle Financials integrated setup. ,  implementation_dba_data: GMF.GL_ACCT_VAL , 

  • Table: GL_PLCY_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST , 

  • Table: GL_SUBR_TST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST,  object_name:GL_SUBR_TST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Update. ,  implementation_dba_data: GMF.GL_SUBR_TST , 

  • Table: GL_PLCY_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST , 

  • Table: GL_ACCT_MAP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP , 

  • View: GLEX_VIEW 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GLEX_VIEW,  object_name:GLEX_VIEW,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Glex view ,  implementation_dba_data: APPS.GLEX_VIEW , 

  • View: GLEX_VIEW 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GLEX_VIEW,  object_name:GLEX_VIEW,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Glex view ,  implementation_dba_data: APPS.GLEX_VIEW , 

  • Table: GL_ACCT_MAP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP ,