Search Results gl_aloc_bas




Overview
Explore in AI Chat

Overview

The GL_ALOC_BAS table is a core data object within the GMF (Process Manufacturing Financials) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the detailed definition table for allocation bases. Specifically, it stores the criteria that determine how expenses are to be allocated to specific items, warehouses, or cost components. Each record defines a single line of an allocation basis, linking an allocation master code to the target items, the basis account or percentage used for calculation, and the relevant cost component class. This table is essential for executing and auditing complex cost allocation processes in a process manufacturing environment.

Key Information Stored

The table's structure is defined by its primary key, which consists of ALLOC_ID and LINE_NO, ensuring unique definitions for each line within an allocation code. Important columns include ALLOC_ID, which links to the parent allocation master (GL_ALOC_MST), and LINE_NO, which sequences the basis lines. Critical data columns define the allocation target and method: ITEM_ID and WHSE_CODE specify the inventory items and warehouses receiving the allocation. The basis for allocation is defined by either an ANALYSIS_CODE (linking to a basis account in CM_ALYS_MST) or a fixed percentage. The CMPNTCLS_ID links the allocation to a specific cost component class bucket, directing costs to the appropriate accounting element.

Common Use Cases and Queries

The primary use case is the setup and review of allocation rules for overhead or indirect costs. A financial analyst would query this table to validate the configuration of an allocation code before a period-end close. Common SQL patterns involve joining to related master tables to translate IDs into meaningful names. For example, to list all basis lines for a specific allocation code:

  • SELECT gab.line_no, iim.item_no, gab.fixed_pct, cam.analysis_code FROM gl_aloc_bas gab JOIN ic_item_mst iim ON gab.item_id = iim.item_id LEFT JOIN cm_alys_mst cam ON gab.analysis_code = cam.analysis_code WHERE gab.alloc_id = '&ALLOC_CODE';

Reporting use cases include generating allocation audit trails and analyzing the distribution logic of manufacturing expenses across products or cost components.

Related Objects

GL_ALOC_BAS has integral relationships with several key master tables, as defined by its foreign key constraints. The primary parent table is GL_ALOC_MST via ALLOC_ID. It references master data for items (IC_ITEM_MST, IC_ITEM_MST_B), warehouses (IC_WHSE_MST), cost components (CM_CMPT_MST, CM_CMPT_MST_B), basis analysis codes (CM_ALYS_MST), and descriptive text (CM_TEXT_HDR). These relationships ensure data integrity, enforcing that allocation bases are built upon valid, existing entities within the manufacturing and financials setup. Understanding these links is crucial for any data migration, extension, or troubleshooting effort involving GMF allocations.