Results for “hz_style_fmt_variations”

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

Overview

HZ_STYLE_FMT_VARIATIONS is a Receivables (AR) module table in the Oracle E-Business Suite that stores the individual layout variations defined for each style format used in customer-facing documents such as statements, dunning letters, invoices, and correspondence. The style format establishes the overall template, while each variation row within HZ_STYLE_FMT_VARIATIONS defines a selectable alternative layout for that format, ranked and conditionally applied based on business rules. This table is central to personalization and multi-variant rendering of AR communications in both EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the table is heuristically classified as satellite-leaning. It carries descriptive attributes — ranking, active-date bounds, selection conditions, and audit columns — that qualify a parent key rather than introducing a new independent business key. This positions it as a satellite on the combined format/variation hub key, with the variation rank and condition attributes describing the state of the parent entity.

Key Information Stored

The table contains 13 documented columns. The following are the most significant:

• STYLE_FORMAT_CODE — Identifier of the parent style format; part of the composite primary key and a foreign key to HZ_STYLE_FORMATS_B.
• VARIATION_NUMBER — Ordinal of the variation within the parent format; the second component of the composite primary key.
• VARIATION_RANK — Priority used when Oracle selects among competing variations for the same format.
• SELECTION_CONDITION — The rule or condition expression that determines when a given variation is applicable.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective-dating window bounding when the variation is valid.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit trailing used for concurrency and change tracking.
• OBJECT_VERSION_NUMBER — Optimistic locking token for the row.
• ZD_EDITION_NAME — Editioning attribute supporting Edition-Based Redefinition, present in the uniqueness constraint.

The surrogate primary key is HZ_STYLE_FMT_VARIATIONS_PK, defined over (STYLE_FORMAT_CODE, VARIATION_NUMBER). The unique index HZ_STYLE_FMT_VARIATIONS_U1 extends that key with ZD_EDITION_NAME, making it the business-key candidate across editions.

Common Use Cases and Queries

Typical scenarios include reporting on active variations for a format, auditing ranking conflicts, and diagnosing which variation a rendered document used.

• Active variations for a format: SELECT variation_number, variation_rank, selection_condition FROM hz_style_fmt_variations WHERE style_format_code = :code AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1) ORDER BY variation_rank;
• Highest-ranked variation: SELECT * FROM hz_style_fmt_variations WHERE style_format_code = :code AND ROWNUM = 1 ORDER BY variation_rank;
• Audit of recent changes: filter by LAST_UPDATE_DATE to identify variations touched after a given date, useful in post-upgrade validation for 12.1.1 to 12.2.2 migrations.
• Layout join: join to HZ_STYLE_FMT_LAYOUTS_B on STYLE_FORMAT_CODE and VARIATION_NUMBER to reconcile layout definitions per variation.

Related Objects

• HZ_STYLE_FORMATS_B — Parent master for the format; joined via STYLE_FORMAT_CODE.
• HZ_STYLE_FMT_LAYOUTS_B — Child layout table referencing this table via STYLE_FORMAT_CODE and VARIATION_NUMBER.
• HZ_STYLE_FMT_LAYOUTS_TL — Translated layout descriptions.
• HZ_STYLE_FORMATS_TL — Translated format names.
• HZ_STYLE_SHEETS — Sheet-level definitions consuming formats.
• AR_STATEMENTS / AR_DUNNING subsystems — Consumers of generated output driven by these variations.

Relationship traversal for reporting is best anchored on STYLE_FORMAT_CODE, which fans out from the format master to variations and onward to layouts.