Search Results okl_ins_rates_pk

Overview

The OKL_INS_RATES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the central repository for storing insurance premium rates, which are critical for calculating insurance costs associated with leased assets or financed agreements. This table enables the system to apply specific, pre-defined rates based on various criteria such as product type, geographic territory, and date ranges, thereby automating and standardizing the insurance premium calculation process within lease and finance contracts. Its role is integral to the financial and risk management functionalities of the OKL product family.

Key Information Stored

Based on the provided ETRM metadata, the table stores insurance rate definitions linked to other master data entities. The primary key column is ID, which uniquely identifies each rate record. Two critical foreign key relationships are documented, indicating the table's structure and the nature of data it holds:

• IPT_ID: A foreign key column referencing the OKL_INS_PRODUCTS_B table. This links each rate to a specific insurance product (e.g., property insurance, liability insurance).
• IC_ID: A foreign key column referencing the FND_TERRITORIES table. This links the rate to a specific geographic territory or country, allowing for region-specific premium calculations.

While the full column list is not provided, the table logically contains additional attributes such as the effective rate value, effective start and end dates, and potentially attributes for rate type, calculation basis, and associated modifiers.

Common Use Cases and Queries

The primary use case is the dynamic determination of insurance premiums during the creation or amendment of a lease contract. When an asset is added to a contract, the system queries this table to find the applicable rate based on the asset's insurance product and the contract's territory. A typical query pattern would involve joining to the related master tables:

SELECT oir.rate_value, oir.effective_from_date
FROM okl_ins_rates oir,
     okl_ins_products_b oip,
     fnd_territories ft
WHERE oir.ipt_id = oip.id
  AND oir.ic_id = ft.territory_code
  AND oip.name = 'PROPERTY_DAMAGE'
  AND ft.territory_short_name = 'US'
  AND SYSDATE BETWEEN oir.effective_from_date
                  AND NVL(oir.effective_to_date, SYSDATE);

Reporting use cases include analyzing rate trends over time, auditing rate effectiveness by product or territory, and ensuring compliance with insurance regulations across different regions.

Related Objects

The ETRM documentation explicitly lists the following key dependencies:

• Primary Key Constraint: OKL_INS_RATES_PK on the ID column.
• Foreign Key to OKL_INS_PRODUCTS_B: This relationship ties a rate to a defined insurance product, which is itself part of the OKL insurance product catalog.
• Foreign Key to FND_TERRITORIES: This relationship, part of the Oracle Applications Foundation (FND) layer, provides the standard territory definitions used across EBS, ensuring consistency in geographic data.

In a full implementation, this table is also likely referenced by transactional tables in the OKL module that store calculated insurance premium amounts on contracts, and by associated public APIs or PL/SQL packages responsible for the insurance pricing engine.