Package WSMPLBMI Having Performance Issue After Database Upgrade To 12c
(Doc ID 2464677.1)
Last updated on FEBRUARY 24, 2021
Applies to:Oracle Shop Floor Management - Version 22.214.171.124 and later
Oracle Work in Process - Version 126.96.36.199 and later
Information in this document applies to any platform.
After upgrading database from 188.8.131.52 to 184.108.40.206 , there was severe performance issue on package- ""WSMPLBMI.movetransaction"".
This is also seen in the WIP product on package wipmovvb.pls.
On 11g database the same package is completing in 2-3 mins where as on upgraded environment it took 45 mins to complete.
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