Search Results concurrent




Overview

The concurrent program ECX_STOP_QUE (user-facing name XML Gateway Stop Queues) belongs to the ECX – XML Gateway product family within Oracle E-Business Suite. Its documented purpose is to stop the XML Gateway queues that are used to process inbound and outbound business messages exchanged between EBS and external trading partners. In the XML Gateway architecture, background queues decouple message ingestion from message processing, allowing the Outbound Engine and related listeners to operate asynchronously. The ECX_STOP_QUE program provides an administrative mechanism to halt that queue processing activity.

According to the ETRM metadata for release 12.2.2, the program is shipped in a disabled state (Enabled: No). This is a significant operational characteristic: the program exists in the concurrent program definition, but it is not intended for routine production use without explicit administrative intent. It is typically leveraged during maintenance windows, diagnostics, or controlled shutdown of XML Gateway traffic.

Execution Details

The documented execution attributes are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: ECXSTOPQUE
  • Execution File: ECX_OUT_ENGINE.STOP_QUEUE
  • Executable User Name: ECXSTOPQUE (description: XML Gateway Stop Queues)
  • Subroutine Name: (not populated in the metadata)

The execution filename identifies the PL/SQL package and procedure invoked at runtime: ECX_OUT_ENGINE.STOP_QUEUE. This package forms part of the XML Gateway outbound engine infrastructure, confirming that the program acts directly on the queue processing components rather than through an intermediate interface.

How to Run

Because the definition is a standard concurrent program, submission follows the normal Standard Request Submission (SRS) path: navigate to Requests > Run (or the equivalent responsibility-specific submission window), query the program by its user name XML Gateway Stop Queues, and submit. The metadata specifies Argument Method: Standard, indicating parameters are defined conventionally; however, no specific parameter values are documented in the ETRM excerpt.

Administrators should note the disabled status. In practice, re-enabling the program (or running it via an equivalent direct invocation) is a deliberate action associated with stopping queue listeners. It should be coordinated with XML Gateway monitoring, since halting queues will suspend message processing until the corresponding start program is executed to resume service.

Related Objects

ECX_STOP_QUE operates alongside other XML Gateway components rather than in isolation. Commonly associated objects include:

  • ECX_OUT_ENGINE – the PL/SQL package containing the STOP_QUEUE procedure executed by this program.
  • XML Gateway inbound/outbound queues and listeners – the runtime queue structures whose processing is halted.
  • Complementary start/stop administrative concurrent programs – used to restart queue processing after maintenance.
  • ECX interface and transaction tables – the message and transaction repositories that feed the queues, such as those underlying the XML Gateway transactions and message definitions.
  • – used to define transactions, parties, and queue behavior within the ECX module.

Together, these objects form the operational envelope in which ECX_STOP_QUE performs its specialized administrative role.

  • Concurrent Program: ECX_STOP_QUE 12.1.1

    execution_filename: ECX_OUT_ENGINE.STOP_QUEUE ,  product: ECX - XML Gatewayuser_name: ECXSTOPQUE ,  description: XML Gateway Stop Queues ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXOENG 12.1.1

    execution_filename: ecx_out_engine.ecx_out_execute ,  product: ECX - XML Gatewayuser_name: ECXOENG ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXIENG 12.2.2

    execution_filename: ecx_in_engine.ecx_in_execute ,  product: ECX - XML Gatewayuser_name: ECXIENG ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXILSTN 12.1.1

    execution_filename: ecx_listener.ecx_listener_execute ,  product: ECX - XML Gatewayuser_name: ECXILSTN ,  description: XML Gateway Inbound Listener ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXILSTN 12.2.2

    execution_filename: ecx_listener.ecx_listener_execute ,  product: ECX - XML Gatewayuser_name: ECXILSTN ,  description: XML Gateway Inbound Listener ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXIENG 12.1.1

    execution_filename: ecx_in_engine.ecx_in_execute ,  product: ECX - XML Gatewayuser_name: ECXIENG ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXSEND 12.1.1

    execution_filename: ecx_document.send_cm ,  product: ECX - XML Gatewayuser_name: ECXSEND ,  description: Triggering Process for Outbound Engine ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXSEND 12.2.2

    execution_filename: ecx_document.send_cm ,  product: ECX - XML Gatewayuser_name: ECXSEND ,  description: Triggering Process for Outbound Engine ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECX_STOP_QUE 12.2.2

    execution_filename: ECX_OUT_ENGINE.STOP_QUEUE ,  product: ECX - XML Gatewayuser_name: ECXSTOPQUE ,  description: XML Gateway Stop Queues ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ECXOENG 12.2.2

    execution_filename: ecx_out_engine.ecx_out_execute ,  product: ECX - XML Gatewayuser_name: ECXOENG ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure ,