Results for “ozf_adj_temp_eligibility”

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

Overview

OZF_ADJ_TEMP_ELIGIBILITY is a Trade Management (OZF) schema table within Oracle E-Business Suite 12.1.1 and 12.2.2 that governs temporal eligibility rules applied to offer adjustment lines. It functions as a filter mechanism that determines whether a specific adjustment line qualifies for a given object type during promotional or trade-funding evaluation. The table resides in the OZF schema and carries a VALID status in the data dictionary.

Under the heuristic Data Vault classification mined from its foreign-key structure, this table is identified as a standalone entity. A standalone classification suggests the object is modeled as an independent table rather than as a conventional hub, link, or satellite. Practitioners designing integration or analytical data vaults should treat this as a modeling suggestion only, since the physical ETRM schema does not enforce a Data Vault pattern. The table participates in the broader OZF adjustment hierarchy through its relationship to offer adjustment lines and is secured through Oracle's multi-tenant security group mechanism via the FND_SECURITY_GROUPS reference.

Key Information Stored

The documented physical schema for release 12.2.2 comprises five columns. The most significant are described below.

• ELIGIBILITY_ID — The surrogate primary key for the table. It uniquely identifies each eligibility record and is the column referenced when joining downstream to dependent children or when performing targeted updates.
• OFFER_ADJUSTMENT_LINE_ID — The business-key candidate that ties the eligibility row to a specific offer adjustment line. This is the primary linkage used to associate eligibility constraints with the parent adjustment configuration.
• OBJECT_TYPE — Describes the type of object to which the eligibility rule applies, allowing the same adjustment line to carry differentiated eligibility logic across object categories.
• EXCLUDE_FLAG — A flag that inverts the eligibility semantics, indicating whether the referenced object is explicitly excluded rather than included. This supports both inclusion and exclusion rule patterns.
• SECURITY_GROUP_ID — The multi-tenant security discriminator. It references FND_SECURITY_GROUPS and ensures eligibility records are partitioned by operating unit or security context.

No documented unique index beyond the primary key constrains the business columns, so OFFER_ADJUSTMENT_LINE_ID combined with OBJECT_TYPE and EXCLUDE_FLAG is a practical business-key candidate when performing de-duplication or reconciliation.

Common Use Cases and Queries

Functional analysts typically interrogate this table to diagnose why a particular offer adjustment did not apply to a set of customers, products, or periods. A common pattern joins eligibility rows to the adjustment line and then to the parent offer.

• Adjustment troubleshooting — select eligibility rows for a given offer adjustment line to confirm which objects are included or excluded:

  SELECT e.eligibility_id, e.object_type, e.exclude_flag, e.offer_adjustment_line_id FROM ozf.ozf_adj_temp_eligibility e WHERE e.offer_adjustment_line_id = :line_id;

• Security-scoped reporting — restrict results to a specific operating unit using SECURITY_GROUP_ID to honor multi-org access boundaries.
• Exclusion auditing — filter on EXCLUDE_FLAG to enumerate explicitly excluded object types, useful in compliance and promotion-leakage reviews.
• Data migration validation — compare eligibility counts per adjustment line between source and target instances after an upgrade from 12.1.1 to 12.2.2.

Related Objects

The following objects are the most relevant dependencies and join targets for OZF_ADJ_TEMP_ELIGIBILITY.

• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; supplies the security group definition used to scope eligibility records.
• OZF_OFFER_ADJUSTMENT_LINES — the parent adjustment line table joined through OFFER_ADJUSTMENT_LINE_ID.
• OZF_OFFERS — the owning offer header, reached transitively through the adjustment line for end-to-end promotion reporting.
• OZF_ADJUSTMENTS — the adjustment definition table providing the rule context for each eligibility row.
• OZF_ADJ_TEMP_ELIGIBILITY_V — where present, a reporting view over the base table exposing security-filtered rows.