Search Results lns_distributions_u1

Overview

The LNS.LNS_DISTRIBUTIONS table is a core subledger accounting object within the Oracle E-Business Suite Loans (LNS) module, delivered under the FND design data path LNS.LNS_DISTRIBUTIONS. It stores the actual accounting distributions generated for a given loan, functioning as the bridge between loan origination or billing activity and the General Ledger. Each row represents a single debit or credit line associated with a loan event, capturing the code combination, the amount, and the distribution type that describes how the entry originated.

From a dimensional modeling perspective, the table exhibits a satellite-leaning structure. It is anchored to a loan through a foreign key on LOAN_ID and carries a surrogate primary key (DISTRIBUTION_ID); it therefore behaves less like an independent hub and more like a transaction-level satellite that records the accounting consequences of loan events. This classification is heuristic and should be treated as a modeling suggestion rather than a declarative fact.

Key Information Stored

• DISTRIBUTION_ID — the surrogate primary key and the single-column unique index candidate (LNS_DISTRIBUTIONS_U1).
• LOAN_ID — foreign key to LNS_LOAN_HEADERS_ALL, tied to the parent loan.
• CODE_COMBINATION_ID — the GL account combination designated for the distribution (for example, a loan receivable account).
• DISB_HEADER_ID — foreign key to LNS_DISB_HEADERS linking the distribution to a disbursement.
• DISTRIBUTION_TYPE — classifies the row as ORIGINATION or BILLING.
• LINE_TYPE — the distribution line category (INT, PRIN, CLEAR, ORIG, FEE).
• ACCOUNT_TYPE and ACCOUNT_NAME — the distribution account semantic, such as LOAN_RECEIVABLE, LOAN_CLEARING, INTEREST_INCOME, or FEE_INCOME.
• DISTRIBUTION_PERCENT and DISTRIBUTION_AMOUNT — the percentage and monetary amount allocated to each line.
• EVENT_ID — foreign key to XLA_EVENTS, linking the distribution to the Subledger Accounting event.
• USSGL_TRANSACTION_CODE — the transaction code stamped on distributions created for the invoice.
• FEE_ID — foreign key to LNS_FEES.FEE_ID when the distribution relates to fee accounting.
• POSTED_FLAG — indicates whether the distribution has been posted.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the distribution record.

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of loan subledger entries to the General Ledger, analysis of principal, interest, and fee income by loan, and validation of the accounting lines generated by origination and billing events. A representative query returns the distribution lines for a specific loan, joined to the account combination and event tables:

SELECT d.distribution_id,
       d.line_type,
       d.account_type,
       d.distribution_amount,
       d.posted_flag
FROM   lns.lns_distributions d
WHERE  d.loan_id = :loan_id
AND    d.distribution_type = 'BILLING';

Analysts frequently aggregate distribution amounts by ACCOUNT_TYPE and LINE_TYPE to produce interest income or principal receivable summaries, and filter on POSTED_FLAG to identify unposted entries requiring attention. Date-ranged queries against START_DATE_ACTIVE and END_DATE_ACTIVE support period-end reporting.

Related Objects

• LNS_LOAN_HEADERS_ALL — joined on LOAN_ID to resolve the parent loan.
• LNS_DISB_HEADERS — joined on DISB_HEADER_ID for disbursement context.
• LNS_FEES — joined on FEE_ID for fee-related distributions.
• XLA_EVENTS — joined on EVENT_ID to connect distributions to Subledger Accounting events.
• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID to resolve the GL account.
• Subledger Accounting (XLA) APIs — consume these distributions when creating final accounting entries.