Search Results agent_address




Overview
Explore in AI Chat

Overview

OKL_INS_PY_UV is an APPS-owned dictionary view within the Oracle Lease and Finance Management (OKL) module. It exposes insurance policy data in a denormalized, presentation-ready form for reporting, integration, and inquiry purposes. The view combines transactional insurance policy attributes with lookup-based descriptive values, notably translating the internal IPY_TYPE code into a human-readable INSURANCE_TYPE via FND_LOOKUPS. This design makes the view suitable for operational reporting, dashboards, and downstream interfaces that require insurance type, premium, coverage, and policy status information without needing to join multiple underlying tables. In the context of the user's search for "insurance_type," this view is the canonical reporting source where the coded value and its meaning are surfaced together. The view is marked VALID and is documented for EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over several documented base objects:

  • OKL_INS_POLICIES_B — the primary base table supplying the bulk of transactional columns (premium, coverage, dates, flags, and financial attributes).
  • OKL_INS_POLICIES_TL — supplies translated/descriptive fields such as DESCRIPTION, ENDORSEMENT, COMMENTS, and CANCELLATION_COMMENT.
  • FND_LOOKUPS — supplies the decoded MEANING used as INSURANCE_TYPE, driven by IPY_TYPE.
  • HZ_PARTIES — referenced for party-related information associated with the policy.
  • FND_GLOBAL — a package typically invoked for session context such as organization or user identifiers.

The view therefore stitches the transactional insurance policy records to their lookup meanings and party context, providing a single access point.

Key Columns

Important columns include:

Common Use Cases and Queries

Typical scenarios include insurance type analysis, active policy listing, and premium reporting.

  • Insurance type summary: SELECT INSURANCE_TYPE, COUNT(*) FROM OKL_INS_PY_UV GROUP BY INSURANCE_TYPE;
  • Active policies by type: SELECT POLICY_NUMBER, INSURANCE_TYPE, PREMIUM FROM OKL_INS_PY_UV WHERE STATUS = 'ACTIVE' ORDER BY INSURANCE_TYPE;
  • Coverage and premium review: SELECT INSURANCE_TYPE, SUM(PREMIUM), SUM(COVERED_AMOUNT) FROM OKL_INS_PY_UV GROUP BY INSURANCE_TYPE;

Because the view pre-joins lookup and translated tables, it reduces the complexity of ad-hoc insurance reporting in both 12.1.1 and 12.2.2 environments.