My Oracle Support Banner

AGIS Batches Got Stuck (Status: SENT), Unable to Approve, Reject or Change Accounting; Errors Relate to FUN_RECIPIENT_WF or WF_USER_ROLE (Doc ID 1996883.1)

Last updated on JUNE 21, 2023

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)

Symptoms

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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 intermittently.

ERROR
Error Page
Exception Details.
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

FND Log

generated while the issue was reproduced shows errors related to WF_USER_ROLE or WF_ROLE_HIERARCHY; sample of FND Log:

  

Changes

None

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.