Results for “okl_accounting_util_w”

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

Overview

The OKL_ACCOUNTING_UTIL_W package body in the APPS schema is a worker (suffix "_W") utility package within the Oracle Lease and Finance Management (OKL) accounting subsystem of Oracle E-Business Suite. It complements the public-facing OKL_ACCOUNTING_UTIL package by providing internal helper routines used to prepare, copy, and convert lease accounting data between interface staging structures and the operational tables. In release 12.1.1 and 12.2.2 the package is documented as VALID and classified as "OTHER" in ETRM, indicating it is an internally consumed utility layer rather than a published API. Its core responsibility is to support currency conversion, accounting segment/period derivation, and structured data transfer used by the lease accounting generation and period-close processes, especially when Oracle Lease Management is integrated with Oracle Subledger Accounting (SLA).

Key Procedures and Functions

ETRM documents 24 program units in this package body. The most prominent are the Rosetta table-copy routines, which marshal data between PL/SQL record/collection structures and the interface table used for accounting event staging:

• ROSETTA_TABLE_COPY_IN_P0 through ROSETTA_TABLE_COPY_OUT_P3 (and ROSETTA_TABLE_COPY_IN_P26 / ROSETTA_TABLE_COPY_OUT_P26) — numbered family of "copy in"/"copy out" helpers that move rows between internal collection types and the PLITBLM staging table in both directions, indexed by caller-defined shape numbers (P0, P1... P26).
• GET_SEGMENT_ARRAY — returns an array of accounting flexfield segment values used to build the accounting distribution for a lease transaction.
• GET_ACCOUNTING_SEGMENT — resolves a single accounting segment value (for example, the natural account or cost center) for a given transaction line.
• GET_PERIOD_INFO — retrieves GL period and date information used to derive the accounting date for a lease event.
• CHECK_OVERLAPS — validates that accounting periods or effective-dated ranges do not overlap before generation runs.
• GET_CURR_CON_RATE — fetches the daily conversion rate between the contract and functional currencies.
• CONVERT_TO_FUNCTIONAL_CURRENCY and CONVERT_TO_CONTRACT_CURRENCY — perform monetary conversion of lease amounts between the contract currency and the ledger's functional currency.
• GET_VERSION — returns the package version identifier for diagnostics.
• GET_ERROR_MESSAGE and GET_ERROR_MSG — standard error-handling helpers that retrieve and format the message text associated with an error code returned by the FND_API message stack.

No parameter lists are documented in ETRM; signatures are defined in the package specification and should be read from the R12 database.

Tables Accessed

The only table documented as referenced through an APPS synonym is PLITBLM, the standard Oracle intermedia/PL/SQL interface table used for passing bulk collections between procedural logic and the server. OKL_ACCOUNTING_UTIL_W reads and writes this table via its ROSETTA_TABLE_COPY_IN_* and ROSETTA_TABLE_COPY_OUT_* routines to stage accounting records prior to processing. All other accounting reads and writes are delegated to the parent package OKL_ACCOUNTING_UTIL, which the worker body depends on and calls.

Usage Notes

OKL_ACCOUNTING_UTIL_W is an internal dependency and is not referenced by any database object, so it is never invoked directly by customers. It is called at runtime by its sibling package OKL_ACCOUNTING_UTIL, which in turn is driven by Enterprise Command Center and lease accounting concurrent programs, the OKL accounting generation routines, and lease-related OAF forms whenever currency conversion, period derivation, or segment resolution is required. Because it uses FND_API for error propagation, callers should expect standard FND_API exceptions (for example, FND_API.G_EXC_ERROR) and should inspect the FND message stack rather than relying on SQLCODE. Its currency and overlap helpers are also useful reference points when troubleshooting conversion balances, accounting date derivation, or duplicate period issues in Lease Management.