AGIS Batches Got Stuck (Status: SENT), Unable to Approve, Reject or Change Accounting; Errors Relate to FUN_RECIPIENT_WF or WF_USER_ROLE
Last updated on MARCH 12, 2018
Applies to:Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
Applies to: Advanced Global Intercompany System (AGIS)
Through normal business flow, many AGIS batches got stuck having status SENT, they may show this Error below. The users are unable to Approve, Reject or Change Initiator Accounting.
The issue occurs intermitently.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1906
ORA-06512: at line 1
generated while the issue was reproduced shows errors related to WF_USER_ROLE or WF_ROLE_HIERARCHY; sample of FND Log:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms