Search Results ozf_claim_sttlmnt_methods_pk

Overview

The OZF_CLAIM_STTLMNT_METHODS_ALL table is a Trade Management (OZF) object in Oracle E-Business Suite, present in both the 12.1.1 and 12.2.2 releases. It stores the set of available settlement methods that may be applied to a given claim source within the Trade Management claim lifecycle. In practical terms, it is the configuration and lookup source that determines which settlement method values are valid for a particular combination of claim class and source object class, and whether those methods are currently enabled. The table is organization-enabled through the ORG_ID column, meaning that settlement method availability can be defined per operating unit.

A heuristic Data Vault classification mined from the foreign key structure identifies this object as standalone, with no inbound or outbound hub or link dependencies beyond its security group reference. This suggests a modeling approach in which the table is treated as an independent reference or lookup entity rather than as a link between business entities. The primary key is defined by OZF_CLAIM_STTLMNT_METHODS_PK on (ORG_ID, CLAIM_STTLMNT_METHOD_ID), and the documented physical schema for ETRM 12.2.2 lists 16 columns. A unique index, OZF_CLAIM_STTLMNT_METHODS_U1 on (ORG_ID, CLAIM_STTLMNT_METHOD_ID, ZD_EDITION_NAME), supports the business-key candidate.

Key Information Stored

The most significant columns in this table are the following:

• CLAIM_STTLMNT_METHOD_ID — the surrogate identifier for the settlement method record, and part of the primary key.
• ORG_ID — the operating unit that owns the configuration, and the other half of the primary key.
• CLAIM_CLASS — the classification of the claim to which the settlement method applies.
• SOURCE_OBJECT_CLASS — the source object class for the claim, defining the origin of claim data.
• SETTLEMENT_METHOD — the actual settlement method value being configured.
• ENABLED_FLAG — indicates whether the settlement method is currently active for the given claim source.
• SEEDED_FLAG — identifies records delivered as seeded Oracle data versus those created by users.
• TAX_FOR — relates to tax handling for the settlement method.
• SECURITY_GROUP_ID — the security group to which the record belongs; a foreign key to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates.
• ZD_EDITION_NAME — the editioning column used by the 12.2 online patching (Edition-Based Redefinition) model, part of the unique business-key index.
• Standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on validating and presenting the settlement methods available for a claim. A common query retrieves all enabled methods for a given claim class and source object class within an operating unit:

• SELECT CLAIM_STTLMNT_METHOD_ID, SETTLEMENT_METHOD FROM OZF_CLAIM_STTLMNT_METHODS_ALL WHERE ORG_ID = :org_id AND CLAIM_CLASS = :claim_class AND ENABLED_FLAG = 'Y'

Reporting scenarios include auditing which methods are seeded versus user-defined (SEEDED_FLAG), checking per-operating-unit configuration differences, and troubleshooting why a settlement method is unavailable. Because the table is multi-org, join predicates on ORG_ID must be applied consistently with the MO/security profile in use.

Related Objects

• FND_SECURITY_GROUPS — referenced through the SECURITY_GROUP_ID foreign key, controlling record-level security.
• OZF_CLAIMS_ALL — the parent claim entity whose settlement processing consumes these methods.
• OZF_CLAIM_TYPES_ALL — provides the claim class/source context used alongside CLAIM_CLASS and SOURCE_OBJECT_CLASS.
• OZF_CLAIM_LINES_ALL — claim line records where settlement methods are applied.
• OZF_SETTLEMENTS_ALL — the resulting settlement records generated using these methods.
• FND_LOOKUP_VALUES — often supplies the display meaning for SETTLEMENT_METHOD and related flag values.

The primary key OZF_CLAIM_STTLMNT_METHODS_PK and unique index OZF_CLAIM_STTLMNT_METHODS_U1 govern access and integrity for this Trade Management configuration table.