Search Results cm_rsrc_dtl

Overview

CR_RSRC_MST_B is the resource master table within the Oracle EBS Process Manufacturing (GMP) module, specifically the Process Planning component. It resides in the GMP schema and stores the definitive record of every production resource—machines, labor crews, equipment, and other capacity-bearing entities—that can be scheduled and consumed during process manufacturing. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the central reference point for resource definitions used throughout capacity planning, cost rollup, and routing logic.

The record carries a status of VALID and is documented with 22 physical columns in the ETRM 12.2.2 release. Its primary key, CR_RSRC_MST_B_PK, is defined on the RESOURCES column, which acts as the business key for resource identification. From a Data Vault modeling perspective, the FK structure suggests this object behaves as a hub: it holds the durable identity of each resource and is referenced by numerous downstream transactional and detail tables, while itself referencing only a small set of classification and cost-component lookups. This hub-leaning classification is a heuristic observation rather than a formal designation.

Key Information Stored

The most consequential columns fall into distinct functional groups. Resource identity is anchored by RESOURCES, the primary key and business-key candidate that uniquely names each resource. Classification is handled by RESOURCE_CLASS, which links to CR_RSRC_CLS_B to categorize the resource type, and COST_CMPNTCLS_ID, which ties the resource to a cost component class in CM_CMPT_MST_B for costing purposes. Descriptive attributes include RESOURCE_DESC#1 and TEXT_CODE, the latter joining to CR_TEXT_HDR for extended descriptive text.

Capacity and usage behavior are governed by MIN_CAPACITY, MAX_CAPACITY, CAPACITY_CONSTRAINT, CAPACITY_UOM, and CAPACITY_TOLERANCE, which together define the operating envelope of the resource. Planning factors such as UTILIZATION and EFFICIENCY influence scheduling calculations. Standard consumption is expressed through STD_USAGE_UM and STD_USAGE_UOM. Capacity measurement uses CAPACITY_UM. Audit and concurrency columns include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, TRANS_CNT, and DELETE_MARK, the last being the soft-delete indicator. The distinction between the surrogate RESOURCES key and any alternate unique identifier is not documented beyond the single PK, so RESOURCES remains the sole confirmed business-key candidate.

Common Use Cases and Queries

Typical reporting scenarios include resource capacity analysis, cost component assignment review, and usage standardization audits. A common query retrieves active resources with their class and capacity limits:

• SELECT r.RESOURCES, r.RESOURCE_DESC#1, r.RESOURCE_CLASS, r.MIN_CAPACITY, r.MAX_CAPACITY, r.UTILIZATION, r.EFFICIENCY FROM GMP.CR_RSRC_MST_B r WHERE r.DELETE_MARK = 0;
• Joining to CR_RSRC_CLS_B to resolve resource class descriptions for planning reports.
• Joining to CM_CMPT_MST_B via COST_CMPNTCLS_ID to validate cost component assignments before cost rollup.
• Querying GMP_RESOURCE_PARAMETERS by RESOURCES to inspect resource-specific planning parameters.

Because many downstream detail tables carry a RESOURCES foreign key, the table is frequently used as the driving hub in star-schema style reports that fan out to consumption, cost, and routing detail.

Related Objects

The table’s dependencies form a dense reference network. It references three tables: CM_CMPT_MST_B through COST_CMPNTCLS_ID, CR_RSRC_CLS_B through RESOURCE_CLASS, and CR_TEXT_HDR through TEXT_CODE. Conversely, it is referenced by CM_BRDN_DTL, CM_RSRC_DTL, and CM_SCST_LED via their RESOURCES columns, and by CR_ARES_MST and FM_ARES_MST through both PRIMARY_RESOURCE and ALTERNATE_RESOURCE, enabling alternate-resource substitution. CR_RSRC_DTL references it through both RESOURCES and GROUP_RESOURCE, supporting grouped resource definitions. GL_ACCT_MAP ties accounting mappings to resources through its RESOURCES column, while GMP_RESOURCE_PARAMETERS links planning parameters via RESOURCES. Together these relationships establish CR_RSRC_MST_B as the authoritative resource hub within GMP Process Planning.