Performance Issue in Receiving Transaction Processor while using ROI to import Receipts with large Serial Quantities (Doc ID 1205423.1)

Last updated on JANUARY 11, 2016

Applies to:

Oracle Inventory Management - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor


Symptoms

Receiving Transaction Processor (RTP) encounters performance hurdles while importing receipts for large quantities using Receiving Open Interface (ROI) for Serial Controlled items.

 
Steps to Replicate the issue:
a. Populate interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI) and mtl_serial_numbers_interface (MSNI).
b. Run Receiving Transaction Processor.
c. Observe poor performance.

Details:
For 10,000 Serial Numbers, it takes 5 min 44 sec to complete.
For 1,00,000 Serial Numbers it takes around 54 min 3 sec to complete.
Same performance problem may be encountered in the following situation: doing Miscellaneous Receipt transactions for serial controlled items. (example: 700 thousands item serials take 30 minutes to be saved)

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