Cost Management - EBS (MOSC)

MOSC Banner

12.2.4 - Inventory Period Close Performance issue

edited Mar 1, 2016 4:06AM in Cost Management - EBS (MOSC) 2 commentsAnswered

Hi, We are upgrading from 12.0.6 to 12.2.4 and we are seeing a severe performance degradation, thereby by negatively impacting the period close process. We are working on an SR and we were provided a couple of workarounds and neither seem acceptable for our management. We have about 80 orgs and the process completes anywhere b/w 5-20 mins in 12.0.6 whereas the process runs forever and never completes in 12.2.4. The workarounds provided are

1. Delete the stats for a handful of tables. This improves performance. However, these table are used by a bunch of other process and we don't even have a definitive list.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center