Search Results cm_text_hdr




Overview
Explore in AI Chat

Overview

The CM_TEXT_HDR table is a core data dictionary table within the GMF (Process Manufacturing Financials) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for header information related to user-defined text entries created via the "Edit Text" functionality. This table acts as a centralized control point, enabling the association of descriptive text notes with various transactional and master data records across the Cost Management suite. Its primary role is to provide a standardized, reusable mechanism for adding contextual comments and explanations to financial and manufacturing cost data, thereby enhancing auditability and process clarity.

Key Information Stored

The table's structure is designed to manage unique text entries. The primary and most critical column is TEXT_CODE, which serves as the unique identifier (primary key CM_TEXT_HDR_PK) for each distinct text header record. While the provided ETRM metadata does not list additional columns explicitly, a table of this nature in the GMF schema typically contains supporting columns such as a description field (e.g., TEXT_DESC), creation date, created by, last update date, and last updated by. The TEXT_CODE is the foreign key referenced by numerous child tables throughout the Cost Management application to link specific transactions or master data to its corresponding descriptive text header.

Common Use Cases and Queries

The primary use case is querying and reporting on the descriptive text associated with various cost transactions. For instance, an analyst may need to extract the text comments linked to a specific cost adjustment, calendar definition, or resource transaction. A common SQL pattern involves joining CM_TEXT_HDR to one of its many referencing tables. For example, to retrieve text for cost adjustments:

  • SELECT adj.*, txt.* FROM cm_adjs_dtl adj, cm_text_hdr txt WHERE adj.text_code = txt.text_code AND adj.adjustment_id = :p_adj_id;

Another critical use case is data validation and cleanup, ensuring that TEXT_CODE values referenced in child tables have a valid parent record in CM_TEXT_HDR, thus maintaining referential integrity. Administrators may also query the table to identify rarely used or duplicate text entries.

Related Objects

As indicated by the extensive foreign key list in the metadata, CM_TEXT_HDR is a pivotal parent table referenced by a wide array of Cost Management tables. Key dependent objects include transaction detail tables like CM_ADJS_DTL (Adjustments), CM_CLDR_DTL (Calendar Details), and CM_RSRC_DTL (Resource Details). It is also referenced by master data tables such as CM_ALYS_MST (Analysis Masters), CM_CMPT_MST (Component Masters), and CM_MTHD_MST (Method Masters). This broad integration underscores its fundamental role in attaching descriptive text across the GMF module's core entities for adjustments, calendars, components, resources, warehouses, and allocation bases.