Search Results gl_text_hdr_pk




Overview
Explore in AI Chat

Overview

The GL_TEXT_HDR table is a core data object within the GMF (Process Manufacturing Financials) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a master reference table designed to store and manage text types used within the General Ledger (GL) context. Its primary role is to provide a centralized, validated repository for descriptive text codes, which are subsequently referenced by numerous other transactional and master tables in the GMF financial architecture. This ensures data integrity and consistency for textual descriptions across the Process Manufacturing financial ecosystem.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a primary key column that uniquely identifies each text type. The most critical column is TEXT_CODE, which serves as the table's primary key (GL_TEXT_HDR_PK). This column holds the unique identifier for a specific category or type of descriptive text. While the specific supplemental columns (such as DESCRIPTION, ENABLED_FLAG, or CREATION_DATE) are not detailed in the excerpt, tables of this nature in Oracle EBS typically include standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and a descriptive name or meaning field to elaborate on the TEXT_CODE's purpose.

Common Use Cases and Queries

This table is fundamental for setup and validation. A common use case is during the configuration of GMF accounting rules, where a TEXT_CODE from GL_TEXT_HDR is assigned to various accounting entities to provide standardized descriptions. For reporting and troubleshooting, queries often join GL_TEXT_HDR to its related transactional tables to retrieve human-readable text descriptions for coded values. A fundamental query pattern is retrieving all active text types:

  • SELECT text_code, meaning FROM gmf.gl_text_hdr WHERE enabled_flag = 'Y' ORDER BY text_code;

Another critical pattern involves validating or resolving text codes used in specific accounting entries, typically through a join with a child table like GL_ACCT_MST:

  • SELECT mst.*, hdr.meaning FROM gmf.gl_acct_mst mst, gmf.gl_text_hdr hdr WHERE mst.text_code = hdr.text_code;

Related Objects

The ETRM documentation explicitly lists several key tables that maintain foreign key relationships with GL_TEXT_HDR, using its TEXT_CODE as a reference. This demonstrates its central role as a master table. The primary related objects are:

  • GL_ACCT_KEY: References GL_TEXT_HDR via TEXT_CODE.
  • GL_ACCT_MST: References GL_TEXT_HDR via TEXT_CODE.
  • GL_ACCT_TYP: References GL_TEXT_HDR via TEXT_CODE.
  • GL_ACCT_VAL: References GL_TEXT_HDR via TEXT_CODE.
  • GL_PLCY_MST: References GL_TEXT_HDR via TEXT_CODE.

These relationships indicate that text types defined in GL_TEXT_HDR are integral to defining accounting keys, master accounts, account types, validation rules, and financial policies within GMF.