Search Results create_accounting_dist

Overview

OKL_ACCOUNT_DIST_PUB is the public PL/SQL API for Oracle Lease and Finance Management (OKL) that governs the generation, maintenance, and reversal of accounting distributions for lease and loan transactions. In Oracle EBS 12.1.1 and 12.2.2 it functions as the supported external interface to the internal private package OKL_ACCOUNT_DIST_PVT, from which it inherits a number of its datatype definitions through SUBTYPE declarations. The package is compiled with AUTHID CURRENT_USER, meaning that its SQL executes under the privileges of the calling schema rather than the definer, so callers must hold the appropriate grants on the underlying OKL objects and APPS synonyms.

The core business purpose is to take transaction context (a distribution template, distribution information, context values, and account generator keys) and derive the corresponding accounting flexfield combinations, amounts, and GL dates used for subledger accounting entries. This is central to Lease Management's integration with General Ledger, because every lease transaction that must post to GL requires valid, balanced accounting distributions that respect the distribution template rules configured for the contract.

Key Procedures and Functions

• CREATE_ACCOUNTING_DIST — The principal procedure of the package and the object users locate when searching for "create_accounting_dist." It accepts a template identification record, a distribution information record, a context value table, and an account generator primary key table, and returns a template value table plus an amount table (and, in the second overload, a GL date). It builds the accounting distribution lines from the supplied template and context.
• GET_TEMPLATE_INFO — Retrieves template information associated with a transaction so that callers can determine which distribution template applies before generating distributions.
• UPDATE_POST_TO_GL — Updates the post-to-GL indicator on distribution records, controlling whether the generated accounting entries are eligible for transfer to General Ledger.
• DELETE_ACCT_ENTRIES — Removes accounting distribution entries, typically used when a transaction is re-processed or corrected and prior distributions must be discarded.
• REVERSE_ENTRIES — Creates reversing accounting entries, supporting the standard accounting practice of backing out previously generated distributions without deleting the original records.

Tables Accessed

The documented table referenced through APPS synonyms is OKL_TRNS_ACC_DSTRS, the transaction accounting distributions table. This is the primary store for the distribution rows generated by CREATE_ACCOUNTING_DIST and maintained by UPDATE_POST_TO_GL, DELETE_ACCT_ENTRIES, and REVERSE_ENTRIES. The package also depends on the subtype definitions inherited from OKL_ACCOUNT_DIST_PVT, OKL_TRNS_ACC_DSTRS_PUB, OKL_TMPT_SET_PUB, and OKL_ACCOUNT_GENERATOR_PUB, indicating that template setup, account generator rules, and distribution tables are all consulted during distribution generation.

Usage Notes

OKL_ACCOUNT_DIST_PUB is invoked programmatically rather than through a dedicated form. Typical callers include Lease Management transaction processing, accounting generation concurrent programs, and other OKL public packages — the ETRM metadata records 25 dependent packages referencing this API. Custom code that needs to generate or reverse lease accounting distributions should call CREATE_ACCOUNTING_DIST, passing the API version and message list parameters, then inspect x_return_status, x_msg_count, and x_msg_data using the standard FND_MSG_PUB error-handling pattern. Because the package runs under AUTHID CURRENT_USER, and because its signature is versioned through p_api_version, developers should always pass the expected API version and rely solely on the documented public procedures rather than the private OKL_ACCOUNT_DIST_PVT implementation.