Performance Slow Transacting 1000s of Serials With APPS.INV_TRX_UTIL_PUB.insert_ser_trx
(Doc ID 2440699.1)
Last updated on AUGUST 28, 2018
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Making calls to the seeded Oracle API APPS.INV_TRX_UTIL_PUB.insert_ser_trx performance is very slow when trying to process a lot of serial numbers (thousands at a time).
WHAT IS WORKING
Works well in the Oracle forms.
1.Call the APPS.INV_TRX_UTIL_PUB.insert_ser_trx API from the customer program.
2. Program taking more time to complete.
See the following Query is taking more time: ( This seems to be coming from INVTRXUB.pls.)
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