Results for “disbursement_amount”

50+ results




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

Overview

The APPS.LNS_LOAN_DETAILS_EXT_V view is a Loans module (LNS) reporting object that exposes the accounting lines generated for loan transactions, formatted for extraction and downstream load into Oracle Subledger Accounting (SLA) or an external accounting system. Its documented description, "Loans Accounting Lines Extract," positions it as the interface between the LNS transaction/distribution layer and the XLA events and ledgers that ultimately produce journal entries.

In Oracle EBS 12.1.1 and 12.2.2 the Loans application accounts for disbursements, approvals, cancellations, repayments, and adjustments. Each accounting-relevant activity produces rows in LNS_DISTRIBUTIONS, each tied to an XLA_EVENTS record. This view consolidates the distribution, its accounting event, the target ledger, the loan header detail, and the account code combination into a single flattened result set suitable for extraction programs and reconciliation reports. Because the view carries an _EXT_V suffix, it is designed to be consumed by external or extension processes rather than by standard form runtime logic.

Underlying Base Objects

According to the documented 12.2.2 metadata, the view is owned by APPS and is defined over the following base objects:

  • LNS_DISTRIBUTIONS — the core distribution (accounting line) table, supplying distribution ID, line type, account name, account type, code combination, distribution amount and percent, and the DFF attributes.
  • LNS_LOAN_HEADERS_ALL — loan header, supplying loan class code, requested amount, funded amount, and subsidy rate used in amount derivation.
  • XLA_EVENTS — the accounting event driving each line, supplying EVENT_ID and EVENT_TYPE_CODE.
  • XLA_TRANSACTION_ENTITIES — supplies the ledger context for the event.
  • GL_CODE_COMBINATIONS — the account validation for the code combination.
  • LNS_DISB_HEADERS, LNS_LOAN_AMOUNT_ADJS, and FV_FUND_PARAMETERS — supporting loan disbursement, adjustment, and funding parameter data.
  • LNS_DISTRIBUTIONS_PUB and LNS_UTILITY_PUB — public packages invoked by the view logic for distribution and utility processing, including override of distribution amounts for direct-loan approval and cancellation events.

The view is therefore a join of transactional distribution data with the XLA event model, guarded by loan-class and event-type conditional logic.

Key Columns

Common Use Cases and Queries

Typical uses include extracting loan accounting lines for SLA journal creation, reconciling distributions to their accounting events, and reporting subsidy versus principal splits for direct loans. A representative query:

  • Extract all lines for a ledger and event type:
    SELECT event_id, ledger_id, loan_id, line_type, account_type, entered_amount
    FROM apps.lns_loan_details_ext_v
    WHERE ledger_id = :p_ledger_id;
  • Review reversal behaviour on cancelled direct-loan disbursements:
    SELECT loan_id, account_type, entered_amount
    FROM apps.lns_loan_details_ext_v
    WHERE line_type = 'SUBSIDY';
  • Join to GL_CODE_COMBINATIONS for the account string, and to LNS_LOAN_HEADERS_ALL via LOAN_ID for borrower context.

Because amounts and DR/CR indicators are computed, consumers should treat ENTERED_AMOUNT and ACCOUNT_TYPE as the authoritative extract values rather than the raw LNS_DISTRIBUTIONS figures.