Search Results gl_acct_mst




The GL_ACCT_MST table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical component of the General Ledger (GL) module, serving as the master repository for accounting flexfield segment values and their associated attributes. This table stores the valid combinations of segment values that constitute an account in the Accounting Flexfield structure, ensuring data integrity and consistency across financial transactions. Below is a detailed analysis of its structure, purpose, and significance in Oracle EBS.

Purpose and Role in Oracle EBS

The GL_ACCT_MST table is central to the Chart of Accounts (COA) configuration, which defines the accounting structure used for financial reporting and transaction processing. It stores all valid account combinations derived from the Accounting Flexfield segments (e.g., Company, Cost Center, Account, etc.). This table ensures that only predefined and validated account combinations are used in journal entries, preventing erroneous or unauthorized postings. It acts as a reference for other modules like Accounts Payable (AP), Accounts Receivable (AR), and Assets (FA), which rely on valid account combinations for their transactions.

Key Columns and Structure

The table includes columns that define the account combination and its metadata:
  • ACCOUNT_SEGMENT: Stores the concatenated segment values forming the complete account code (e.g., 01-000-1000-000).
  • SEGMENT1 to SEGMENTN: Individual segment values corresponding to the flexfield structure (e.g., SEGMENT1 for Company, SEGMENT2 for Cost Center).
  • ACCOUNT_TYPE: Classifies the account as Asset, Liability, Revenue, Expense, etc.
  • ENABLED_FLAG: Indicates whether the account combination is active (Y/N).
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the period during which the account is valid.
  • DESCRIPTION: A textual description of the account combination.

Integration with Other Modules

The GL_ACCT_MST table is referenced by transactional tables across Oracle EBS, such as:
  • GL_JE_LINES: Journal entry lines validate account combinations against this table.
  • AP_INVOICE_DISTRIBUTIONS: Invoice distributions use valid accounts from GL_ACCT_MST.
  • FA_DISTRIBUTION_HISTORY: Asset accounting relies on valid account combinations.

Technical Considerations

  1. Indexing: The table is indexed on ACCOUNT_SEGMENT and individual segments for performance optimization.
  2. Flexfield Dependencies: Changes to the Accounting Flexfield structure (e.g., adding a segment) require updates to this table.
  3. Data Security: Access is restricted via Oracle's Data Access Set (DAS) and Security Rules to enforce segregation of duties.

Maintenance and Best Practices

To ensure optimal performance and data accuracy:
  • Regularly purge obsolete account combinations using GL_ACCOUNT_COMBINATIONS_PURGE.
  • Monitor growth to avoid bloating, as excessive combinations can degrade performance.
  • Use the GL_ACCOUNT_COMBINATIONS form or APIs (e.g., FND_FLEX_EXT) for updates.

Conclusion

The GL_ACCT_MST table is foundational to Oracle EBS's financial architecture, ensuring that all transactions adhere to the defined Chart of Accounts. Its design supports rigorous validation, integration with subledgers, and compliance with accounting standards. Proper management of this table is essential for maintaining financial data integrity and system performance.

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

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