Search Results cm_rsrc_dtl_pk

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:

• ORGN_CODE — the organization owning the resource cost record; foreign key to SY_ORGN_MST.
• RESOURCES — the resource identifier; foreign key to CR_RSRC_MST.
• CALENDAR_CODE — the costing calendar; foreign key to CM_CLDR_DTL.
• PERIOD_CODE — the accounting period; joins CM_CLDR_DTL via calendar and period.
• COST_MTHD_CODE — the cost method applied; foreign key to CM_MTHD_MST.
• NOMINAL_COST — the resource cost value defined for the period.
• USAGE_UM / USAGE_UOM — the unit of measure for resource usage; USAGE_UM references SY_UOMS_MST.
• ROLLOVER_IND — indicates whether the cost rolls into subsequent periods.
• TEXT_CODE — reference to descriptive text via CM_TEXT_HDR.
• COST_TYPE_ID — cost type reference to CST_COST_TYPES.
• LEGAL_ENTITY_ID — legal entity reference to FV_LEGAL_ENTITIES.
• ORGANIZATION_ID, PERIOD_ID — surrogate identifiers supporting multi-org and period joins.
• DELETE_MARK — soft-delete flag used by Process Manufacturing.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, TRANS_CNT — audit and concurrency columns.

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.