Results for “loan_term_period”

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

Overview

The LNS_LOAN_PRODUCTS_ALL table is the central loan product setup table within the Oracle E-Business Suite Loans (LNS) module. It stores the template definitions that govern how individual loan agreements behave throughout their lifecycle, including interest calculation rules, amortization schedules, approval requirements, collateral thresholds, and accounting-relevant behavior flags. Every loan contract created in the LNS module must reference a loan product defined in this table, making it one of the foundational configuration objects of the application.

The table resides in the LNS schema and is a valid, multi-organization (multi-org) enabled object, as evidenced by the presence of the ORG_ID column. Its primary key is defined by LNS_LOAN_PRODUCTS_ALL_PK, keyed on the surrogate LOAN_PRODUCT_ID. A second unique index, UNIQUE_PRODUCT_NAME, enforces uniqueness on LOAN_PRODUCT_NAME combined with ORG_ID (and effectively LOAN_CLASS_CODE), which serves as the business-key candidate. The table contains 94 documented columns in the 12.2.2 physical schema.

From a heuristic Data Vault modeling perspective extracted from the foreign-key structure, this table is classified as hub-leaning. It functions primarily as a keyed reference entity that is referenced by satellite-style detail tables such as LNS_LOAN_PRODUCT_FLAGS and LNS_LOAN_PRODUCT_LINES.

Key Information Stored

The most significant columns fall into logical groupings:

• Identity and classification: LOAN_PRODUCT_ID (surrogate primary key), LOAN_PRODUCT_NAME (business-key candidate), LOAN_PRODUCT_DESC, LOAN_CLASS_CODE, LOAN_SUBTYPE, and STATUS.
• Lifecycle dating: START_DATE_ACTIVE and END_DATE_ACTIVE control product availability windows.
• Term and amount controls: LOAN_TERM, LOAN_TERM_PERIOD, MAX_LOAN_TERM, REQUESTED_AMOUNT, and MAX_REQUESTED_AMOUNT.
• Interest and rate configuration: INDEX_RATE_ID, RATE_TYPE, SPREAD, FLOOR_RATE, CEILING_RATE, INTEREST_CALCULATION_METHOD, and DAY_COUNT_METHOD.
• Payment and amortization: LOAN_PAYMENT_FREQUENCY, AMORTIZATION_FREQUENCY, PAYMENT_CALC_METHOD, and PRINCIPAL_PAYMENT_FREQUENCY.
• Approval and control flags: LOAN_APPR_REQ_FLAG, BDGT_REQ_FOR_APPR_FLAG, and APPR_REQ_FOR_CNCL_FLAG.
• Organization and audit: ORG_ID, LEGAL_ENTITY_ID, and the standard WHO columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER.
• Descriptive flexfield: ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active products for a given operating unit, extracting product-level rate configurations for treasury analysis, and joining product rules to booked loan contracts.

• Active products by organization: SELECT LOAN_PRODUCT_NAME, LOAN_CLASS_CODE FROM LNS_LOAN_PRODUCTS_ALL WHERE ORG_ID = :p_org AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);
• Product rate profile: SELECT LOAN_PRODUCT_NAME, RATE_TYPE, SPREAD, FLOOR_RATE, CEILING_RATE FROM LNS_LOAN_PRODUCTS_ALL WHERE LOAN_PRODUCT_ID = :p_id;
• Product flags detail: join to LNS_LOAN_PRODUCT_FLAGS on LOAN_PRODUCT_ID to retrieve behavioral options.
• Product lines detail: join to LNS_LOAN_PRODUCT_LINES on LOAN_PRODUCT_ID for line-level configuration.

These queries commonly back Oracle Loans setup reports, product comparison dashboards, and data migration extracts between instances.

Related Objects

The table participates in a well-defined relationship network anchored by its primary key and foreign keys.

• LNS_LOAN_TYPES — referenced through LNS_LOAN_PRODUCTS_ALL.LOAN_TYPE_ID, defining the loan type a product belongs to.
• FV_LEGAL_ENTITIES — referenced through LEGAL_ENTITY_ID, linking each product to its owning legal entity.
• LNS_LOAN_PRODUCT_FLAGS — child table foreign-keying back via LOAN_PRODUCT_ID.
• LNS_LOAN_PRODUCT_LINES — child table foreign-keying back via LOAN_PRODUCT_ID.
• Loan contract and transaction tables in the LNS schema also depend indirectly on this configuration hub when loans are booked against a product.