My Oracle Support Banner

Recipient Approving AGIS Transactions Ends With Error ORA-01403 ORA-04061 (Doc ID 1317167.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Financials Common Modules - Version 12.0.0 and later
Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When selecting Apply for an Inbound transaction in AGIS , the following error occurs.

ERROR
-----------------------
an Error Page comes up and we cannot continue. The main details in the error page are:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1848
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Initiator completes an outbound AGIS transaction and applies.
2. Recipient selects the inbound transaction, adds the accounting details and amounts, and clicks Apply
3. Login as User SYSADMIN
b. Responsibility > Workflow Administrator Web Applications > Administrator Workflow > Status Monitor
c. Search for the workflow with the following values -
Internal Name: FUN%
Item Key: <Batch Id%>
Note: Make sure that Workflow Owned By is All Employees and Users / Your User (otherwise you will not be able to view any workflows).

This shown that in the error status field there is: 
Error Message ORA-04061: existing state of has been invalidated ORA-04061: existing state of has been invalidated

Changes

Patching

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!

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