mWorkOrder 3.9 lags push data back to IEE after Oracle 19c upgrade from Oracle 12c.
We are experiencing more lags in data writing back to IEE from mWorkOrder 3.9.
We are using APPS9 UD17 and prior to the Oracle upgrade didn’t have this consistent lag.
Our biggest obstacle is when a survey answer includes a photo and the photo often gets stuck and we end up with errors or no pictures.
During the Oracle upgrade permissions were changed remvoing sys and system access from appowner. I was under the impression the mobile app uses IFSSYS for all mobile transactions, however maybe this isn’t the case.
We were planning on deploying mworkorder 3.14, however am afraid I may introduce yet other issues moving to the newer mworkorder version prior to resolving the issues at hand.
Where can I begin looking to determine where this lag may be occurring?
Is there a set of permission standards deployed with APPS9 noting which IFS, SYS, SYSTEM, APPOWNER accounts should have which access
Any particular log files I can review?
I appreciate any insight to others experiencing issues such as this and how they were resolved.
Thank you in advance.