Search Results fm_oprn_dtl

Overview

The CR_RSRC_MST table serves as the central master repository for resource definitions within Oracle E-Business Suite's Process Manufacturing Process Planning (GMP) module. It functions as a foundational data object, defining the people, equipment, tools, and facilities required to execute manufacturing operations. Its primary role is to establish a standardized catalog of resources that can be consistently referenced and utilized across process plans, routings, and cost calculations. The table's extensive foreign key relationships, as documented, underscore its critical integration with core manufacturing, cost management, and financial modules, enabling resource scheduling, capacity planning, and detailed cost analysis.

Key Information Stored

While the provided metadata does not list specific columns, the foreign key relationships and standard master table design imply it stores essential attributes for each resource. Key fields typically include a unique RESOURCES identifier, a RESOURCE_CLASS linking to the CR_RSRC_CLS table for categorization, and a TEXT_CODE for descriptive notes via CR_TEXT_HDR. For costing, it references a COST_CMPNTCLS_ID to the CM_CMPT_MST table, defining the cost component class. Operational details like a STD_USAGE_UM (Standard Usage Unit of Measure), linked to SY_UOMS_MST, are also stored to quantify resource consumption. Additional columns would manage status, ownership, and other control attributes common to master tables.

Common Use Cases and Queries

This table is central to several operational and analytical processes. Common use cases include generating resource availability reports for production scheduling, listing all active resources by class for maintenance planning, and extracting costed resource lists for process plan development. A typical query might join CR_RSRC_MST with its classification and unit of measure tables to produce a clean resource listing:

• SELECT r.resources, r.resource_description, c.resource_class, u.unit_of_measure FROM cr_rsrc_mst r, cr_rsrc_cls c, sy_uoms_mst u WHERE r.resource_class = c.resource_class AND r.std_usage_um = u.unit_of_measure AND r.enabled_flag = 'Y';

Another critical pattern involves tracing resource usage by joining to detail tables like CR_RSRC_DTL or FM_OPRN_DTL to analyze which process plans or formulations consume a specific resource.

Related Objects

As the foreign key metadata details, CR_RSRC_MST is a hub table with dependencies across multiple modules. Key related objects include classification and descriptive tables (CR_RSRC_CLS, CR_TEXT_HDR), cost management tables (CM_CMPT_MST, CM_BRDN_DTL, CM_SCST_LED), and core manufacturing execution tables. It is directly referenced by detail tables in Process Planning (CR_RSRC_DTL, CR_ARES_MST), Process Execution (FM_OPRN_DTL, FM_ARES_MST), and Product Development (PM_OPRN_DTL). The link to GL_ACCT_MST facilitates the mapping of resource usage to general ledger accounts for financial integration. This wide network confirms its role as a single source of truth for resource data within the manufacturing suite.