Search Results lns_loan_types




Overview
Explore in AI Chat

Overview

LNS_LOAN_TYPES is the loan types setup table within the Oracle E-Business Suite Loans (LNS) module. It functions as a configuration or reference master that defines the categories of loans an organization can originate, service, and account for. In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the LNS schema and holds 21 documented columns. Its primary purpose is to store the enterprise-defined loan type definitions that drive downstream processing in loan headers, loan products, default distributions, event actions, and reporting materialized views.

The Data Vault classification heuristic derived from the foreign key structure identifies LNS_LOAN_TYPES as standalone, meaning it does not itself behave as a pure hub, link, or satellite dependent on other tables. From a modeling perspective, it is best treated as a reference or classification table that acts as a stable anchor referenced by multiple transactional and setup entities.

Key Information Stored

The table is keyed by the surrogate primary key LOAN_TYPE_ID (constraint LNS_LOAN_TYPES_PK), which also appears as the unique index LNS_LOAN_TYPES_U1. The business-key candidate UNIQUE_TYPE_NAME is enforced on LOAN_TYPE_NAME, and LOAN_TYPE_CODE provides a human-readable short identifier. The most significant columns include:

Common Use Cases and Queries

Typical uses include validating which loan types are active as of a given date, reporting volume by loan class, and driving downstream processing rules. A sample query retrieving active loan types is:

SELECT LOAN_TYPE_ID, LOAN_TYPE_NAME, LOAN_CLASS_CODE, CALCULATION_METHOD, DAY_COUNT_METHOD FROM LNS.LNS_LOAN_TYPES WHERE STATUS = 'ACTIVE' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE + 1);

A common reporting pattern joins loan headers to loan types to summarize exposure:

SELECT lt.LOAN_TYPE_NAME, COUNT(*) FROM LNS.LNS_LOAN_HEADERS_ALL lh JOIN LNS.LNS_LOAN_TYPES lt ON lh.LOAN_TYPE_ID = lt.LOAN_TYPE_ID GROUP BY lt.LOAN_TYPE_NAME;

Related Objects

The following objects reference LNS_LOAN_TYPES through the LOAN_TYPE_ID column: