Search Results read_message

Overview

APPS.FND_CP_TMSRV_QUEUE is a wrapper and utility package belonging to the Oracle E-Business Suite Concurrent Processing subsystem. It provides an abstraction layer over Oracle Advanced Queuing (AQ) used by the FND Concurrent Manager infrastructure, specifically to enqueue and dequeue messages on the concurrent processing service queues. In EBS 12.1.1 and 12.2.2 the concurrent managers communicate with the internal manager and the standard manager through database-resident queue structures; FND_CP_TMSRV_QUEUE encapsulates the low-level AQ operations so that the calling concurrent processing programs (FNDCP_TMSRV) do not need to invoke DBMS_AQ directly. The _TMSRV component of the name indicates that the package is scoped to the concurrent manager service (timer service) message traffic. The package is documented as VALID in the APPS schema and is classified as OTHER, meaning it is an internal, non-public API that supports the Online Concurrent Processing architecture rather than a user-facing interface.

Key Procedures and Functions

Three procedures are documented for this package:

• INITIALIZE — Performs the setup work required before queue interaction occurs, such as establishing the queue handle, resolving queue table and queue names, and preparing the AQ enqueue or dequeue options. It is invoked once at the start of a queue session.
• WRITE_MESSAGE — Places a message onto the concurrent processing queue. This is used when a concurrent request or internal control message must be published for consumption by the service manager.
• READ_MESSAGE — Retrieves (dequeues) a message from the queue so that the concurrent manager service can process the pending instruction or request.

The package exposes no publicly documented functions beyond these three; no parameter lists are published in the ETRM metadata, and all interactions are treated as internal calls.

Tables Accessed

The package operates against the following documented objects:

• FND_CONCURRENT_QUEUES — the base EBS table that records the definition and status of concurrent processing queues. It is referenced through the APPS synonym and is used to resolve queue identity and configuration.
• DBMS_AQ — the Oracle server-supplied Advanced Queuing package. Although DBMS_AQ is a PL/SQL package rather than a table, it appears in the dependency list because FND_CP_TMSRV_QUEUE delegates enqueue and dequeue operations to it. The underlying AQ queue tables (internal SYS-owned objects) store the actual messages.

No other application tables are documented as being referenced by this package.

Usage Notes

This package is an internal component of the concurrent processing stack. It is not intended to be called from Oracle Forms, from user-written concurrent programs, or from custom integrations; the supported entry point for concurrent manager operations remains the standard concurrent request submission and manager administration screens. The ETRM dependency listing shows that FND_CP_TMSRV_QUEUE is referenced by FNDCP_TMSRV and by itself, and that it in turn references the SYS schema and the STANDARD package. Because it is classified as an OTHER API and is undocumented with respect to parameters, customers and partners should treat it as a black-box dependency: it should never be altered, and direct invocation is unsupported. Its relevance in both 12.1.1 and 12.2.2 arises during diagnosis of concurrent manager delivery failures, AQ queue backlogs, or when validating the integrity of the FND concurrent processing services after patching or cloning.