Hi All, I frequently manually run Generate Inventory Part Availability Exceptions throughout the day. It typically took about 2 minutes to run the process as a background job. Recently we patched Oracle and the process has increased to 8+ minutes. Has anyone run into this issue and is there a fix or setting that we’ve overlooked? Any suggestions would be appreciated.
Solved
Inventory Part Availability Exceptions - slow processing
+2Best answer by Yasas Kasthuriarachchi
Hi
Thank you for the information and sorry for the delay in response. I searched on Oracle Support and found that there are many after effects reported in shifting from 11.2.0.3 to 11.2.0.4 including performance drops and the list goes on.
Hence I would suggest if you have ORACLE ASFU agreement with IFS, you could raise a support case so support will analyze further on this issue. If not kindly refer Oracle Support for similar concerns that may have the perfect relevance to yours.
This topic has been closed for comments
+30Hi
Thank you for contacting, would you mind to elaborate what was the exact patch from Oracle that was used, it will be helpful if you could specify the update version etc. Also is the issue only with ‘Generate Inventory Part Availability’ ? have you observed any performance drop in other processes / jobs? It would be interesting to see which Oracle update caused this and how much it relates to IFS Application usage. Thank you !
+2Yasas_AK,
I am the IT Architect at LeaAnd72 location.
The patch was MES update to bring oracle 11.2.0.3 to 11.2.0.4 in order to get
oracle to TLS 1.2
And as she says, the time to process immediately went from 2 to 8 minutes.
I also noted an increase in one of our PMRP’s
I do not see any indexes that need to be rebuilt, and wondering what else we can review.
The Patch is the only “What’s changed” that we are aware of.
+30Hi
Thank you for the information and sorry for the delay in response. I searched on Oracle Support and found that there are many after effects reported in shifting from 11.2.0.3 to 11.2.0.4 including performance drops and the list goes on.
Hence I would suggest if you have ORACLE ASFU agreement with IFS, you could raise a support case so support will analyze further on this issue. If not kindly refer Oracle Support for similar concerns that may have the perfect relevance to yours.
+2Yasas_AK Thank you very much for the reply, I shall dig further!
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.