Search Results cr_rsrc_cls




Overview
Explore in AI Chat

Overview

The CR_RSRC_CLS table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It serves as the master repository for defining resource classes, which are logical groupings of individual resources (e.g., equipment, labor, or facilities) based on shared characteristics or capabilities. This classification is fundamental to process planning and scheduling, enabling planners to define recipes and routings based on a class of resources rather than a specific instance, thereby introducing flexibility and efficiency into production operations. The table's role is to establish and maintain the valid list of these resource class codes for use throughout the manufacturing planning lifecycle.

Key Information Stored

Based on the provided ETRM metadata, the primary column for this table is RESOURCE_CLASS. This column stores the unique identifier or code for a resource class. The table's primary key constraint, CR_RSRC_CLS_PK, is defined on this column, enforcing its uniqueness. A foreign key relationship indicates the presence of a TEXT_CODE column, which links to the CR_TEXT_HDR table. This linkage is a standard EBS pattern for storing descriptive, translatable text (like the resource class name and description) separately from the code in a multi-language enabled structure. The data for descriptive fields would therefore be retrieved by joining to the CR_TEXT_HDR and related text detail tables.

Common Use Cases and Queries

A primary use case is the setup and maintenance of resource classes during process manufacturing implementation. Planners utilize these classes when defining operations in a recipe or routing. Common queries involve listing all active resource classes with their descriptions for LOVs in forms or reports. For example:

  • Basic listing: SELECT rsc.RESOURCE_CLASStl.MEANING FROM CR_RSRC_CLS rsc, FND_LOOKUP_VALUES tl WHERE tl.LOOKUP_TYPE = 'RESOURCE_CLASS' AND tl.LOOKUP_CODE = rsc.RESOURCE_CLASS AND tl.LANGUAGE = USERENV('LANG');
  • Finding resources by class: A critical query joins CR_RSRC_CLS to CR_RSRC_MST to list all individual resources belonging to a specific class, which is essential for capacity planning and scheduling.

Reporting often focuses on resource utilization and availability aggregated by class, or on identifying which recipes and routings are dependent on a particular resource class.

Related Objects

The ETRM documentation explicitly defines two key foreign key relationships for the CR_RSRC_CLS table.

  • CR_RSRC_MST: This is the master resources table. The foreign key (CR_RSRC_MST.RESOURCE_CLASS) references CR_RSRC_CLS, meaning every defined resource in the system must be associated with a valid resource class stored in this table.
  • CR_TEXT_HDR: This table stores the translatable header text. The foreign key (CR_RSRC_CLS.TEXT_CODE) links to CR_TEXT_HDR, allowing the resource class's name and description to be maintained in multiple languages.

It is important to note the metadata states "Not implemented in this database," which may indicate the specific instance of the ETRM was generated from a database where the GMP module was not installed. However, the defined structure and relationships outline its intended design and integration within the Process Manufacturing suite.