Search Results lns_loan_headers_all

Overview

The LNS_LOAN_HEADERS_ALL table is the central master data object within the Oracle Loans (LNS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the foundational header record for every loan contract or agreement entered into the system. Each row represents a unique loan, storing its core administrative, financial, and relational attributes. As a multi-org table, it contains the ORG_ID column to segregate data by operating unit, enabling a single installation to support multiple business entities. Its primary role is to act as the parent record for a comprehensive loan portfolio, linking to critical transactional, customer, and product data across the EBS ecosystem.

Key Information Stored

The table's primary key is the LOAN_ID, a unique system-generated identifier for each loan. Based on its documented foreign key relationships, the table stores essential relational pointers that define the loan's context. Key foreign key columns include PRIMARY_BORROWER_ID and CUST_ACCOUNT_ID, linking to HZ_PARTIES and HZ_CUST_ACCOUNTS respectively to identify the borrowing customer. The PRODUCT_ID links to the loan product definition. Operational data includes LOAN_ASSIGNED_TO and LOAN_APPROVED_BY, which reference resources in JTF_RS_RESOURCE_EXTNS for workflow and responsibility tracking. Financial integration is facilitated by REFERENCE_ID and REFERENCE_TYPE_ID, linking to receivables transactions (RA_CUSTOMER_TRX_ALL) and transaction types. The BILL_TO_ACCT_SITE_ID defines the billing address via HZ_CUST_ACCT_SITES_ALL.

Common Use Cases and Queries

This table is central to loan lifecycle management and reporting. Common operational use cases include generating a portfolio summary report, viewing loan details for customer service, and identifying loans assigned to a specific officer. Analytical queries often join this table with its child transactional tables to assess portfolio performance. A fundamental query pattern retrieves loan header information along with customer details:

• SELECT lh.loan_id, lh.loan_number, hz.party_name, lh.creation_date FROM lns_loan_headers_all lh, hz_parties hz WHERE lh.primary_borrower_id = hz.party_id AND lh.org_id = :p_org_id;

Another critical use case involves tracing the integration with Oracle Receivables by joining on the reference identifiers to match loans with their corresponding invoices or transactions for reconciliation purposes.

Related Objects

The LNS_LOAN_HEADERS_ALL table has extensive relationships within the Loans module and with core EBS applications. Key child tables within LNS that reference its LOAN_ID include LNS_LOAN_HISTORIES_H for tracking changes, LNS_PARTICIPANTS for multi-lender loan structures, and LNS_TERMS for detailed payment schedules. As documented, its primary integration points are with Oracle Trading Community Architecture (HZ_PARTIES, HZ_CUST_ACCOUNTS), Oracle Human Resources (HR_ALL_ORGANIZATION_UNITS for ORG_ID), Oracle Receivables (RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_TYPES_ALL), and Oracle Resource Manager (JTF_RS_RESOURCE_EXTNS). This network of relationships underscores its role as the hub for loan-centric data across the integrated EBS suite.