Search Results lns_distributions_pk

Overview

LNS_DISTRIBUTIONS is the Loans subledger table that stores the actual accounting distributions generated for a given loan. It resides in the LNS schema and is owned by the LNS – Loans product within Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents one distribution line associated with a loan, capturing the accounting flexfield combination (CODE_COMBINATION_ID), the amount or percentage to be distributed, the type and category of the distribution, and the posting status of that line. Because it is the persistent target of subledger accounting events, LNS_DISTRIBUTIONS functions as the bridge between loan origination and disbursement activity in the Loans module and the general ledger via Oracle Subledger Accounting.

The documented primary key is LNS_DISTRIBUTIONS_PK, defined on DISTRIBUTION_ID, and the unique index LNS_DISTRIBUTIONS_U1 also keys on DISTRIBUTION_ID. From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning: the table behaves as a descriptive satellite hanging off the loan business key (LOAN_ID), recording the time-variant descriptive detail of accounting distributions rather than acting as a pure hub or link. This is a modeling suggestion derived from the foreign key structure, not a statement of the delivered physical design.

Key Information Stored

The table contains 54 documented columns. The most significant for analysis and integration are:

• DISTRIBUTION_ID – Surrogate primary key and the unique business-key candidate (LNS_DISTRIBUTIONS_PK, LNS_DISTRIBUTIONS_U1).
• LOAN_ID – Foreign key to the parent loan; the primary grouping attribute for all distributions.
• CODE_COMBINATION_ID – The accounting flexfield combination that receives the debit or credit.
• DISTRIBUTION_TYPE and LINE_TYPE – Classify the nature of the distribution line (e.g., disbursement, fee, accrual, adjustment).
• ACCOUNT_NAME and ACCOUNT_TYPE – Human-readable account description and accounting classification.
• DISTRIBUTION_PERCENT and DISTRIBUTION_AMOUNT – The allocation percentage and monetary value of the line.
• DISB_HEADER_ID, LOAN_LINE_ID, LOAN_AMOUNT_ADJ_ID, and FEE_ID – Foreign references linking the distribution to the originating disbursement, loan line, amount adjustment, or fee.
• EVENT_ID – Identifier associating the distribution with the accounting event that produced it.
• POSTED_FLAG – Indicates whether the distribution has been transferred/posted to the general ledger.
• ACCRUAL_PERIOD, ACCRUAL_DATE, and ACCRUAL_COMPLETED_FLAG – Accrual timing and completion indicators for interest and fee accruals.
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, AWARD_ID, and EXPENDITURE_ITEM_DATE – Project and award accounting attributes supporting Grants and Projects integration.
• START_DATE_ACTIVE / END_DATE_ACTIVE – Effective dating for the distribution record.
• OBJECT_VERSION_NUMBER and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) – Concurrency control and audit trail.

Common Use Cases and Queries

Typical uses include reconciliation of loan subledger balances to the general ledger, distribution reporting by account combination, accrual analysis, and audit of posting status. A basic retrieval of distributions for a loan is:

SELECT d.distribution_id, d.loan_id, d.code_combination_id,
       d.distribution_type, d.distribution_amount, d.posted_flag
FROM   lns.lns_distributions d
WHERE  d.loan_id = :p_loan_id;

To reconcile unposted distributions that require accounting transfer:

SELECT d.loan_id, d.account_type, SUM(d.distribution_amount)
FROM   lns.lns_distributions d
WHERE  d.posted_flag = 'N'
GROUP BY d.loan_id, d.account_type;

Accrual monitoring uses ACCRUAL_PERIOD and ACCRUAL_COMPLETED_FLAG to identify open accrual lines, while project reporting filters on PROJECT_ID and AWARD_ID. Because DISTRIBUTION_ID is unique and INDEX-backed, single-row lookups by primary key are the most selective access path.

Related Objects

• LNS_DISTRIBUTIONS (LOAN_ID) – Self-referenced foreign key documented as LNS_DISTRIBUTIONS.LOAN_ID; distributes rows to the parent loan entity.
• LNS_LOANS / loan master – Parent entity keyed by LOAN_ID; the principal header record owning these distributions.
• LNS_DISBURSEMENTS / disbursement headers – Referenced through DISB_HEADER_ID for disbursement-generated lines.
• LNS_FEES – Referenced through FEE_ID for fee-related distributions.
• LNS_LOAN_LINES – Referenced through LOAN_LINE_ID for line-level distribution detail.
• LNS_LOAN_AMOUNT_ADJ – Referenced through LOAN_AMOUNT_ADJ_ID for adjustment distributions.
• GL_CODE_COMBINATIONS – Joined on CODE_COMBINATION_ID to resolve the accounting flexfield.
• XLA_EVENTS / Subledger Accounting tables – EVENT_ID links distributions to the SLA event that created them.
• PA_PROJECTS / PA_TASKS / GMS_AWARDS – Joined on PROJECT_ID, TASK_ID, and AWARD_ID for project and grant accounting.

These relationships make LNS_DISTRIBUTIONS the central fact-like object for loan accounting analysis, linking loan activity to general ledger, subledger accounting, and project costing repositories.