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