Results for “reamortize_under_payment”

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

Overview

LNS_LOAN_PRODUCTS_VL is an APPS-owned view in the Oracle EBS Loans (LNS) module, a component of the Financial Services Accounting and Corporate Lending solution. It exposes the definition of loan products, which are the templates that govern how individual loan agreements and contracts are created, priced, and amortized. The _VL suffix identifies it as a "view language" object, a construct Oracle EBS uses to join a base transactional table with its translation table so that language-dependent descriptive columns (name and description) are returned in the session's current language.

The view is the reporting and integration-friendly access point for loan product setup data. Rather than reading the underlying tables directly, concurrent programs, Oracle Reports, OBIEE extracts, and inbound/outbound interfaces query LNS_LOAN_PRODUCTS_VL to retrieve product attributes in a denormalized, translated form. Its status is VALID in the APPS schema in both 12.1.1 and 12.2.2, where its structure is documented identically.

Underlying Base Objects

The view selects from two documented base objects, referenced through APPS synonyms:

• LNS_LOAN_PRODUCTS (SYNONYM) — the aliased table B, which holds the language-independent or numeric product setup columns: loan class, loan type, dates active, status, term rules, currency, rate configuration, frequencies, and all descriptive flexfield (DFF) segments ATTRIBUTE1 through ATTRIBUTE20.
• LNS_LOAN_PRODUCTS_ALL_TL (SYNONYM) — the aliased table T, the translation table supplying LOAN_PRODUCT_NAME and LOAN_PRODUCT_DESC for the current language.

The join keys between the two aliases are LOAN_PRODUCT_ID and the language context, so each product appears once per query with names resolved to the session language. Because the base table is later suffixed _ALL semantics, records are also segmented by ORG_ID, supporting multi-org (operating unit) security.

Key Columns

The view projects a broad set of product definition columns. Notable groups include:

• Identity and classification: LOAN_PRODUCT_ID, LOAN_CLASS_CODE, LOAN_TYPE_ID, LOAN_SUBTYPE, LOAN_PRODUCT_NAME, LOAN_PRODUCT_DESC, STATUS, START_DATE_ACTIVE, END_DATE_ACTIVE.
• Rate configuration — including CEILING_RATE: INDEX_RATE_ID, RATE_TYPE, SPREAD, FLOOR_RATE, CEILING_RATE, OPEN_FLOOR_RATE, and OPEN_CEILING_RATE. The CEILING_RATE column carries the maximum interest rate cap defined for the product, while OPEN_CEILING_RATE applies to open-ended or adjustable products.
• Term and amount rules: LOAN_TERM, LOAN_TERM_PERIOD, MAX_LOAN_TERM, OPEN_LOAN_TERM and their period variants, REQUESTED_AMOUNT, MAX_REQUESTED_AMOUNT, LOAN_CURRENCY.
• Frequency and amortization: INTEREST_COMPOUNDING_FREQ, LOAN_PAYMENT_FREQUENCY, AMORTIZATION_FREQUENCY, PRINCIPAL_PAYMENT_FREQUENCY, PAYMENT_CALC_METHOD.
• Approval and policy controls: LOAN_APPR_REQ_FLAG, BDGT_REQ_FOR_APPR_FLAG, APPR_REQ_FOR_CNCL_FLAG, FORGIVENESS_FLAG, FORGIVENESS_PERCENT, PENAL_INT_RATE, PENAL_INT_GRACE_DAYS.
• Audit and extensibility: ORG_ID, LEGAL_ENTITY_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER, ATTRIBUTE_CATEGORY and ATTRIBUTE1–20, CUSTOM_SCHED_DATA, CUSTOM_CALC_METHOD.

Common Use Cases and Queries

The view is commonly used when setting up lending products, validating a product's rate floor/ceiling before booking, and extracting product terms for downstream analytics. The most frequent retrieval pattern filters on CEILING_RATE to audit capped products across operating units.

• Locate products by rate ceiling: SELECT loan_product_name, ceiling_rate, open_ceiling_rate, floor_rate FROM lns_loan_products_vl WHERE ceiling_rate IS NOT NULL ORDER BY ceiling_rate;
• List active products for a legal entity: SELECT loan_product_id, loan_product_name, loan_class_code FROM lns_loan_products_vl WHERE org_id = :p_org_id AND status = 'A' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);
• Compare configured rate caps by product: SELECT loan_type_id, ceiling_rate, open_ceiling_rate, spread FROM lns_loan_products_vl WHERE ceiling_rate > 0;

Because the view is a read-only, translated projection, it is safe to use in reports and interfaces without affecting underlying product setup. Writes must be directed to the base tables through the LNS product setup forms or supported APIs.