Results for “late_policy_type_code”

44 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OKL_BPD_LATE_POLICIES_UV view is a descriptive, user-facing view within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It exposes late payment policy definitions — the rules that govern late charges, late interest accrual, and related fee assessments applied to delinquent lease and finance contracts. As a "_UV" (User View) object owned by the APPS schema, it is intended for reporting, integration, and inquiry purposes rather than for direct transactional DML. The view is documented as VALID under ETRM 12.2.2 and is also present in 12.1.1. It presents a denormalized, human-readable projection of late policy setup, resolving internal identifiers to language-translated names and joining to auxiliary lookup views for location and index context. Because the term "tdf_id" appears in the underlying view text and column list, the view is frequently located by users searching for that column, which links a late policy to a terms/data framework (TDF) identifier.

Underlying Base Objects

The view text joins four documented base objects:

The join on OKL_INDICES is an outer join (INDS.ID(+)), so late policies without an associated index are still returned.

Key Columns

  • ROW_ID — the ROWID of the base row, useful for identifying the underlying record.
  • ID — primary identifier of the late policy.
  • ORG_ID — operating unit / organization context for multi-org security.
  • NAME / DESCRIPTION — translated policy name and description from the TL table.
  • ISE_ID / LOCATION — the internal state/entity identifier and its resolved location name.
  • TDF_ID — the terms/data framework identifier associated with the policy; the object of the search term.
  • IDX_ID / IDX_NAME — the index reference and its name.
  • LATE_POLICY_TYPE_CODE — the policy type (e.g., amount- or rate-based).
  • LATE_CHRG_AMOUNT, LATE_CHRG_RATE, LATE_INT_RATE — the configured late charge amount, charge rate, and interest rate.
  • OBJECT_VERSION_NUMBER — optimistic locking version.

Common Use Cases and Queries

Typical uses include reporting active late policy configuration, validating rates before billing cycles, and joining policy data to contracts or delinquency processes. The language filter means it respects the session language, making it suitable for localized reporting.

Sample query filtering by TDF_ID:

  • SELECT id, name, tdf_id, late_policy_type_code, late_chrg_amount, late_chrg_rate, late_int_rate FROM okl_bpd_late_policies_uv WHERE tdf_id = :p_tdf_id;
  • SELECT id, name, location, idx_name, late_chrg_rate FROM okl_bpd_late_policies_uv WHERE org_id = :p_org_id ORDER BY name;

These queries illustrate how the view consolidates base, translation, state, and index data into a single reporting source for OKL late policy administration.