Hello,
This week we went live with IFS Cloud (24R2) and migrated from IFSAPPS9.
We experience a lot of issues with mobile users that want to use the Service Engineer App.The initialization process for these users runs into this error:
Initialize entity data failed: STMTPREPFAIL:Can not prepare statement ( select distinct F.filter_id, F.granted_filter_type_db from ifsapp.activity_grant_filter F, ifsapp.activity_grant A, ifsapp.fnd_user_role_runtime R where R.identity = ? and R.role = A.role and A.activity_name = ? and A.role = F.permission_set_id(+) and A.activity_name = F.activity_name(+)). Exception is: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK - IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK
Looks like there is a data issue, but I'm not able to track down where it comes from and I have no clue what we can do to solve this.
Is there anyone who experienced this before or might have a clue how we can fix this?
Thanks in advance! Appreciate your help.
