Search Results cm_rsrc_dtl




Overview
Explore in AI Chat

Overview

CM_RSRC_DTL is a Process Manufacturing Financials (GMF) table that stores resource cost definitions in Oracle EBS 12.1.1 and 12.2.2. It lives in the GMF schema and records the cost associated with using a resource (labor, machine, or overhead) within a specific organization, calendar, and accounting period, under a given cost method. In Process Manufacturing, resource costs feed into product costing, standard cost rollups, and production cost reporting. The table functions as a transactional cost detail, allowing a single resource to carry distinct cost values that vary by period, calendar, cost method, and legal entity. A heuristic Data Vault classification of the table indicates a link-type modeling suggestion, since it resolves relationships among organizations, resources, calendars, periods, and cost methods rather than acting as a pure descriptive hub or satellite.

Key Information Stored

The primary key CM_RSRC_DTL_PK is composite and comprises ORGN_CODE, RESOURCES, CALENDAR_CODE, PERIOD_CODE, and COST_MTHD_CODE. This composite key, not a single surrogate column, defines uniqueness and is the primary business-key candidate. Notable columns include:

Common Use Cases and Queries

Typical uses include reviewing resource cost by period, comparing costs across cost methods, and validating that a resource has a defined nominal cost before a cost rollup.

  • Period cost inquiry: select resources, nominal_cost, usage_uom where orgn_code and period_code match the reporting period.
  • Cost method comparison: join CM_MTHD_MST on cost_mthd_code and pivot nominal_cost by method.
  • Rollup validation: filter rollover_ind = 'Y' to identify costs eligible for carry-forward.
  • Missing-cost exception report: outer-join CR_RSRC_MST to CM_RSRC_DTL to find resources lacking cost detail.
  • Cost type and legal entity analysis: group nominal_cost by cost_type_id or legal_entity_id for managerial reporting.

All queries should honor delete_mark to exclude logically deleted rows.

Related Objects

The most significant related objects are the parent/dimension tables referenced by foreign keys:

  • CR_RSRC_MST / CR_RSRC_MST_B — master resource definitions, joined on RESOURCES.
  • SY_ORGN_MST / SY_ORGN_MST_B — organization master, joined on ORGN_CODE.
  • CM_CLDR_DTL — calendar detail, joined on CALENDAR_CODE and PERIOD_CODE.
  • CM_MTHD_MST — cost method master, joined on COST_MTHD_CODE.
  • CM_TEXT_HDR — text header, joined on TEXT_CODE.
  • SY_UOMS_MST — units of measure, joined on USAGE_UM.
  • CST_COST_TYPES — cost type definitions, joined on COST_TYPE_ID.
  • FV_LEGAL_ENTITIES — legal entity master, joined on LEGAL_ENTITY_ID.

These relationships confirm CM_RSRC_DTL's role as a central costing detail that harmonizes organization, resource, calendar, period, and cost method dimensions within Process Manufacturing Financials.