Search Results create_disbursementdistribs

Overview

APPS.LNS_DISTRIBUTIONS_PUB is the public distribution engine for Oracle Loans (LNS), the E-Business Suite module used to originate, fund, and account for loan agreements. Loan transactions — disbursements, repayments, adjustments, accruals, and payoff activities — must be converted into accounting distributions before they can be transferred to Oracle Subledger Accounting and ultimately to the General Ledger. This package is the component that performs that conversion, generating, transforming, validating, and cancelling distribution lines for loan activity.

The package is classified as a PUB (public) API, meaning its procedures form a supported, callable interface for other EBS modules and for customer extensions. Its object status is VALID in the APPS schema. It depends on the SQL*Plus STANDARD package and is referenced by five other loan application packages, including LNS_APPROVAL_ACTION_PUB, LNS_FUNDING_PUB, LNS_IMPORT_LOAN_PUB, and both the specification and body of LNS_DISTRIBUTIONS_PUB_W, which acts as the workflow-enabled wrapper. It is also referenced by the LNS_LOAN_DETAILS_EXT_V view. This dependency pattern confirms that the package sits near the centre of the Loans accounting flow, invoked whenever approval, funding, manual adjustment, or import actions require accounting lines to be produced.

Key Procedures and Functions

The package exposes 36 documented procedures and functions. They group into the following functional areas:

• Distribution generation: GETDISTRIBUTIONS, GETDEFAULTDISTRIBUTIONS, DEFAULTDISTRIBUTIONS, DEFAULTDISTRIBUTIONSCATCH, and CREATE_DISBURSEMENTDISTRIBS create and retrieve distribution sets for loan transactions, including the default accounting that applies when no explicit distribution exists.
• Amount derivation: CALCULATEDISTRIBUTIONAMOUNT and CALCULATEDISTAMOUNT compute the amount to be posted to each distribution line.
• Accounting validation: VALIDATEACCOUNTING, VALIDATEDEFAULTACCOUNTING, and VALIDATELOANLINES verify that the derived accounts, flexfield combinations, and loan lines are valid before accounting is created.
• Flexfield utilities: GETVALUESETID and GETFLEXSEGMENTNUMBER resolve value set identifiers and key flexfield segment numbers used when building account combinations.
• Posting and transformation: ONLINEACCOUNTING and TRANSFORMDISTRIBUTION drive real-time accounting creation and the conversion of raw distribution data into accounting events.
• Reporting and events: GENERATE_BC_REPORT produces budgetary-control reporting output, BUDGETARY_CONTROL performs the budgetary control check, and CREATE_EVENT creates the accounting event associated with a loan transaction.
• Cancellation: CANCEL_DISBURSEMENTS reverses or cancels previously created disbursement distributions when a loan is modified or backed out.
• Concurrent processing: LNS_ACCOUNTING_CONCUR is the concurrent-program entry point that drives the batch accounting process for loans.

Tables Accessed

Table access occurs through APPS synonyms. The package reads and writes loan-specific distribution and schedule data in LNS_AMORTIZATION_LINES and LNS_AMORTIZATION_SCHEDS. It reads receivables transaction and adjustment setup from AR_ADJUSTMENTS, AR_ADJUSTMENTS_ALL, and AR_RECEIVABLES_TRX to determine the correct receivable account for repayment activity. Currency and language information comes from FND_CURRENCIES and FND_LANGUAGES, while accounting flexfield metadata is read from FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_TYPES, and FND_SEGMENT_ATTRIBUTE_VALUES. Ledger context and open-period validation use GL_LEDGERS and GL_PERIOD_STATUSES. Grant-related distributions reference GMS_AWARDS, and third-party name and organization data are read from HZ_PARTIES and HR_ALL_ORGANIZATION_UNITS_TL.

Usage Notes

LNS_DISTRIBUTIONS_PUB is not normally called directly by end users. It is invoked by the Loans forms and concurrent programs whenever a loan transaction requires accounting — approval, funding, disbursement cancellation, or the scheduled LNS accounting concurrent request executed by LNS_ACCOUNTING_CONCUR. The accompanying wrapper package LNS_DISTRIBUTIONS_PUB_W makes the same functionality available to Oracle Workflow processes. Custom integrators who need to create loan distributions programmatically should call this public API rather than manipulating the underlying LNS tables directly, because the package enforces accounting validation, flexfield resolution, and event creation. Because it is referenced by LNS_FUNDING_PUB and LNS_IMPORT_LOAN_PUB, changes to loan funding or import logic in a 12.1.1 or 12.2.2 environment should be tested against this package's accounting interfaces.