Results for “reference_type_id”

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

Overview

LNS_LOAN_HEADERS_ALL is the master transactional table within the Oracle E-Business Suite Loans (LNS) module, holding one row for every loan record originated, tracked, or serviced through the application. It functions as the central header entity within the LNS data model, capturing the terms, balances, parties, billing references, and lifecycle status of each loan. Downstream transactional tables such as disbursement schedules, participant allocations, loan terms, and history records attach to a loan exclusively through the LOAN_ID surrogate key defined here.

From a dimensional modeling perspective, the mined foreign key structure suggests a satellite-leaning classification for this table. It carries a dense set of descriptive and monetary attributes tied to a single primary key (LOAN_ID), with relatively few outbound foreign keys to peer transactional entities. Modelers building a Data Vault representation would typically treat LNS_LOAN_HEADERS_ALL as the satellite surrounding a loan hub keyed on LOAN_ID, with borrower and customer account references resolved through links to HZ_PARTIES and HZ_CUST_ACCOUNTS.

Key Information Stored

The table is defined with 108 columns in the documented 12.2.2 physical schema. The surrogate primary key, enforced by LNS_LOAN_HEADERS_ALL_PK, is LOAN_ID. Two unique indexes provide business-key candidates: LNS_LOAN_HEADERS_ALL_U1 on LOAN_ID and LNS_LOAN_HEADERS_ALL_U2 on LOAN_NUMBER, making LOAN_NUMBER the human-facing loan identifier.

• LOAN_NUMBER / LOAN_DESCRIPTION — the user-visible loan identifier and free-text description.
• INITIAL_LOAN_BALANCE, FUNDED_AMOUNT, REQUESTED_AMOUNT — principal amounts at origination and funding stages.
• LOAN_CURRENCY, EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_DATE — currency and foreign-exchange conversion attributes.
• LOAN_START_DATE, LOAN_MATURITY_DATE, LOAN_TERM, LOAN_TERM_PERIOD — term structure and schedule timing.
• LOAN_STATUS, SECONDARY_STATUS, LOAN_CLASS_CODE, LOAN_TYPE, LOAN_SUBTYPE, LOAN_PURPOSE_CODE — lifecycle and classification attributes.
• PRIMARY_BORROWER_ID, CUST_ACCOUNT_ID, BILL_TO_ACCT_SITE_ID — borrower, customer account, and billing site references.
• LOAN_ASSIGNED_TO, LOAN_APPROVED_BY, LOAN_APPROVAL_DATE — assignment and approval tracking.
• REFERENCE_ID, REFERENCE_TYPE_ID, REFERENCE_NUMBER — linkage to Receivables transactions and transaction types.
• ORG_ID, LEGAL_ENTITY_ID — multi-org and legal-entity ownership.
• LAST_PAYMENT_DATE, LAST_PAYMENT_AMOUNT, LAST_BILLED_DATE — recent activity indicators.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield storage.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing all active loans for a customer, reconciling funded balances by legal entity, and extracting loan populations for billing feeds.

• Retrieving a loan by its business key: SELECT LOAN_ID, LOAN_NUMBER, LOAN_STATUS, FUNDED_AMOUNT FROM LNS.LNS_LOAN_HEADERS_ALL WHERE LOAN_NUMBER = :p_loan_number;
• Aggregating funded balances by legal entity and org: SELECT LEGAL_ENTITY_ID, ORG_ID, SUM(FUNDED_AMOUNT) FROM LNS.LNS_LOAN_HEADERS_ALL GROUP BY LEGAL_ENTITY_ID, ORG_ID;
• Joining to borrower data: SELECT l.LOAN_NUMBER, p.PARTY_NAME FROM LNS.LNS_LOAN_HEADERS_ALL l, HZ_PARTIES p WHERE l.PRIMARY_BORROWER_ID = p.PARTY_ID AND l.LOAN_STATUS = 'ACTIVE';
• Identifying loans ready for billing through REFERENCE_ID and REFERENCE_TYPE_ID against RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL.

Related Objects

• LNS_TERMS — joined on LOAN_ID; holds term and rate detail for each header row.
• LNS_PARTICIPANTS — joined on LOAN_ID; stores syndication and participant allocations.
• LNS_LOAN_HISTORIES_H — joined on LOAN_ID; retains historical versions of loan records.
• HZ_PARTIES — referenced via PRIMARY_BORROWER_ID, CONTACT_PERS_PARTY_ID, and CONTACT_REL_PARTY_ID.
• HZ_CUST_ACCOUNTS / HZ_CUST_ACCT_SITES_ALL — referenced via CUST_ACCOUNT_ID and BILL_TO_ACCT_SITE_ID.
• RA_CUSTOMER_TRX_ALL / RA_CUST_TRX_TYPES_ALL — referenced via REFERENCE_ID and REFERENCE_TYPE_ID.
• JTF_RS_RESOURCE_EXTNS — referenced via LOAN_ASSIGNED_TO and LOAN_APPROVED_BY.
• HR_ALL_ORGANIZATION_UNITS / FV_LEGAL_ENTITIES / LNS_LOAN_TYPES — referenced via ORG_ID, LEGAL_ENTITY_ID, and LOAN_TYPE_ID.