Search Results acctg_unit_id




Overview
Explore in AI Chat

Overview

The GL_ACCU_MST table is a core master data table within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the repository for user-defined accounting units, which are organizational segments used to construct a flexible account key. These units represent entities such as cost centers, departments, and divisions, enabling detailed financial tracking and reporting. The table's primary role is to define and maintain the valid list of accounting units that can be assigned to transactions, ensuring data integrity and supporting the integration of manufacturing financial data with the Oracle General Ledger.

Key Information Stored

The table's structure is centered on uniquely identifying and describing each accounting unit. The primary key is the ACCTG_UNIT_ID, a system-generated unique identifier. A unique key constraint also exists on the combination of CO_CODE (Company Code) and ACCTG_UNIT_NO (Accounting Unit Number), enforcing business-level uniqueness. While the provided metadata does not list all columns, typical attributes stored would include the accounting unit's description, an effective date range (from/to), status (active/inactive), and creation/modification audit information. The CO_CODE column ties the accounting unit to a specific legal entity or company within the organization.

Common Use Cases and Queries

This table is fundamental for setups, validations, and reporting. A common operational use case is validating that an accounting unit entered on a transaction, such as a purchase order distribution, exists and is active. For reporting, it is frequently joined to transaction tables to translate IDs into meaningful descriptions. Administrators may query it to audit setup or identify unused units.

  • Sample Query to List Active Accounting Units by Company:
    SELECT co_code, acctg_unit_no, description FROM gl_accu_mst WHERE sysdate BETWEEN effective_from AND NVL(effective_to, sysdate) ORDER BY 1, 2;
  • Sample Validation Join for Transaction Data:
    SELECT pdd.*, am.acctg_unit_no FROM po_dist_dtl pdd, gl_accu_mst am WHERE pdd.acctg_unit_id = am.acctg_unit_id;

Related Objects

As indicated by its foreign key relationships, GL_ACCU_MST is a central reference point for numerous other GMF and financial objects. Key related tables include:

  • GL_ACCT_KEY: Accounting units are components of an account key definition.
  • GL_ACCU_MAP & GL_ACCU_VAL: Used for mapping and validating accounting units.
  • GL_SUBR_LED & GL_SUBR_TST: Sub-ledger accounting tables reference the accounting unit.
  • PO_DIST_DTL: Purchase Order distributions can be charged to a specific accounting unit.
  • GL_PLCY_MST: Accounting policies are defined at the company (CO_CODE) level.

These relationships underscore the table's critical function in maintaining referential integrity for financial data across procurement, manufacturing, and general ledger processes.

  • Table: GL_ACCU_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MST,  object_name:GL_ACCU_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key. Note that with Oracle Financial integration, ,  implementation_dba_data: GMF.GL_ACCU_MST , 

  • Table: GL_ACCU_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MST,  object_name:GL_ACCU_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key. Note that with Oracle Financial integration, ,  implementation_dba_data: GMF.GL_ACCU_MST , 

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

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