Search Results ozf_claim_types_all_b




Overview
Explore in AI Chat

Overview

The OZF_CLAIM_TYPES_ALL_B table is a core base table within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for defining and storing claim types, which are fundamental classifications for trade promotions and claims processing. As a multi-organization enabled table (indicated by the "_ALL" suffix), it supports the storage of data across multiple operating units, a critical feature for enterprise deployments. The table's primary role is to provide a validated set of claim types that govern the creation, processing, and approval workflows for claims throughout the system. Its integrity is enforced as the parent table in several key foreign key relationships, making it a central reference point for trade management configuration and transactional data.

Key Information Stored

While the provided metadata does not list specific columns, the table's structure is defined by its primary and foreign key relationships. The primary key column, CLAIM_TYPE_ID, is the unique identifier for each claim type record. As a base table, OZF_CLAIM_TYPES_ALL_B typically stores the core, non-translatable attributes of a claim type. These attributes likely include system-critical information such as an active/inactive flag, creation and last update dates, and the identifier for the operating unit (ORG_ID). The corresponding translation table, OZF_CLAIM_TYPES_ALL_TL, would store language-specific descriptions for the claim types defined in this base table, linked via the CLAIM_TYPE_ID column.

Common Use Cases and Queries

This table is primarily used for setup, reporting, and data validation. Administrators use it to define the list of permissible claim types available during claim entry. Common operational and reporting queries involve joining this table to transactional data to analyze claims by type. A typical SQL pattern retrieves a list of active claim types for a given operating unit, often joined with its translation table for user-friendly descriptions:

  • SELECT b.CLAIM_TYPE_ID, tl.NAME FROM OZF_CLAIM_TYPES_ALL_B b, OZF_CLAIM_TYPES_ALL_TL tl WHERE b.CLAIM_TYPE_ID = tl.CLAIM_TYPE_ID AND b.ORG_ID = :org_id AND SYSDATE BETWEEN NVL(tl.START_DATE_ACTIVE, SYSDATE) AND NVL(tl.END_DATE_ACTIVE, SYSDATE);

Another critical use case is validating claim data integrity, ensuring that every claim in the OZF_CLAIMS_ALL table references a valid CLAIM_TYPE_ID present in this master table.

Related Objects

The OZF_CLAIM_TYPES_ALL_B table is a central reference point within the Trade Management schema, as evidenced by its documented foreign key relationships. The following objects have a direct dependency on it:

  • OZF_CLAIMS_ALL: The primary transactional table for claims references this table via CLAIM_TYPE_ID to classify each claim.
  • OZF_CLAIM_DEF_RULES_ALL: Claim deduction rules are associated with a specific claim type via CLAIM_TYPE_ID.
  • OZF_CLAIM_TYPES_ALL_TL: The translation table for claim type descriptions, linked by CLAIM_TYPE_ID.
  • OZF_SYS_PARAMETERS_ALL: System parameters reference this table twice: once for a default CLAIM_TYPE_ID and once for an AUTOPAY_CLAIM_TYPE_ID, indicating its role in defining system-wide defaults and automated payment processing behavior.