My Oracle Support Banner

Performance Issue with the 'Receiving Transaction Processor' (RTP) while Saving Receipts after Upgrade to R12.2.11. Users sometime Receive a TM-TIMEOUT Error. (Doc ID 2873574.1)

Last updated on JULY 05, 2023

Applies to:

Oracle Project Costing - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

Users are experiencing performance issues with the job "Receiving Transaction Processor (RTP)".  Users receive a TM-TIMEOUT error when the 'RCV: Processing Mode' is 'Online' and when the 'RCV: Processing Mode' is 'Immediate' the process takes more than hour to complete

The following query appears to be the culprit:

UPDATE RCV_RECEIVING_SUB_LEDGER RCV_SUB SET RCV_SUB.PA_ADDITION_FLAG = NULL
WHERE
 RCV_SUB.PA_ADDITION_FLAG ='N' AND EXISTS ( SELECT 'X' FROM RCV_TRANSACTIONS
  RCV_TXN WHERE RCV_TXN.TRANSACTION_ID = RCV_SUB.RCV_TRANSACTION_ID AND
  ((RCV_TXN.DESTINATION_TYPE_CODE IN ('INVENTORY','MULTIPLE','SHOP FLOOR') OR

  (RCV_TXN.DESTINATION_TYPE_CODE = 'RECEIVING' AND (RCV_TXN.TRANSACTION_TYPE
  NOT IN ('RETURN TO VENDOR','RETURN TO RECEIVING') ) ) ) OR (EXISTS (SELECT
  PO_DISTRIBUTION_ID FROM PO_DISTRIBUTIONS PO_DIST WHERE
  PO_DIST.PO_DISTRIBUTION_ID = RCV_TXN.PO_DISTRIBUTION_ID AND
  ((RCV_TXN.DESTINATION_TYPE_CODE = 'EXPENSE' AND PO_DIST.PROJECT_ID IS NULL)

  OR (RCV_TXN.DESTINATION_TYPE_CODE = 'EXPENSE' AND NVL(PO_DIST.PROJECT_ID,0)

  > 0 AND PO_DIST.ACCRUE_ON_RECEIPT_FLAG = 'N') OR
  (RCV_TXN.DESTINATION_TYPE_CODE = 'RECEIVING' AND PO_DIST.PROJECT_ID IS
NULL)
   OR (RCV_TXN.DESTINATION_TYPE_CODE = 'RECEIVING' AND PO_DIST.PROJECT_ID IS
  NOT NULL AND PO_DIST.ACCRUE_ON_RECEIPT_FLAG = 'N') ) ) ) OR (
  PA_NL_INSTALLED.IS_NL_INSTALLED = 'Y' AND EXISTS (SELECT 'X' FROM
  MTL_SYSTEM_ITEMS SI, PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL PO_DIST1 WHERE
  PO_DIST1.PO_LINE_ID = POL.PO_LINE_ID AND PO_DIST1.PO_DISTRIBUTION_ID =
  RCV_TXN.PO_DISTRIBUTION_ID AND SI.INVENTORY_ITEM_ID = POL.ITEM_ID AND
  PO_DIST1.PROJECT_ID IS NOT NULL AND SI.COMMS_NL_TRACKABLE_FLAG = 'Y') ) OR
  ( RCV_SUB.ACTUAL_FLAG <> 'A' ) ) )




Steps to Reproduce:

1. Inventory Responsibility
2. Transactions | Receiving | Receipts
3. Try to receive the receipt and the performance issue is experienced

Changes

Applied a patch that included an update to the package PA_PO_INTEGRATION_UTILS, file PAPOUTLB.pls  version 120.28.12020000.8 including upgrading to 12.2.11.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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