Search Results create_adjustments

Overview

The APPS.OKL_CREATE_ADJST_PVT package is a private PL/SQL API within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Territory and Resource Management (ETRM) family of applications. Its principal business function is the creation of accounting adjustments associated with lease and finance contracts, particularly adjustments that must be reflected against Accounts Receivable (AR) transactions, payment schedules, and receivable transaction types. The package operates as the implementation layer (classified as PVT, the private counterpart) supporting the public API surface exposed by OKL_CREATE_ADJST_PUB. In EBS 12.1.1 and 12.2.2, this package is critical for maintaining financial integrity when adjustments — such as corrections, reclassifications, or contract-level restatements — need to be propagated into the lease accounting streams and the corresponding AR sub-ledger records.

Key Procedures and Functions

The package exposes two documented procedures:

• CREATE_ADJUSTMENTS — The core routine responsible for building and persisting adjustment records. It orchestrates the validation and insertion of adjustment data across the various OKL and AR tables, ensuring the lease transaction's accounting distributions remain consistent with the revised transaction amounts.
• IEX_CREATE_ADJUSTMENTS — An extension routine named with the IEX (Collections / Advanced Collections) prefix, indicating integration with collections-related adjustment processing. It likely delegates or supplements the primary adjustment creation logic to support collections-driven adjustment scenarios.

No parameter signatures are documented in the ETRM metadata; the routines are intended for internal invocation rather than direct external calls.

Tables Accessed

The package reads and writes an extensive set of tables via APPS synonyms, including:

• AR_ADJUSTMENTS, AR_PAYMENT_SCHEDULES_ALL, AR_RECEIVABLES_TRX_ALL, RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL — the Accounts Receivable core tables where adjustment entries and receivable transaction references are recorded.
• OKL_TRX_AR_ADJSTS_B / _TL, OKL_TXL_ADJSTS_LNS_B — lease transaction AR adjustment base, translation, and line tables that store the lease-specific adjustment detail.
• OKL_TRNS_ACC_DSTRS, OKL_CNSLD_AR_STRMS_B, OKL_SYS_ACCT_OPTS — accounting distribution, consolidated AR stream, and system accounting option tables that drive how adjustments are posted.
• OKC_K_HEADERS_B, OKL_TRX_TYPES_TL — contract header and transaction type reference data providing context for the adjustment.

PLITBLM (a PL/SQL index-by table type) is used as an in-memory structure for bulk processing.

Usage Notes

OKL_CREATE_ADJST_PVT is not intended for direct customer invocation. It is referenced by OKL_CREATE_ADJST_PUB, which serves as the supported entry point, and internally by itself (recursive reference). Custom development should always call the public wrapper. Typical invocation paths include lease contract adjustment forms, concurrent programs that batch-process AR adjustments for lease streams, and Advanced Collections integration. When customizing or troubleshooting, developers should trace through the public API first, then examine this private package for underlying table activity. Because it depends on OKC_API, OKL_ADJ_PVT, OKL_AJL_PVT, and OKL_API, any version change to those dependencies can affect its behavior across releases.