Search Results load_workers

Overview

APPS.FA_XADJ_ITF_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Fixed Assets (FA) module. Its principal role is to process adjustment records staged in the Fixed Assets Adjustment Interface so that they can be validated and transferred into the FA_ADJUSTMENTS_T transaction table. The package embodies the interface-loading logic that moves externally supplied or mass-maintenance adjustment data through the standard FA adjustment pipeline.

The package header carries the version stamp $Header: faxadjis.pls 120.2.12010000.1 2008/07/28 13:24:19 appldev ship $, indicating it is a shipped Oracle file from the 12.1.1 code line that also persists in 12.2.2. In the ETRM metadata its API classification is listed as OTHER, and it exposes three documented program units: FAXADJI, WRITE_MESSAGE, and LOAD_WORKERS.

Key Procedures and Functions

• FAXADJI — The main worker procedure responsible for processing a single batch of adjustment interface rows. It accepts a batch identifier, an "old flag" indicator, parent request and request-count parameters used for concurrent worker coordination, and returns status and counter values including success and failure counts, worker job information, and a return status. It is the core routine that reads staged adjustment data, validates it, and applies it to the adjustments table.
• WRITE_MESSAGE — A utility procedure that records a message against a specific asset number. It is used to log informational or error text produced during interface processing so that the outcome for an individual asset can be surfaced to the user or concurrent request log.
• LOAD_WORKERS — The routine matched by the user's search term. It takes a batch identifier, a parent request identifier, and a total-requests count, and returns a return status. Its purpose is to determine and spawn the set of parallel worker jobs required to process the batch, enabling the adjustment interface load to be distributed across multiple concurrent workers.

Tables Accessed

• FA_ADJUSTMENTS_T — The adjustment transaction table into which validated interface records are inserted or updated.
• FA_ADDITIONS_B — The base asset table, consulted to resolve and validate the asset being adjusted.
• FA_BOOKS — The asset book table, used to confirm the book context and date-placed-in-service information relevant to the adjustment.
• FA_WORKER_JOBS — The worker job coordination table that supports the parallel processing model implemented by LOAD_WORKERS and FAXADJI.
• PLITBLM — A standard Oracle EBS PL/SQL table type used internally for in-memory collections during processing.

Usage Notes

This package is not intended to be called directly from end-user code. It is invoked automatically by the standard Fixed Assets adjustment interface concurrent programs that load and post adjustments. The presence of FA_WORKER_JOBS and the parent-request, total-requests, and request-number parameters on FAXADJI indicates that processing is designed to run as a set of parallel worker requests spawned by LOAD_WORKERS, with the parent request tracking overall completion.

Prior to execution, adjustment data must be staged in the FA adjustment interface tables. The package then validates each row, writes messages for failed records via WRITE_MESSAGE, and transfers successful rows to FA_ADJUSTMENTS_T. Because the package is documented under APPS and referenced by zero other packages, customization should be avoided; instead, populate the interface tables and run the standard adjustment interface concurrent program. All parameters are passed positionally, and several are declared as IN OUT NOCOPY or OUT NOCOPY for performance.