Search Results worker_process




Overview
Explore in AI Chat

Overview

ARHLSG2W is a concurrent program owned by the Oracle Receivables (AR) product family and is presented to end users under the name TCA Import - Data Load Stage 2. Its documented description is "Data Load Stage 2," reflecting its position as the second of the sequential staging phases within the TCA (Trading Community Architecture) bulk import flow. The program operates on records that have already been staged and validated by the preceding Data Load Stage 1 process, moving them further along the import lifecycle. The user search term worker_process corresponds directly to the execution file name documented for this program: HZ_IMP_LOAD_STAGE2.WORKER_PROCESS.

Execution Details

The documented concurrent program metadata for ETRM 12.2.2 is as follows:

  • User-facing name: TCA Import - Data Load Stage 2
  • Product: AR - Receivables
  • Enabled: Yes
  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: ARHLSG2W
  • Execution Filename: HZ_IMP_LOAD_STAGE2.WORKER_PROCESS
  • Subroutine Name: (none documented)

Because the execution method is PL/SQL Stored Procedure, the program invokes the packaged procedure HZ_IMP_LOAD_STAGE2.WORKER_PROCESS directly within the database tier. The absence of a subroutine name and the use of the Standard argument method indicate that submission values are passed positionally to the worker procedure, rather than through a token-based or custom argument scheme.

How to Run

Users typically submit ARHLSG2W through the Standard Request Submission (SRS) window in Receivables, navigating to View > Requests > Submit a New Request and selecting "TCA Import - Data Load Stage 2." As a worker process, it is generally launched by the parent TCA import orchestrator or by an administrator coordinating the staged import rather than being invoked in isolation by casual users. Because the argument method is Standard, the parameter list is defined at the concurrent program level; the precise parameters are not enumerated in the documented metadata provided, so administrators should review the concurrent program's parameter definition in the EBS Concurrent Programs form or the applicable implementation guide before submission. Submissions should ordinarily follow the completion of the corresponding Data Load Stage 1 request, since Stage 2 depends on the records staged by that predecessor step.

Related Objects

ARHLSG2W belongs to the TCA bulk import infrastructure and is closely associated with the following:

  • HZ_IMP_LOAD_STAGE2 — the PL/SQL package containing the WORKER_PROCESS entry point.
  • Data Load Stage 1 — the preceding program in the staged import sequence, which must complete before Stage 2 is run.
  • TCA interface and staging tables — the HZ_IMP_* family of tables that hold import records between phases.
  • TCA import APIs — the HZ_IMP_* and related TCA packages that ultimately create parties, locations, and contacts from the loaded data.
  • Sibling concurrent programs — the other TCA Import concurrent programs invoked alongside this one during a full import cycle.

Administrators troubleshooting the request should confirm the status of the predecessor Stage 1 request and inspect the concurrent request log, since output from the WORKER_PROCESS procedure is written to the log file rather than to a formatted report.

  • Concurrent Program: ARHLSG2W 12.1.1

    execution_filename: HZ_IMP_LOAD_STAGE2.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG2W ,  description: Data Load Stage 2 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLSG3W 12.1.1

    execution_filename: HZ_IMP_LOAD_STAGE3.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG3W ,  description: Data Load Stage 3 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLSG3W 12.2.2

    execution_filename: HZ_IMP_LOAD_STAGE3.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG3W ,  description: Data Load Stage 3 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLSG1W 12.2.2

    execution_filename: HZ_IMP_LOAD_STAGE1.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG1W ,  description: Data Load Stage 1 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLSG1W 12.1.1

    execution_filename: HZ_IMP_LOAD_STAGE1.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG1W ,  description: Data Load Stage 1 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLSG2W 12.2.2

    execution_filename: HZ_IMP_LOAD_STAGE2.WORKER_PROCESS ,  product: AR - Receivables ,  user_name: ARHLSG2W ,  description: Data Load Stage 2 ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure ,