Search Results cr_rsrc_cls_b




Overview
Explore in AI Chat

Overview

The CR_RSRC_CLS_B table is a core master data table within the Oracle E-Business Suite (EBS) Process Manufacturing (GMO) and Process Planning (GMP) modules. It serves as the foundational repository for defining and storing resource classes. In the context of Process Manufacturing, a resource class is a logical grouping of similar resources—such as equipment, labor, or utilities—used in production processes. This classification is essential for capacity planning, scheduling, and costing, as it allows the system to treat interchangeable resources as a single pool. The table's role is to establish a standardized catalog of these classifications, which are then referenced by individual resource definitions and process operation steps throughout the manufacturing lifecycle.

Key Information Stored

While the provided metadata does not list specific columns, the structure and relationships indicate the core data elements. The primary key, RESOURCE_CLASS, is the unique identifier for each classification code. A critical foreign key relationship exists via the TEXT_CODE column, which links to the CR_TEXT_HDR table. This relationship manages multilingual descriptive text (like name and description) for the resource class, enabling global deployments. Other typical columns in such a master table would include control attributes such as ENABLED_FLAG (to activate or deactivate the class), START_DATE, END_DATE for validity, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

A primary use case is the setup and maintenance of the resource master (CR_RSRC_MST_B), where each resource must be assigned a valid RESOURCE_CLASS. This enables reporting and planning at an aggregated class level. Common queries include listing all active resource classes with their descriptions, or identifying all resources belonging to a specific class for capacity analysis. For example:

  • To retrieve a list of all resource classes with their translated description: SELECT rcb.RESOURCE_CLASS, cth.MEANING FROM GMP.CR_RSRC_CLS_B rcb, GMP.CR_TEXT_HDR cth WHERE rcb.TEXT_CODE = cth.TEXT_CODE AND rcb.ENABLED_FLAG = 'Y';
  • To find all resources assigned to a class like 'REACTOR': SELECT * FROM GMP.CR_RSRC_MST_B WHERE RESOURCE_CLASS = 'REACTOR';

This table is also central to configuration and setup reports used by manufacturing engineers and planners.

Related Objects

The CR_RSRC_CLS_B table has defined relationships with several key objects, as per the metadata. The CR_RSRC_MST_B (Resource Master) table holds a foreign key (RESOURCE_CLASS) referencing this table, making it a critical parent entity. The CR_TEXT_HDR table is linked via the TEXT_CODE foreign key to provide descriptive flexfield text. While not listed in the excerpt, it is common for this table to be referenced by planning and capacity views within the GMP and GMO schemas. The primary key constraint CR_RSRC_CLS_B_PK enforces the uniqueness of the RESOURCE_CLASS identifier, ensuring data integrity across the manufacturing foundation.