Search Results gl_accu_map




Overview
Explore in AI Chat

Overview

The GL_ACCU_MAP 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 functions as a mapping table that establishes the relationship between accounting units and specific organizational entities. Its primary role is to define which accounting unit, from the GL_ACCU_MST table, is applicable for financial transactions based on a combination of company, organization, and warehouse. This mapping is critical for ensuring that manufacturing and inventory costs are posted to the correct general ledger accounts, thereby enabling accurate financial reporting and cost accounting for process manufacturing operations.

Key Information Stored

The table stores mapping records defined for a mandatory company code and optional organization and warehouse codes. A blank value for the optional fields signifies the mapping applies to "all" values for that dimension. Key columns include the surrogate primary key ACCU_MAP_ID and the unique key combination of CO_CODE, ORGN_CODE, and WHSE_CODE. The central mapping column is ACCTG_UNIT_ID, which holds a foreign key reference to the GL_ACCU_MST table, identifying the specific accounting unit to be used. Other critical foreign key columns are CO_CODE (referencing GL_PLCY_MST), ORGN_CODE (referencing SY_ORGN_MST), and WHSE_CODE (referencing IC_WHSE_MST), which tie the mapping to master data for legal entity, inventory organization, and warehouse, respectively.

Common Use Cases and Queries

The primary use case is the GL Mapping program, which utilizes this table to determine the appropriate accounting unit during transaction processing, such as inventory cost updates, production variance accounting, and period-end close activities. A common reporting need is to review all defined mappings for a specific company. A sample query for this would be:

  • SELECT co_code, orgn_code, whse_code, acctg_unit_id FROM gl_accu_map WHERE co_code = '&COMPANY';

Another frequent operational query is to find the specific accounting unit mapped for a given transaction context, which is essential for troubleshooting posting issues:

  • SELECT a.acctg_unit_id, a.acctg_unit_code FROM gl_accu_mst a, gl_accu_map m WHERE m.acctg_unit_id = a.acctg_unit_id AND m.co_code = '&CO' AND NVL(m.orgn_code, '&ORG') = '&ORG' AND NVL(m.whse_code, '&WHSE') = '&WHSE';

Related Objects

GL_ACCU_MAP is centrally connected to several master and reference tables via foreign key constraints. The accounting unit definition is sourced from GL_ACCU_MST. The company code is validated against GL_PLCY_MST (General Ledger Policy Master). The organization code references both SY_ORGN_MST and SY_ORGN_MST_B, while the warehouse code references IC_WHSE_MST. As a mapping table, it is a key reference point for programs and interfaces within the GMF module that perform financial integration, particularly those responsible for transferring inventory and manufacturing accounting data to the General Ledger.

  • Table: GL_ACCU_MAP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MAP,  object_name:GL_ACCU_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the GL Account Unit Mapping information. The Account Unit mapping are defined for a Company, Organization and Warehouse. Organization and Warehouse are optional and a blank value means all value. The GL Mapping program ,  implementation_dba_data: GMF.GL_ACCU_MAP , 

  • Table: GL_ACCU_MAP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MAP,  object_name:GL_ACCU_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the GL Account Unit Mapping information. The Account Unit mapping are defined for a Company, Organization and Warehouse. Organization and Warehouse are optional and a blank value means all value. The GL Mapping program ,  implementation_dba_data: GMF.GL_ACCU_MAP , 

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

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