Results for “okl_trx_ar_adjsts”

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

Overview

IEX_WRITEOFFOBJ_PUB is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the write-off object functionality within the Oracle Collections (IEX) module, integrated with Oracle Lease Management (OKL) and Oracle Contracts (OKC). Its primary business purpose, as documented in the package header comments, is fourfold: populate the lease transaction adjustment tables OKL_TRX_ADJST_B and OKL_TXL_ADJSTS_LNS_B; invoke the OKL wrapper OKL_CREATE_ADJ_PVT to create an adjustment; verify approval requirements before allowing a write-off to proceed; and update the IEX_WRITEOFF_OBJECTS table once a write-off has been created. In Oracle 12.1.1 and 12.2.2, this package serves as the bridge between Collections write-off processing and the Lease Management adjustment engine, ensuring that financially approved write-offs are reflected consistently across the receivables, collections, and lease contract data models.

Key Procedures and Functions

• CREATE_WRITEOFFS — The core procedure that drives write-off creation. It populates the lease adjustment interface tables, calls the OKL wrapper to create the adjustment, evaluates approval requirements, and updates the write-off object record.
• GET_MESSAGES — Retrieves the stack of FND messages generated during processing and concatenates them into a single output string, parsing encoded message tokens against FND application and language data.
• GET_MESSAGES1 — A companion message-retrieval routine, typically an alternate signature used to return the full message list to callers such as forms or concurrent programs.
• APPROVE_WRITEOFFS — Handles the approval path for a write-off, confirming the record after approval succeeds.
• REJECT_WRITEOFFS — Handles the rejection path, returning the write-off to a non-approved state.
• INVOKE_WRITEOFF_WF — Invokes the Oracle Workflow process associated with write-off approvals, using WF_PARAMETER_LIST_T to pass workflow parameters.
• INIT_WRITEOFFOBJ_REC — Initializes the write-off object record structure prior to processing.

Tables Accessed

The package reads and writes across several functional areas. In Collections it touches IEX_WRITEOFFS, IEX_WRITEOFF_OBJECTS, IEX_CASES_ALL_B, and IEX_CASE_OBJECTS, which hold the write-off header, its associated object links, and the collection case context. Receivables tables AR_ADJUSTMENTS, AR_PAYMENT_SCHEDULES, and AR_PAYMENT_SCHEDULES_ALL support adjustment and payment schedule validation. Lease and contract data resides in OKL_TRX_ADJST_B, OKL_TXL_ADJSTS_LNS_B, OKL_STRM_TYPE_B, and OKC_K_HEADERS_B. Supporting FND objects include FND_NEW_MESSAGES, FND_USER, JTF_RS_RESOURCE_EXTNS, WF_PARAMETER_LIST_T, and the PL/SQL table type PLITBLM. Collectively these tables allow the package to validate the customer obligation, construct the lease adjustment, and record the resulting write-off.

Usage Notes

IEX_WRITEOFFOBJ_PUB is invoked from the Oracle Collections write-off user interface and from concurrent or backend processing that drives write-off approval workflows. Because it is classified as a public (PUB) API, custom code may call it directly, but callers must populate the correct case, object, and adjustment context first, and must handle the returned FND message stack via GET_MESSAGES for error reporting. The package header references header revision iexpwrob.pls 120.10, indicating active maintenance through the 12.1.1 release cycle and its continuation into 12.2.2. The write-off object concept is distinct from the OKL_TXL_ADJSTS_LNS search term the user supplied; that table, along with OKL_TRX_ADJST_B, is populated by this package as part of the lease adjustment creation path.