Search Results gmf_burden_priorities




Overview
Explore in AI Chat

Overview

The GMF_BURDEN_PRIORITIES 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 serves a critical function in the Oracle Process Manufacturing (OPM) Costing system by establishing the hierarchical order, or priority, in which percentage-based manufacturing overheads, known as burdens, are applied to product costs. This prioritization is essential for ensuring accurate and consistent cost roll-ups and calculations, directly impacting inventory valuation, profitability analysis, and management reporting for process manufacturing entities.

Key Information Stored

The table stores the relationship between a legal entity, a burden code, and its assigned priority sequence. Its structure is defined by a composite primary key. The key columns, as documented, are CO_CODE and BURDEN_ID. The CO_CODE column identifies the company or legal organization code, linking to the SY_ORGN_MST table. The BURDEN_ID column stores the unique identifier for a specific burden or overhead code, linking to the GMF_BURDEN_CODES table. While the explicit metadata does not list a dedicated PRIORITY column, the table's described purpose implies the existence of a column (or a mechanism) to store the sequential order for burden application, which is logically enforced by the primary key relationship between the organization and the burden identifier.

Common Use Cases and Queries

The primary use case is during the OPM cost calculation engine runtime, where the system queries this table to determine the sequence for applying percentage burdens to raw material, resource, and overhead costs. It is also crucial for cost simulations and "what-if" analyses. A common reporting query would involve joining to related tables to list all burdens for an organization in their order of application. A sample SQL pattern to retrieve this information would be:

  • SELECT bp.co_code, bc.burden_code, bc.description, [priority_column]
  • FROM gmf_burden_priorities bp, gmf_burden_codes bc
  • WHERE bp.burden_id = bc.burden_id
  • AND bp.co_code = :p_org_code
  • ORDER BY [priority_column];

Administrative use cases include setting up or modifying the burden priority structure for a new product line or legal entity through the relevant GMF responsibility screens, which ultimately maintains this table.

Related Objects

As per the provided foreign key metadata, GMF_BURDEN_PRIORITIES has defined relationships with three other key EBS tables:

  • SY_ORGN_MST & SY_ORGN_MST_B: The table is linked via the CO_CODE column to these organization master tables, which define the legal entity context.
  • GMF_BURDEN_CODES: This is a direct and essential relationship. The BURDEN_ID column in GMF_BURDEN_PRIORITIES references the BURDEN_ID in GMF_BURDEN_CODES, which stores the definitional details (code, description, type, rate) of each burden.

These relationships ensure referential integrity, meaning a priority record cannot exist for an undefined organization or an undefined burden code. The table is also a likely parent to or referenced by various costing engine packages and views within the GMF and OPM Costing modules.