Search Results unique_type_name

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:

• LOAN_TYPE_ID — surrogate primary key uniquely identifying each loan type record.
• LOAN_CLASS_CODE — classification code grouping loan types into broader categories.
• LOAN_TYPE_NAME — descriptive name of the loan type; subject to the unique name constraint.
• LOAN_TYPE_CODE — short alphanumeric code used for identification and lookup.
• LOAN_TYPE_DESC — free-text description of the loan type.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective date range controlling when the type is usable.
• STATUS — indicates the active or inactive lifecycle state of the record.
• CALCULATION_METHOD — determines how interest or balances are computed.
• DAY_COUNT_METHOD — the day count convention applied to accrual calculations.
• MULTIPLE_FUNDING_FLAG, OPEN_TO_TERM_FLAG, CREDIT_REVIEW_FLAG — indicator flags governing funding behavior, conversion of open loans to term loans, and credit review requirements.
• PAYMENT_APPLICATION_ORDER and PMT_APPL_ORDER_SCOPE — define the order and scope in which payments are applied across components.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER track the record's lifecycle and support optimistic locking.

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:

• LNS_LOAN_HEADERS_ALL.LOAN_TYPE_ID — transactional loan master records.
• LNS_LOAN_PRODUCTS_ALL.LOAN_TYPE_ID — loan product setup definitions.
• LNS_DEFAULT_DISTRIBS_ALL.LOAN_TYPE_ID — default distribution configuration.
• LNS_LOAN_DTLS_ALL_MV.LOAN_TYPE_ID — loan detail reporting materialized view.
• LNS_EVENT_ACTIONS.LOAN_TYPE_ID — event-driven processing rules bound to loan types.