Results for “ozf_claim_def_rules_all_u1”

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

Overview

The OZF_CLAIM_DEF_RULES_ALL table is a foundational configuration object within the Oracle E-Business Suite Trade Management (OZF) module. It stores the defaulting rules that automatically determine the claim type, claim reason, and associated custom setup for a given claim source. In practice, this table governs how claims entered through Trade Management channels inherit consistent classification values without requiring manual selection by the end user, thereby enforcing business policy at the point of claim creation.

The object resides in the OZF schema and is registered as VALID in the ETRM 12.1.1 and 12.2.2 data dictionaries. Its documented description confirms its purpose: it stores the default claim type, reason, and custom setup for a claim source. A heuristic Data Vault classification mined from the foreign-key structure suggests this object behaves as a satellite-leaning entity. Rather than acting as a pure transactional hub, it captures descriptive and derived attributes attached to claim definition keys, which is characteristic of satellite modeling.

Key Information Stored

The table is physically implemented with 18 documented columns. Its surrogate primary key is defined by the constraint OZF_CLAIM_DEF_RULES_ALL_PK, which is composed of ORG_ID and DEFAULTING_RULE_ID. A second unique index, OZF_CLAIM_DEF_RULES_ALL_U1 (ORG_ID, DEFAULTING_RULE_ID, ZD_EDITION_NAME), represents the strongest business-key candidate because it incorporates the multi-tenant organization context and the edition discriminator.

• DEFAULTING_RULE_ID — Identifier for the defaulting rule; part of both the primary key and the unique business key.
• ORG_ID — Operating unit or organization identifier; enforces multi-org data segregation and forms the leading column of the primary key.
• CLAIM_TYPE_ID — Foreign key to OZF_CLAIM_TYPES_ALL_B, identifying the claim type applied by the defaulting rule.
• REASON_CODE_ID — Reference to the claim reason code defaulted alongside the claim type.
• CUSTOM_SETUP_ID — Foreign key to AMS_CUSTOM_SETUPS_B, linking the rule to a custom setup definition.
• CLAIM_CLASS — Classifies the claim category the rule applies to.
• SOURCE_OBJECT_CLASS — Identifies the source object class against which the defaulting rule is evaluated.
• START_DATE and END_DATE — Define the effective dating window during which the rule is active.
• ENABLED_FLAG — Controls whether the defaulting rule is presently active.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting function-based security.
• ZD_EDITION_NAME — Edition discriminator used in the unique business key.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking creation and modification.

Common Use Cases and Queries

Typical usage centers on resolving which default values a claim should inherit for a given source and organization, and on auditing the completeness of defaulting configuration. Common SQL patterns filter on ORG_ID and validate the ENABLED_FLAG and effective dates. A representative query joining to the claim type base table appears below:

• Determine the active claim type and reason for a specific organization: SELECT d.DEFAULTING_RULE_ID, d.CLAIM_TYPE_ID, d.REASON_CODE_ID FROM OZF.OZF_CLAIM_DEF_RULES_ALL d WHERE d.ORG_ID = :org_id AND d.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN d.START_DATE AND NVL(d.END_DATE, SYSDATE);
• Resolve descriptive claim type attributes: join CLAIM_TYPE_ID to OZF_CLAIM_TYPES_ALL_B.
• Trade promotion and claim reporting: aggregate defaulted classifications by CLAIM_CLASS and SOURCE_OBJECT_CLASS.
• Configuration audit: identify rules missing a CUSTOM_SETUP_ID or with expired END_DATE values.
• Security validation: verify SECURITY_GROUP_ID associations against FND_SECURITY_GROUPS.

Related Objects

The following objects are most significant to OZF_CLAIM_DEF_RULES_ALL based on documented foreign-key and primary-key relationships:

• OZF_CLAIM_TYPES_ALL_B — referenced via CLAIM_TYPE_ID; supplies claim type definitions.
• AMS_CUSTOM_SETUPS_B — referenced via CUSTOM_SETUP_ID; provides custom setup definitions.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; enforces security grouping.
• OZF_CLAIM_DEF_RULES_ALL_PK — composite primary key (ORG_ID, DEFAULTING_RULE_ID).
• OZF_CLAIM_DEF_RULES_ALL_U1 — unique business-key index (ORG_ID, DEFAULTING_RULE_ID, ZD_EDITION_NAME).