Results for “tx_text_hdr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

TX_TEXT_HDR is the text header table for the Tax application within Oracle Process Manufacturing (OPM), owned by the GML schema. It is a reference or lookup master that centralizes text code definitions used across the OPM tax configuration model in Oracle EBS 12.1.1 and 12.2.2. Rather than storing descriptive text inline on each tax rule, calculation, or location record, the OPM tax module normalizes this content into a single header table keyed by TEXT_CODE, and the various tax setup tables reference that code through foreign keys. This design allows the same text block to be shared by multiple tax entities and maintained in one place.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is hub-leaning. The table behaves as a hub: it holds a single business key (TEXT_CODE) that many surrounding tables reference, while the descriptive and audit columns attached to it function as satellite-style attributes. In a Data Vault or dimensional model, TX_TEXT_HDR would therefore most naturally be modeled as the hub for text codes, with descriptive attributes separated into a satellite and the referencing tax tables treated as links or dependent hubs.

Key Information Stored

The documented physical schema for 12.2.2 contains six columns. The most significant are:

• TEXT_CODE — the surrogate primary key, defined by the unique index TX_TEXT_HDR_PK. This is also the sole business-key candidate documented for the table, and it is the column propagated as a foreign key into every dependent tax table.
• CREATED_BY — the user or concurrent program that originally inserted the text code record.
• CREATION_DATE — the timestamp of the initial insert.
• LAST_UPDATE_DATE — the timestamp of the most recent modification, used widely in EBS for incremental extraction and auditing.
• LAST_UPDATED_BY — the user who performed the most recent change.
• LAST_UPDATE_LOGIN — the login identifier associated with the last update session.

Because the metadata documents only these columns, TX_TEXT_HDR is a lean reference table: the business meaning is carried entirely by TEXT_CODE, and the remaining attributes are standard EBS audit columns (WHO columns). Any descriptive text content is resolved through the application logic of the OPM Tax module rather than through additional documented columns in this table.

Common Use Cases and Queries

Typical usage centers on validating and resolving TEXT_CODE references from tax setup tables, and on auditing who created or last changed a given text code. A representative lookup joins the header to a dependent table:

• Resolve text codes used by tax calculations: SELECT h.text_code, h.last_update_date FROM gml.tx_text_hdr h, gml.tx_calc_mst c WHERE h.text_code = c.text_code;
• Audit recently changed text headers: filter on LAST_UPDATE_DATE between a reporting window and order by the timestamp.
• Referential integrity checks: find orphan TEXT_CODE values in TX_TAXA_MST, TX_TAXA_DTL, TX_TXRP_CLS, or TX_TLOC_CDS that have no matching row in TX_TEXT_HDR.
• Migration or configuration reporting: enumerate all valid text codes before loading tax rules into a new environment.

Because the table is a reference master, reporting queries should be run with the standard EBS multi-org and security predicates applied, and extracts should be driven by LAST_UPDATE_DATE for efficiency.

Related Objects

Nine documented foreign keys reference TX_TEXT_HDR.TEXT_CODE, making it a central dependency of the OPM tax configuration model. The most significant related tables are:

• TX_CALC_MST.TEXT_CODE — tax calculation master, referencing text codes attached to calculation definitions.
• TX_TAXA_MST.TEXT_CODE — tax authority master, the primary tax authority setup table.
• TX_TAXA_DTL.TEXT_CODE — tax authority detail lines.
• TX_TAXA_STS.TEXT_CODE — tax authority status records.
• TX_TXRP_CLS.TEXT_CODE — tax reporting class definitions.
• TX_TXRE_CDS.TEXT_CODE — tax reporting code definitions.
• TX_TLOC_ASC.TEXT_CODE and TX_TLOC_CDS.TEXT_CODE — tax location association and code tables.
• TX_TOFR_ASC.TEXT_CODE — tax office association records.

All joins are performed on the single shared column TEXT_CODE, so any change to a text code value must be coordinated across these dependents to preserve referential integrity.