ROI: Performance Issue With Receiving Transaction Processor (Doc ID 393580.1)

Last updated on AUGUST 19, 2015

Applies to:

Oracle Inventory Management - Version: 11.5.10 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor

***Checked for relevance on 17-JAN-2012***

Symptoms

Performance issue in Receiving Transaction Processor when processing large batches of receipts through Receiving Open Interface (ROI)

Trace file shows costly sql as follows:

update rcv_transactions_interface set parent_transaction_id=:b0,
shipment_line_id=:b1
where
(parent_interface_txn_id=:b2 and parent_transaction_id is null )


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms