RCVOLTM Receiving Transaction Manager Errors With "APP-FND-00204: Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request XXXXX.TM-TIMEOUT." (Doc ID 2977455.1)

Last updated on JULY 02, 2024

Applies to:

Symptoms

Possible symptoms of the issue.

1) When attempting to run the Receiving Transaction Manager process, the following error occurs.

APP-FND-00204: Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request XXXXX.TM-TIMEOUT.

The time consuming SQL statement per the trace file is,

SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */
RCV_TXN.TRANSACTION_ID ,RCV_TXN.PO_DISTRIBUTION_ID ,
RCVSUB.ACCOUNTING_EVENT_ID
FROM
RCV_TRANSACTIONS RCV_TXN ,PO_DISTRIBUTIONS PODIST ,RCV_RECEIVING_SUB_LEDGER

This SQL statement exists in the file, PAPOUTLB.pls/

2) In the Receipt form (RCVRCER), attempted to perform a save on a receipt that is associated with a 4-way match purchase order. The Receiving Transaction Manager (RCVOLTM) process is experiencing performance issues and errors in the Receipt form.

APP-FND-00204: Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request XXXXXXXX.TM-TIMEOUT.

For a 3-way match purchase order, the receipt is created with no errors.

Problem statement per the tkprof trace:

SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */
RCV_TXN.TRANSACTION_ID ,RCV_TXN.PO_DISTRIBUTION_ID ,
RCVSUB.ACCOUNTING_EVENT_ID
FROM
RCV_TRANSACTIONS RCV_TXN ,PO_DISTRIBUTIONS PODIST ,RCV_RECEIVING_SUB_LEDGER
..........
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.07 0.27 0 0 5 0
Fetch 1 164.54 13480.93 5272383 5285143 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 164.62 13481.21 5272383 5285143 5 0

This SQL exists in file $PA_TOP/patch/115/sql/PAPOUTLB.pls.

================

Replication Steps:

1. Navigate to > Inventory responsibility > Transactions > Receiving > Receipts.
2. In the Find Expected Receipts, enter the Purchase Order Number. Click the Find button.
3. In the Receipt Header screen, choose New Receipt.
4. In the Receipts screen, choose the records to include in the receipt. Save record.
5. The Receiving Transaction Manager should be kicked off, but receive the error message.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.