Results for “cr_rsrc_mst”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CR_RSRC_MST is the resource master table within the Oracle EBS Process Manufacturing (GMP) Process Planning module. It stores the definition of every resource that can be consumed or produced during a manufacturing process, including machines, labor crews, equipment, and other capacity-bearing entities used in routings, operations, and cost rollups. In EBS 12.1.1 and 12.2.2, this table serves as the central reference point from which process execution, costing, and planning transactions draw resource attributes.

The ETRM metadata classifies CR_RSRC_MST heuristically as hub-leaning in a Data Vault model. This is a modeling suggestion: its surrogate primary key, CR_RSRC_MST_PK on the RESOURCES column, is referenced by numerous dependent tables, which is characteristic of a hub entity. The table itself also carries several foreign keys pointing outward to classification, costing, text, and unit-of-measure masters, so it functions as both a hub and, in part, a satellite holding descriptive attributes.

Key Information Stored

The primary key is CR_RSRC_MST_PK, defined on the RESOURCES column. This surrogate identifier is the join key used by all dependent tables. The documented foreign keys expose the principal business attributes:

• RESOURCES — primary key and business identifier for the resource record.
• RESOURCE_CLASS — foreign key to CR_RSRC_CLS, defining the resource classification or grouping.
• COST_CMPNTCLS_ID — foreign key to CM_CMPT_MST, linking the resource to a cost component class for costing.
• STD_USAGE_UM — foreign key to SY_UOMS_MST, the standard unit of measure for resource usage.
• TEXT_CODE — foreign key to CR_TEXT_HDR, associating descriptive text with the resource.

Additional descriptive columns (capacity, efficiency, incremental usage, and planning flags) are held in the table but are not enumerated in the supplied metadata. The RESOURCES column should be treated as the documented business-key candidate, while the composite unique index may incorporate the resource class or plant context depending on implementation.

Common Use Cases and Queries

Typical usage includes resource capacity reporting, routing and operation analysis, and cost component derivation. A common pattern joins CR_RSRC_MST to PM_OPRN_DTL, the table most directly relevant to the user's search term "pm_oprn_dtl," to retrieve the resources assigned to process operations:

• List operations and their resources: SELECT o.OPERATION_ID, r.RESOURCES FROM PM_OPRN_DTL o JOIN CR_RSRC_MST r ON o.RESOURCES = r.RESOURCES;
• Identify resource class membership: join to CR_RSRC_CLS on RESOURCE_CLASS.
• Resolve costing behavior: join to CM_CMPT_MST on COST_CMPNTCLS_ID.
• Compare primary and alternate resources for an operation via CR_ARES_MST.

Related Objects

The following are the most significant dependents and references, based on the documented foreign-key relationships:

• PM_OPRN_DTL — process operation detail; joins on PM_OPRN_DTL.RESOURCES = CR_RSRC_MST.RESOURCES.
• FM_OPRN_DTL — formula/operation detail; joins on FM_OPRN_DTL.RESOURCES.
• CR_RSRC_DTL — resource detail; joins on both RESOURCES and GROUP_RESOURCE.
• CR_ARES_MST and FM_ARES_MST — alternate resource masters; join on PRIMARY_RESOURCE and ALTERNATE_RESOURCE.
• CR_RSRC_CLS — resource class master (RESOURCE_CLASS).
• CM_CMPT_MST — cost component master (COST_CMPNTCLS_ID).
• CM_RSRC_DTL, CM_BRDN_DTL, CM_SCST_LED — resource detail, burden detail, and standard cost ledger.
• GL_ACCT_MAP — account mapping; joins on RESOURCES.

These relationships confirm CR_RSRC_MST as a foundational hub for process manufacturing resource definitions, with PM_OPRN_DTL and its formula-management counterpart FM_OPRN_DTL providing the operational linkage most relevant to resource-to-operation queries.