Search Results cm_rsrc_dtl




Overview
Explore in AI Chat

Overview

The CM_RSRC_DTL table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the primary repository for storing detailed resource cost information. Its fundamental role is to capture and maintain the calculated or assigned costs for manufacturing resources—such as labor, equipment, or overhead—within a specific organizational, calendar, and costing context. This data is essential for accurate product costing, variance analysis, and financial reporting in a process manufacturing environment, forming a critical link between production operations and financial management.

Key Information Stored

The table's structure is designed to uniquely identify a cost record through its primary key, which consists of five columns: ORGN_CODE (organization), RESOURCES, CALENDAR_CODE, PERIOD_CODE, and COST_MTHD_CODE (costing method). This composite key ensures that resource costs are tracked distinctly for each combination of these dimensions. Important columns include TEXT_CODE for descriptive notes, USAGE_UM to store the unit of measure for the resource usage, and various cost columns (though specific cost column names like COST or UNIT_COST are implied by the description but not explicitly listed in the provided metadata). The table enforces data integrity through foreign key relationships to master data tables for organizations, resources, calendars, and costing methods.

Common Use Cases and Queries

This table is central to cost roll-up and analysis processes. A common use case is retrieving the effective cost of a resource for a given period and costing method to calculate the cost of goods manufactured. Financial analysts may query this table to investigate cost variances by comparing standard resource costs against actuals or analyzing period-over-period cost fluctuations. A typical reporting query would join CM_RSRC_DTL to master tables like CR_RSRC_MST for resource descriptions and CM_CLDR_DTL for period details.

  • Sample Query Pattern: SELECT rdtl.*, rsrc.resource_desc, clrd.period_start_date FROM gmf.cm_rsrc_dtl rdtl JOIN cr_rsrc_mst rsrc ON rdtl.resources = rsrc.resource_id JOIN gmF.cm_cldr_dtl clrd ON rdtl.calendar_code = clrd.calendar_code AND rdtl.period_code = clrd.period_code WHERE rdtl.orgn_code = :p_org AND rdtl.cost_mthd_code = :p_costing_method AND clrd.period_code = :p_period;

Related Objects

As indicated by its foreign keys, CM_RSRC_DTL has strong dependencies on several master and transactional tables within the GMF and related schemas. Key related objects include:

  • CM_CLDR_DTL: Provides the calendar period context for the cost record.
  • CM_MTHD_MST: Defines the valid costing method.
  • CR_RSRC_MST / CR_RSRC_MST_B: The master definition of the manufacturing resource.
  • SY_ORGN_MST / SY_ORGN_MST_B: Defines the organization structure.
  • SY_UOMS_MST: Contains the unit of measure definition for the usage UOM.
  • CM_TEXT_HDR: Stores optional descriptive text attached to the cost record.

This table is likely referenced by various cost calculation engines, inventory valuation reports, and the Cost Management suite within GMF.