ROI: Performance Issue With Receiving Transaction Processor

(Doc ID 393580.1)

Last updated on OCTOBER 05, 2017

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***


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,
(parent_interface_txn_id=:b2 and parent_transaction_id is null )


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