Search Results ad_parallel_workers_u1

Overview

APPLSYS.AD_PARALLEL_WORKERS is an Oracle E-Business Suite Applications DBA (AD) table that tracks individual worker assignments within a parallel update operation. The object is owned by the APPLSYS schema, carries the FND Design Data reference AD.AD_PARALLEL_WORKERS, and is stored in the APPS_TS_INTERFACE tablespace with a status of VALID. Physically it is defined with eleven columns, PCT Free of 10, and a single unique index, AD_PARALLEL_WORKERS_U1.

Functionally, the table records how a large, set-based update—executed by an AD utility such as a parallel worker job against a results history—has been decomposed into discrete units of work, and which worker process claimed each unit. Each row ties a worker identifier to an update identifier and describes the range of rows that worker is responsible for.

Under a heuristic Data Vault classification derived from the foreign-key structure, AD_PARALLEL_WORKERS is best modeled as a satellite. It holds descriptive, transient attributes about the execution of a specific update (row ranges, row IDs, and processed row counts) that qualify a parent business key rather than introducing new business entities. It is documented as a standalone object because it references no other database object, while it is itself referenced by APPLSYS.AD_PARALLEL_WORKERS#.

Key Information Stored

The most meaningful columns in this table are those that identify the worker and the update, and those that delineate the work assigned to that worker.

• UPDATE_ID — identifier of the parallel update that this worker participates in; the leading column of the unique business key.
• WORKER_ID — identifier for the worker; the second column of the unique index and, together with UPDATE_ID, the documented business-key candidate AD_PARALLEL_WORKERS_U1.
• START_UNIT_ID and END_UNIT_ID — the first and last unit identifiers processed by the worker, defining the unit span of the assignment.
• START_ROWID and END_ROWID — ROWID values marking the first and last physical row within the assigned unit range.
• START_ID and END_ID — numeric identifiers for the first and last row in the unit, complementing the ROWID bounds.
• ROWS_PROCESSED — the number of rows the worker processed for the current update, the primary measure for progress and throughput reporting.
• SESSION_ID and SESSION_SERIAL_NO — session identifiers documented as “not used currently,” retained for compatibility.

The table does not expose a single-column surrogate primary key in the documented metadata; AD_PARALLEL_WORKERS_U1 (UPDATE_ID, WORKER_ID) is the unique business key. Foreign-key relationship data records UPDATE_ID referencing APPLSYS.QA_RESULTS_UPDATE_HISTORY.

Common Use Cases and Queries

Typical scenarios include monitoring the progress of a running parallel update, diagnosing worker skew, and auditing which worker claimed which unit range after an update completes.

A representative query joins workers to their parent update history and aggregates processed rows per update:

• SELECT w.UPDATE_ID, COUNT(*) workers, SUM(w.ROWS_PROCESSED) rows_done FROM APPLSYS.AD_PARALLEL_WORKERS w GROUP BY w.UPDATE_ID;
• SELECT w.WORKER_ID, w.START_UNIT_ID, w.END_UNIT_ID, w.ROWS_PROCESSED FROM APPLSYS.AD_PARALLEL_WORKERS w WHERE w.UPDATE_ID = :update_id ORDER BY w.WORKER_ID;
• Detect uneven distribution: SELECT WORKER_ID, ROWS_PROCESSED FROM APPLSYS.AD_PARALLEL_WORKERS WHERE UPDATE_ID = :update_id ORDER BY ROWS_PROCESSED DESC;

The unique index also supports efficient point lookups by UPDATE_ID and WORKER_ID, and ROWID boundaries allow reconciliation back to the underlying table whose rows were processed.

Related Objects

The relationship data identifies the following links. These should be treated as the significant joins rather than an exhaustive inventory.

• APPLSYS.QA_RESULTS_UPDATE_HISTORY — parent update-history table referenced via AD_PARALLEL_WORKERS.UPDATE_ID; the update-level context for each worker row.
• APPLSYS.AD_PARALLEL_WORKERS# — the referenced-by dependency, an internal backing object associated with this table.
• AD.AD_PARALLEL_WORKERS — the FND Design Data definition that governs creation and maintenance of the object.
• AD_PARALLEL_WORKERS_U1 — the unique index (UPDATE_ID, WORKER_ID) in APPS_TS_INTERFACE that enforces one row per worker per update.

Queries against this table are most valuable when combined with QA_RESULTS_UPDATE_HISTORY, which supplies the update-level status and timing information needed to interpret worker progress.