Search Results clm_pk

Overview

The table OKL_INS_CLAIMS_B is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the primary transactional repository for recording and managing insurance claims associated with lease agreements and optional insurance products. This table is fundamental to the insurance claim lifecycle, enabling the tracking of claim submissions, assessments, and settlements directly within the leasing and finance operational workflow. Its role is to maintain the master record for all claim-related data, ensuring a centralized and auditable system of record that integrates with other leasing, asset, and policy entities.

Key Information Stored

The table structure is designed to capture essential claim attributes. The primary identifier for each record is the ID column, which serves as the system-generated primary key (CLM_PK). A critical business identifier is the CLAIM_NUMBER column, which holds a unique, user-facing claim reference, enforced by the CLM_CLM_UK_1 unique key. A significant foreign key column is IPY_ID, which links the claim to its originating insurance policy in the OKL_INS_POLICIES_B table. This relationship is crucial for validating claim eligibility and accessing policy terms. While the provided metadata is limited on other columns, typical data would include claim dates, status, description, claimed amount, settlement details, and associated financial transactions.

Common Use Cases and Queries

Primary use cases revolve around claim administration and integrated reporting. Users process new claims, query claim status, and generate reports for loss analysis and recovery tracking. A common query involves joining with the policy table to retrieve claim details alongside policy information for validation or processing.

SELECT clm.claim_number, clm.creation_date, pol.policy_number
FROM okl_ins_claims_b clm,
     okl_ins_policies_b pol
WHERE clm.ipy_id = pol.id
AND clm.claim_status = 'SUBMITTED';

Another critical scenario is associating asset condition assessments with specific claims, leveraging the relationship with the OKL_ASSET_CNDTNS table to document damage or loss supporting the claim.

Related Objects

OKL_INS_CLAIMS_B is centrally connected to other key entities in the OKL module through documented foreign key relationships.

• OKL_INS_POLICIES_B: This is the parent table for insurance policies. The foreign key column OKL_INS_CLAIMS_B.IPY_ID references OKL_INS_POLICIES_B, establishing the policy under which a claim is made.
• OKL_ASSET_CNDTNS: This table stores condition records for leased assets. It holds a foreign key column OKL_ASSET_CNDTNS.CLM_ID that references the ID (primary key) of OKL_INS_CLAIMS_B. This allows multiple asset condition assessments (e.g., pre- and post-damage inspections) to be linked to a single insurance claim.

These relationships are essential for maintaining data integrity and enabling comprehensive views of policy coverage, claim events, and associated asset conditions.