Package WSMPLBMI Having Performance Issue After Database Upgrade To 12c
(Doc ID 2464677.1)
Last updated on AUGUST 20, 2019
Applies to:Oracle Shop Floor Management - Version 18.104.22.168 and later
Oracle Work in Process - Version 22.214.171.124 and later
Information in this document applies to any platform.
After upgrading database from 126.96.36.199 to 188.8.131.52 , 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