Search Results cr_rsrc_dtl

Overview

The CR_RSRC_DTL table is a core data object within Oracle E-Business Suite Process Manufacturing (GMP) Process Planning module. It functions as the central repository for plant-specific resource information. While master resource definitions are stored elsewhere, this table holds the detailed operational parameters and configurations that are specific to an individual manufacturing plant or organization (ORGN_CODE). This enables the same logical resource, such as a reactor or a work crew, to have different capacities, costs, or availability rules when deployed across different facilities within the enterprise. Its primary role is to support detailed production scheduling, capacity planning, and cost calculations at the plant execution level.

Key Information Stored

The table's structure, as indicated by its primary and foreign keys, centers on linking a resource to a specific organization and defining its operational characteristics. The key columns include RESOURCE_ID (the primary key), ORGN_CODE (identifying the plant), and RESOURCES (linking to the master resource definition in CR_RSRC_MST). Other significant foreign key relationships point to columns like GROUP_RESOURCE (for resource groups), TEXT_CODE (for descriptive notes), and USAGE_UM (the unit of measure for resource usage). This design allows the table to store attributes such as the resource's cost rate, available capacity, efficiency factor, and scheduling constraints that are unique to each plant's operational context.

Common Use Cases and Queries

A primary use case is retrieving all resources available for planning within a specific manufacturing plant. This is fundamental for capacity analysis and scheduling workflows. A typical query would join CR_RSRC_DTL to the resource master (CR_RSRC_MST) and organization tables (SY_ORGN_MST) to get a comprehensive plant resource list.

• Sample Query: Plant Resource Listing
  SELECT rdt.ORGN_CODE, org.ORGN_NAME, rdt.RESOURCES, rms.RESOURCE_DESC, rdt.USAGE_UM
FROM GMP.CR_RSRC_DTL rdt,
GMP.CR_RSRC_MST rms,
GMP.SY_ORGN_MST org
WHERE rdt.ORGN_CODE = :p_orgn_code
AND rdt.RESOURCES = rms.RESOURCES
AND rdt.ORGN_CODE = org.ORGN_CODE
ORDER BY rdt.RESOURCES;
• Another critical scenario involves troubleshooting resource unavailability or exception assignments by joining CR_RSRC_DTL to its child tables, such as GMP_RSRC_UNAVAIL_MAN or GMP_RSRC_EXCP_ASNMT, to analyze constraints impacting a specific resource at a plant.

Related Objects

CR_RSRC_DTL sits at the center of a network of related planning tables. It is a direct child of the resource master tables (CR_RSRC_MST and CR_RSRC_MST_B) via the RESOURCES and GROUP_RESOURCE columns. It also references SY_ORGN_MST for the plant, SY_UOMS_MST for units of measure, and CR_TEXT_HDR for descriptive text. Crucially, it is a parent table to several key transactional and setup tables, including GMP_PLANT_RSRC_PARAMETERS (for detailed plant-level settings), GMP_RSRC_EXCP_ASNMT (for exception assignments), and GMP_RSRC_UNAVAIL_MAN (for managing resource downtime). This hierarchy underscores its role as the definitive source for a resource's executable configuration within a plant.