Search Results okl_ins_products_b




Overview
Explore in AI Chat

Overview

The OKL_INS_PRODUCTS_B table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the master repository for defining insurance products that can be associated with lease contracts. This table stores the fundamental definition of optional insurance offerings, enabling the system to manage the sale, administration, and tracking of insurance as an integrated component of a leasing agreement. Its role is critical in supporting the bundled financial products common in asset leasing, where insurance is a key value-added service. The table's status as a base table, indicated by the "_B" suffix, signifies it holds transactional data fundamental to the insurance product functionality within OKL.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as the ID column, which uniquely identifies each insurance product record. Based on its function as a product definition table, it typically stores descriptive and control attributes for an insurance product. Common columns expected in such a structure include a product name or code, a description, effective dates (START_DATE, END_DATE), status indicators (e.g., ACTIVE_FLAG), and fields linking to setup data such as insurance types or coverage categories. The table acts as the source system of record for all lease-related insurance products available within the EBS instance.

Common Use Cases and Queries

This table is central to operations involving insurance product setup, maintenance, and inquiry. Administrators use it to create and maintain the catalog of insurance offerings. Common functional use cases include associating a specific insurance product with a lease line during contract booking and generating reports on available products. From a reporting and integration perspective, frequent queries involve joining this table to related transactional tables. A typical SQL pattern retrieves active products for a given date or links product definitions to their associated policies.

  • Listing all active insurance products: SELECT id, name FROM okl_ins_products_b WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate) AND active_flag = 'Y';
  • Joining to policy data to report on product utilization: SELECT ipb.name, count(pol.id) FROM okl_ins_products_b ipb, okl_ins_policies_b pol WHERE ipb.id = pol.ipt_id GROUP BY ipb.name;

Related Objects

The OKL_INS_PRODUCTS_B table is a key parent table in the OKL data model, as evidenced by its foreign key relationships. The primary key (ID) is referenced by several important transactional tables, establishing the core hierarchy for insurance data.

  • OKL_INS_POLICIES_B / OKL_INS_POLICIES_ALL_B: These tables store the actual insurance policy instances created for lease contracts. The foreign key column IPT_ID links each policy directly back to its master product definition in OKL_INS_PRODUCTS_B.
  • OKL_INS_RATES: This table likely holds the pricing or rate schedules applicable to insurance products. The IPT_ID foreign key ensures rates are correctly associated with their parent product.

This relationship structure means that any customization, data fix, or reporting requirement concerning insurance products must consider its impact on these dependent policy and rate tables.