Results for “tdf_id”
50+ 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:
- OKL_LATE_POLICIES_B — the base table holding late policy definitions (ID, ORG_ID, ISE_ID, TDF_ID, IDX_ID, LATE_POLICY_TYPE_CODE, LATE_CHRG_AMOUNT, LATE_CHRG_RATE, LATE_INT_RATE, OBJECT_VERSION_NUMBER).
- OKL_LATE_POLICIES_TL — the translation table supplying NAME and DESCRIPTION, joined on ID and filtered by LPOT.LANGUAGE = USERENV('LANG').
- OKX_STATES_V — a view resolving the ISE_ID to a LOCATION name via STAT.ID1.
- OKL_INDICES — the index master, outer-joined on IDX_ID to yield IDX_NAME.
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.
-
APPS.OKL_BPD_LATE_POLICIES_UV·↳ OKL_INDICES·↳ OKL_LATE_POLICIES_B·↳ OKL_LATE_POLICIES_TL·Explore OKL module →
-
View: OKL_LATE_INTERESTS_V 12.1.1
Interest which may be charged on over due receivables
APPS.OKL_LATE_INTERESTS_V·↳ OKL_LATE_INTERESTS·Explore OKL module →
-
When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed
-
When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed
-
View: OKL_LATE_INTERESTS_V 12.2.2
Interest which may be charged on over due receivables
APPS.OKL_LATE_INTERESTS_V·↳ OKL_LATE_INTERESTS·Explore OKL module →
-
Interest which may be charged on over due receivables
-
View: OKL_LTE_CHRG_SETUPS_V 12.1.1
When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed
APPS.OKL_LTE_CHRG_SETUPS_V·↳ OKL_LTE_CHRG_SETUPS·Explore OKL module →
-
APPS.OKL_BPD_LATE_POLICIES_UV·↳ OKL_INDICES·↳ OKL_LATE_POLICIES_B·↳ OKL_LATE_POLICIES_TL·Explore OKL module →
-
Policy for charging on overdue receivables
-
Policy for charging on overdue receivables
-
Interest which may be charged on over due receivables
-
View: OKL_LTE_CHRG_SETUPS_V 12.2.2
When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed
APPS.OKL_LTE_CHRG_SETUPS_V·↳ OKL_LTE_CHRG_SETUPS·Explore OKL module →
-
View: OKL_LATE_POLICIES_V 12.2.2
Policy for charging on overdue receivables
APPS.OKL_LATE_POLICIES_V·↳ OKL_LATE_POLICIES_B·↳ OKL_LATE_POLICIES_TL·Explore OKL module →
-
View: OKL_LATE_POLICIES_V 12.1.1
Policy for charging on overdue receivables
APPS.OKL_LATE_POLICIES_V·↳ OKL_LATE_POLICIES_B·↳ OKL_LATE_POLICIES_TL·Explore OKL module →
-
PACKAGE: APPS.OKL_LPO_PVT 12.1.1
-
PACKAGE: APPS.OKL_LPO_PVT 12.2.2