Search Results update_interface_status

Overview

OKL_RV_INTERFACE_PVT is the private implementation package body for the residual value (RV) interface processing component of Oracle E-Business Suite's Enterprise Asset Management / Lease Management (EAM/OKL) module. In EBS 12.1.1 and 12.2.2, the OKL schema supports the Oracle Lease and Finance Management product, where residual values represent the projected worth of a leased asset at the conclusion of the lease term. The RV Interface package serves as the batch processing engine that validates, loads, and transforms incoming residual value data, and subsequently generates residual value records against item categories.

The package follows Oracle's standard public/private (PVT) API design pattern, meaning its procedures are intended for internal or restricted invocation rather than direct external API calls. Its responsibilities include reading staged interface records, applying business validation rules, writing errors to the concurrent manager log, updating interface row statuses, and producing the final residual value output.

Key Procedures and Functions

Eight documented procedures constitute the package's processing pipeline:

• PURGE_RECORD — Removes or clears processed residual value interface records, supporting housekeeping and re-run scenarios in the concurrent processing lifecycle. This is the routine associated with the "purge_record" search term.
• PROCESS_RECORD — The orchestrating routine that drives validation and processing of an individual interface record, invoking error reporting as needed.
• CHECK_INPUT_RECORD — Performs validation checks against incoming interface data before processing proceeds.
• LOAD_INPUT_RECORD — Populates staging or target structures from the interface source rows.
• REPORT_ERROR — A generalized utility that iterates the FND message stack and writes formatted error text to the concurrent manager log via the FND_MSG_PUB and FND_FILE APIs.
• UPDATE_INTERFACE_STATUS — Maintains the status flag on interface records (e.g., processed, error), governing eligibility for purge and reprocessing.
• GENERATE_RV — Produces the residual value records resulting from the validated interface input.
• GENERATE_RESIDUAL_VALUES — The higher-level generation routine that drives residual value creation across the processed set.

Supporting private helpers such as debug_message and write_to_log provide debug and logging capability controlled by a debug flag.

Tables Accessed

The package operates against OKL_ITM_CAT_RV_PRCS (Item Category Residual Value Process), accessed through APPS synonyms. This table holds the processing/staging data for residual value calculations tied to item categories and is read and updated as records flow through validation, load, generation, and status updates. The purge routine removes obsolete rows from the same interface processing table.

Usage Notes

OKL_RV_INTERFACE_PVT is typically invoked by a concurrent program or a public wrapper package rather than called directly, consistent with its PVT classification. The metadata records zero packages referencing it, indicating tight coupling limited to its own entry points or concurrent manager submission. Administrators use the associated concurrent program to import and process residual value data, relying on the log output for error diagnostics. Because purge and reprocessing depend on interface status flags, users should confirm record states before re-running the concurrent request to avoid duplicate residual value generation.