Results for “cz_intl_texts”

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

Overview

CZ_INTL_TEXTS is a table in the CZ (Configurator) product schema of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The table is formally marked OBSOLETE in the current documentation set, meaning it persists in the physical schema for backward compatibility and historical data retention but is no longer the intended target for new development or functional extension. Its historical role was to serve as a centralized repository of internationalized, reusable text strings — captions, tool tips, violation and unsatisfied messages, reasons, and other display strings — consumed by the Configurator modeling and runtime components, with localized variants maintained separately.

From a Data Vault modeling perspective, the mined foreign-key structure classifies CZ_INTL_TEXTS as hub-leaning. It carries a single-column surrogate primary key (INTL_TEXT_ID) that is referenced by many dependent tables, which is characteristic of a hub entity anchoring descriptive text attributes. The surrounding ETRM relationship data indicates that a refactor would likely position this object as a reference or lookup hub, with dependent tables acting as links or satellites.

Key Information Stored

The documented physical schema comprises 14 columns. The most significant are:

• INTL_TEXT_ID — The surrogate primary key, defined by the unique index CZ_INTL_TEXTS_PK. It is the single business-key candidate documented and the value propagated into all foreign-key references.
• TEXT_STR — The actual text payload stored for the identifier, used for captions, tool tips, and message bodies.
• DELETED_FLAG — Soft-delete indicator, allowing a text record to be logically retired without physical removal.
• EFF_FROM and EFF_TO — Effective dating boundaries governing the validity window of the text record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit attributes.
• SECURITY_MASK and EFF_MASK — Bitmask columns used by the Configurator framework to constrain visibility and effective-date filtering.
• CHECKOUT_USER — Identifies the user holding the record in a checked-out state during development.
• ORIG_SYS_REF — Reference to the originating source system, relevant for imported or synchronized text definitions.

Common Use Cases and Queries

Because the table is obsolete, primary use cases are investigative and archival: auditing which Configurator objects still hold foreign-key references, extracting text content for migration, and confirming data before decommissioning. A typical lookup joins the hub to a dependent table on INTL_TEXT_ID:

• SELECT t.INTL_TEXT_ID, t.TEXT_STR FROM CZ.CZ_INTL_TEXTS t WHERE t.INTL_TEXT_ID = :id;
• Retrieve active, non-deleted captions for user-interface nodes:
  SELECT u.CAPTION_ID, t.TEXT_STR FROM CZ.CZ_UI_NODES u JOIN CZ.CZ_INTL_TEXTS t ON u.CAPTION_ID = t.INTL_TEXT_ID WHERE t.DELETED_FLAG = 'N' AND SYSDATE BETWEEN t.EFF_FROM AND t.EFF_TO;
• Check referential exposure before purging: count referencing rows across CZ_RULES, CZ_PS_NODES, and CZ_UI_NODES for a given INTL_TEXT_ID.

Related Objects

The FK metadata identifies the following significant dependents, all joined on INTL_TEXT_ID unless noted:

• CZ_RULES — references via UNSATISFIED_MSG_ID and REASON_ID, supplying rule validation messages.
• CZ_PS_NODES — references via INTL_TEXT_ID and VIOLATION_TEXT_ID for product-structure node text and violations.
• CZ_UI_NODES — references via CAPTION_ID and TOOL_TIP_ID for runtime UI labels.
• CZ_DEVL_PROJECTS — references via INTL_TEXT_ID for development-project metadata.
• CZ_LCE_LINES — references via INTL_TEXT_ID for localized configuration lines.
• CZ_LOCALIZED_TEXTS — the localized companion storing per-language variants keyed to INTL_TEXT_ID.
• CZ_IMP_INTL_TEXT, CZ_IMP_LOCALIZED_TEXTS, CZ_IMP_DEVL_PROJECT, and CZ_IMP_PS_NODES — interface/import staging tables referencing the hub during data loads.