Search Results cr_text_hdr




Overview
Explore in AI Chat

Overview

The CR_TEXT_HDR table is a core reference data object within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for the Process Planning sub-module. It functions as a master repository for defining and storing text types used in the Capacity (CR) management functionality. Its primary role is to provide a centralized, standardized list of descriptive codes that categorize and annotate various capacity-related entities. By maintaining these text codes in a single header table, the application ensures data consistency and referential integrity across the complex capacity planning and resource modeling structures. The table's design as a simple lookup is fundamental to the configuration and detailed documentation of resources, areas, and schedules within the manufacturing process.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is focused on maintaining a unique set of text type identifiers. The primary and most critical column is TEXT_CODE, which serves as the unique key for each text type definition. This column is the target of all foreign key relationships listed. While the explicit documentation does not list additional columns, typical header tables in Oracle EBS often include supporting fields such as ENABLED_FLAG, DESCRIPTION, CREATION_DATE, and LAST_UPDATE_DATE to manage the lifecycle and meaning of each code. The primary key constraint CR_TEXT_HDR_PK enforces the uniqueness of the TEXT_CODE, preventing duplicate entries and ensuring reliable data relationships.

Common Use Cases and Queries

The primary use case for CR_TEXT_HDR is as a validation source for assigning descriptive categories to capacity planning objects. For instance, a planner may define text codes like "PREVENTIVE_MAINT_NOTES," "SETUP_INSTRUCTIONS," or "SAFETY_REQUIREMENTS" in this table. These codes can then be assigned to resources, resource classes, or production areas to provide structured contextual information. A common reporting need is to list all available text types or to find where a specific text code is applied. Sample query patterns include fetching the master list of codes or joining to child tables to see usage.

  • SELECT TEXT_CODE FROM GMP.CR_TEXT_HDR WHERE ENABLED_FLAG = 'Y' ORDER BY 1;
  • SELECT h.TEXT_CODE, m.RESOURCE_CODE FROM GMP.CR_TEXT_HDR h, GMP.CR_RSRC_MST m WHERE h.TEXT_CODE = m.TEXT_CODE;

Related Objects

The CR_TEXT_HDR table is a central hub referenced by numerous key capacity planning tables, as detailed in the foreign key metadata. These relationships demonstrate its integral role in the data model. Major related objects include:

These dependencies indicate that any text code defined in CR_TEXT_HDR can be used to categorize or annotate resources, areas, schedules, and graphical planning elements, forming a unified descriptive layer across the capacity planning suite.