Search Results hz_word_rpl_conds_b




Overview
Explore in AI Chat

Overview

The table HZ_WORD_RPL_CONDS_B is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the Receivables (AR) module. It functions as the master repository for defining conditions used in word replacement lists. These lists are integral to data standardization and cleansing processes, particularly within the Trading Community Architecture (TCA) framework. The table's role is to store the logical rules or criteria that determine when specific word replacements should be applied to data, such as customer names or addresses, ensuring consistency and accuracy across the application.

Key Information Stored

The primary entity stored is a condition record, uniquely identified by the CONDITION_ID column, which serves as the table's primary key. While the specific column list is not detailed in the provided metadata, tables of this nature in the HZ (TCA) schema typically store attributes defining the condition's logic. This likely includes columns for a condition name, descriptive text, the sequence of evaluation, and the actual conditional expression (e.g., matching a word at the beginning, end, or anywhere within a string). The CONDITION_ID is the critical foreign key column referenced by related objects to associate a replacement rule with its governing condition.

Common Use Cases and Queries

The primary use case is the administration and execution of automated word replacement for data quality. For instance, a condition might be defined to replace "St." with "Street" only when it appears at the end of a string. Administrators would query this table to review, audit, or maintain the list of active conditions. A common reporting query would join this table to its related word replacements table to see the full rule set.

  • Sample Query to List All Conditions: SELECT condition_id, [other_columns] FROM ar.hz_word_rpl_conds_b ORDER BY condition_id;
  • Sample Query to View Conditions with Their Associated Replacements: SELECT cond.condition_id, repl.replacement_text FROM ar.hz_word_rpl_conds_b cond, ar.hz_word_replacements repl WHERE cond.condition_id = repl.condition_id;

Related Objects

The table maintains a direct and documented foreign key relationship, which is central to its function. The primary key CONDITION_ID is referenced by the HZ_WORD_REPLACEMENTS table. This relationship means that each record in HZ_WORD_REPLACEMENTS (which defines the actual "find and replace" text pair) must be associated with a valid condition ID stored in HZ_WORD_RPL_CONDS_B. The join is performed on the column HZ_WORD_REPLACEMENTS.CONDITION_ID. This structure enforces referential integrity, ensuring that no replacement rule exists without a defined condition to control its application.