Results for “okl_ins_exclusions_uv”

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

Overview

OKL_INS_EXCLUSIONS_UV is a consolidated, user-facing view in the APPS schema belonging to the Oracle Lease and Finance Management (OKL) product family. It presents insurance exclusion rules — records that define where insurance coverage is not extended for a given country and asset category combination. The view overlays descriptive, language-translated values onto the underlying transactional data so that end users and report developers can work with readable country names and collateral descriptions instead of internal foreign-key identifiers. Its primary role is reporting and integration: it is the natural source for viewing, extracting, or validating insurance exclusion setups during lease origination, contract booking, and downstream risk analysis. The view carries the standard Oracle EBS who-columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and an OBJECT_VERSION_NUMBER for optimistic locking, which confirms it is exposed to the OAF/BC4J framework as well as to ad-hoc SQL.

Underlying Base Objects

The view is defined over four referenced objects: two synonyms for the insured-exclusions base and translation tables, and two reference views.

• OKL_INS_EXCLUSIONS_B — the base table holding exclusion rows. Joined on ID and provides COUNTRY_ID, COLL_CODE, SIC_CODE, DATE_FROM, DATE_TO, the ATTRIBUTE1–15 flex columns, SFWT_FLAG, and audit columns.
• OKL_INS_EXCLUSIONS_TL — the translation table, joined on ID and filtered by IENT.LANGUAGE = USERENV('LANG'), supplying COMMENTS in the session language.
• OKX_COUNTRIES_V — the countries reference view, joined as IENB.COUNTRY_ID = OCOV.ID1, supplying the COUNTRY display name.
• OKX_ASST_CATGRS_V — the asset-category reference view, joined as IENB.COLL_CODE = OACV.ID1, supplying COLL_NAME.

Because the joins to OKX_COUNTRIES_V and OKX_ASST_CATGRS_V are inner joins, only exclusion rows whose COUNTRY_ID and COLL_CODE resolve to valid reference entries are returned.

Key Columns

• ID / ROW_ID — surrogate primary key from the _B table and the physical row identifier.
• COUNTRY_ID — the value the user searched for; the foreign key to the country master record and the join key into OKX_COUNTRIES_V.
• COUNTRY — the descriptive country name resolved through OKX_COUNTRIES_V.
• COLL_CODE / COLL_NAME — internal collateral/asset-category code and its descriptive name from OKX_ASST_CATGRS_V.
• SIC_CODE — Standard Industrial Classification code associated with the exclusion.
• DATE_FROM / DATE_TO — the effective period of the exclusion rule.
• STATUS — a derived column computed with nested DECODE logic over DATE_TO and MONTHS_BETWEEN. When DATE_TO is null or still in the future, STATUS returns 'ACTIVE'; otherwise it returns 'INACCTIVE' (note the spelling in the view definition).
• COMMENTS — translated remarks from the _TL table.
• ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield segments.

Common Use Cases and Queries

Typical scenarios include auditing active exclusions by country, feeding risk engines that suppress insurance premiums, and building country-level setup reports. A representative query listing active exclusions for a specific country is:

SELECT country_id, country, coll_name, sic_code, date_from, date_to, status FROM apps.okl_ins_exclusions_uv WHERE status = 'ACTIVE' AND country_id = :p_country_id ORDER BY country, coll_name;

To enumerate all countries that currently have exclusion rules, use: SELECT DISTINCT country_id, country FROM apps.okl_ins_exclusions_uv WHERE date_to IS NULL OR date_to >= SYSDATE ORDER BY country;

Because COUNTRY_ID is validated by an inner join to OKX_COUNTRIES_V, callers can also join this view directly to reference or reporting objects on COUNTRY_ID. When referencing the view from custom code, always qualify it as APPS.OKL_INS_EXCLUSIONS_UV and grant the appropriate privileges, since the object is owned by APPS.