Search Results gl_aloc_inp




Overview
Explore in AI Chat

Overview

The GL_ALOC_INP table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Financials (GMF) module. It serves as the transactional repository for allocation processing data. Specifically, it stores the computed expense and basis amounts that are generated during the execution of allocation formulas, which are used to distribute costs across various departments, products, or other cost centers. The data in this table can originate from Oracle Financials modules and is subsequently available for user review and maintenance via dedicated application screens, providing a critical link between general ledger data and granular cost allocation in a manufacturing environment.

Key Information Stored

The table's structure is designed to uniquely identify and store allocation line items. Its primary key (GL_ALOC_INP_PK) is the surrogate key column GL_ALOC_INP_ID. A unique constraint (GL_ALOC_INP_U1) defines the natural business key for an allocation entry, consisting of the calendar code (CALENDAR_CODE), period code (PERIOD_CODE), allocation identifier (ALLOC_ID), and line number (LINE_NO). Crucially, it also includes columns to define the accounting flexfield: ACCOUNT_KEY_TYPE and ACCOUNT_KEY. The core data columns hold the computed expense amount and the basis amount used in the allocation calculation. The foreign key relationship to CM_CLDR_DTL (via CALENDAR_CODE and PERIOD_CODE) ensures referential integrity with the financial calendar.

Common Use Cases and Queries

The primary use case is the analysis and adjustment of allocation results. Financial analysts may query this table to verify the amounts distributed by an allocation run before posting to the general ledger. A common reporting pattern involves joining to calendar and allocation definition tables. For example, to review all allocation lines for a specific period and allocation ID:

  • SELECT calendar_code, period_code, alloc_id, line_no, account_key, expense_amount, basis_amount FROM gmf.gl_aloc_inp WHERE calendar_code = '&CAL' AND period_code = '&PER' AND alloc_id = &ALLOC_ID ORDER BY line_no;

Another critical use case is data maintenance, where users may run queries to identify lines with zero basis or exceptional expense amounts for manual correction via the application's maintenance screen, ensuring allocation accuracy.

Related Objects

GL_ALOC_INP is centrally connected to several key EBS objects. Its defining foreign key relationship is with the CM_CLDR_DTL table (Common Calendar Detail), which validates the accounting period. It is intrinsically linked to the underlying allocation engine and definition tables within the GMF module, which populate it. The table is the likely source for allocation summary reports and interfaces. While not listed in the provided metadata, it is common for such a transactional table to have associated audit or history tables (e.g., GL_ALOC_INP_AUD) and to be referenced by standard Oracle APIs or public views that facilitate data extraction for custom reporting and integrations.

  • Table: GL_ALOC_INP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_INP,  object_name:GL_ALOC_INP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over from Oracle Financials and the user has the option to maintain them via a maintenance screen. ,  implementation_dba_data: GMF.GL_ALOC_INP , 

  • Table: GL_ALOC_INP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_INP,  object_name:GL_ALOC_INP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over from Oracle Financials and the user has the option to maintain them via a maintenance screen. ,  implementation_dba_data: GMF.GL_ALOC_INP , 

  • Table: GL_ALOC_INP_EFC 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_INP_EFC,  object_name:GL_ALOC_INP_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_ALOC_INP for EFC migration. Stores the original values of columns of GL_ALOC_INP that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ALOC_INP an ,  implementation_dba_data: GMF.GL_ALOC_INP_EFC , 

  • Table: GL_ALOC_INP_EFC 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_INP_EFC,  object_name:GL_ALOC_INP_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_ALOC_INP for EFC migration. Stores the original values of columns of GL_ALOC_INP that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ALOC_INP an ,  implementation_dba_data: GMF.GL_ALOC_INP_EFC , 

  • View: GL_ALOC_INP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GL_ALOC_INP_V,  object_name:GL_ALOC_INP_V,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: View to enable master-detail relationship on Allocation Maintenance form ,  implementation_dba_data: APPS.GL_ALOC_INP_V , 

  • View: GL_ALOC_INP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GL_ALOC_INP_V,  object_name:GL_ALOC_INP_V,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: View to enable master-detail relationship on Allocation Maintenance form ,  implementation_dba_data: APPS.GL_ALOC_INP_V , 

  • Table: CM_CLDR_DTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CLDR_DTL,  object_name:CM_CLDR_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Costing Calendar Details ,  implementation_dba_data: GMF.CM_CLDR_DTL , 

  • Table: CM_CLDR_DTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CLDR_DTL,  object_name:CM_CLDR_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Costing Calendar Details ,  implementation_dba_data: GMF.CM_CLDR_DTL ,