Results for “loan_product_name”

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

Overview

LNS_LOAN_PRODUCTS_ALL_TL is the translation (multi-lingual) table for the Loans module base table LNS_LOAN_PRODUCTS_ALL in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-dependent descriptive columns for each loan product record, allowing the same logical product to carry a distinct name and description per installed language. The base table holds language-independent attributes (product rules, interest parameters, currency, and so on), while this table holds only the translated text.

The _TL suffix follows the standard EBS translation-table naming convention, in which each row is keyed by the entity identifier plus a LANGUAGE code. The presence of SOURCE_LANG identifies the language from which the translation was derived, and the WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) provide the standard audit trail. The table resides in the LNS schema and has an object status of VALID. Its heuristic Data Vault classification is standalone, meaning it holds no foreign-key dependencies of its own; as a modeling suggestion, it can be treated as a satellite attached to the loan-product hub, since it carries descriptive, language-qualified attributes rather than relationships or keys of its own.

Key Information Stored

The table contains ten documented columns. The essential ones are:

• LOAN_PRODUCT_ID — the surrogate/foreign key back to the base table LNS_LOAN_PRODUCTS_ALL. Together with LANGUAGE it forms the composite primary key.
• LANGUAGE — the installed Oracle language code (for example, US) for the translated text; the second component of the primary key.
• LOAN_PRODUCT_NAME — the translated display name of the loan product, the primary business-facing attribute.
• LOAN_PRODUCT_DESC — the translated long description of the product.
• SOURCE_LANG — the language from which this translation row was generated, used by the translation-repair and language-installation utilities.
• Standard WHO audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

The primary key LNS_LOAN_PRODUCTS_ALL_TL_PK is defined on the composite (LOAN_PRODUCT_ID, LANGUAGE). There is no separate single-column surrogate key in this table: LOAN_PRODUCT_ID is the surrogate key inherited from the base table, while the effective business key for a translation row is LOAN_PRODUCT_ID plus LANGUAGE, which is also what the primary key enforces.

Common Use Cases and Queries

Typical uses fall into three patterns. First, resolving the display name of a loan product for a given language, which is the most common lookup:

• SELECT loan_product_id, loan_product_name, loan_product_desc FROM lns.lns_loan_products_all_tl WHERE loan_product_id = :p_id AND language = USERENV('LANG');
• Joining base and translation to report product attributes with translated text: SELECT b.loan_product_id, t.loan_product_name FROM lns.lns_loan_products_all_vl b, ... WHERE b.loan_product_id = t.loan_product_id; (in practice the _VL view encapsulates this join).
• Auditing which products have missing translations, by comparing rows in the base table against this table per LANGUAGE.

Reporting scenarios include product catalogue extracts, multi-lingual statements and advices that must print the customer's language version of a product name, and verification queries after language installation or translation import.

Related Objects

• LNS_LOAN_PRODUCTS_ALL — the base table; joined on LOAN_PRODUCT_ID.
• LNS_LOAN_PRODUCTS_ALL_VL — the translated view that combines base and _TL rows, filtered by the session language.
• LNS_LOAN_PRODUCTS_ALL_B — the base-table synonym/alias used in the standard _B/_TL/_VL triad.
• LNS_LOAN_PRODUCTS_ALL_TL_PK — the primary-key constraint on (LOAN_PRODUCT_ID, LANGUAGE).
• Contract and loan origination tables in the LNS schema that reference LOAN_PRODUCT_ID, such as LNS_LOANS_ALL, LNS_CONTRACTS_ALL and related LNS product-parameter tables, which resolve product names through this translation table.
• FND_LANGUAGES / FND_TERRITORIES — reference tables validating the LANGUAGE and SOURCE_LANG values.