Performance Issue in Receiving Transaction Processor while using ROI to import Receipts with large Serial Quantities
(Doc ID 1205423.1)
Last updated on AUGUST 22, 2023
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.
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
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 |
| Cause |
| Solution |
| References |