Search Results update_post_to_gl

Overview

OKL_ACCOUNT_DIST_PUB is the public API package body for the Oracle Lease and Finance Management (OKL) accounting distribution engine in Oracle EBS 12.1.1 and 12.2.2. Its principal responsibility is to generate, retrieve, and maintain the accounting distribution lines that drive the sub-ledger postings for lease contracts, and to manage the flag that determines whether those distributions are ultimately transferred to the General Ledger. The package acts as the published interface layer over the private worker package OKL_ACCOUNT_DIST_PVT; the public body wraps the private implementation with FND_API-compliant error handling, SAVEPOINT-based transaction control, and debug instrumentation (the automatically generated wrapper referencing OKL_DEBUG_PUB and the LEASE.ACCOUNTING.ENGINE module). All procedures expose a standard API signature pattern with p_api_version, p_init_msg_list, and x_return_status/x_msg_count/x_msg_data OUT parameters.

Key Procedures and Functions

• CREATE_ACCOUNTING_DIST — The core procedure of the package. It accepts a template identification record, a distribution information record, a context value table, and a table of accounting generation primary keys, and returns a template table and an amount table. It delegates execution to the private OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST routine, first establishing a savepoint, initializing the return status to success, and invoking debug logging when enabled.
• GET_TEMPLATE_INFO — Retrieves accounting template information required to determine how distributions should be derived for a given transaction or event. It supplies the template metadata consumed by the creation and update flows.
• UPDATE_POST_TO_GL — The procedure directly associated with the user's search term. It updates the Post to GL indicator on accounting distribution records, controlling whether the affected distribution lines are eligible for transfer to the General Ledger. This is the mechanism by which the accounting engine flags distributions for GL posting or suppresses them.
• DELETE_ACCT_ENTRIES — Removes accounting entry (distribution) records that are no longer valid, supporting correction and re-generation scenarios within the accounting engine.
• REVERSE_ENTRIES — Creates reversing accounting distribution entries, used when a previously generated distribution must be undone while preserving the audit trail of the original posting.

Tables Accessed

The documented table reference for this package is OKL_TRNS_ACC_DSTRS, the transaction accounting distributions table, accessed through its APPS synonym. This table stores the individual accounting distribution lines generated by the engine, including the Post to GL indicator that UPDATE_POST_TO_GL maintains. CREATE_ACCOUNTING_DIST inserts rows into this table; GET_TEMPLATE_INFO reads template and distribution context; DELETE_ACCT_ENTRIES removes obsolete rows; and REVERSE_ENTRIES inserts offsetting rows. Because the package is a public API, all table access is performed through the private package, keeping the data model encapsulated.

Usage Notes

OKL_ACCOUNT_DIST_PUB is invoked by the Lease Management accounting engine when lease transactions are booked, billed, or adjusted, and when accounting is regenerated after contract changes. It is referenced by 25 other packages, indicating that it is a foundational dependency for downstream lease accounting, revenue recognition, and GL interface processing. It may be called from Oracle Forms within the Lease Management responsibility, from concurrent programs that run the accounting generation process, or from custom code requiring programmatic creation, update, deletion, or reversal of accounting distributions. The header revision (120.2, dated 2006) demonstrates that the interface has been stable across the 12.1.1 and 12.2.2 releases.