Recipient Approving AGIS Transactions Ends With Error ORA-01403 ORA-04061

(Doc ID 1317167.1)

Last updated on SEPTEMBER 16, 2016

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 showed that in the error status field we had
Error Message ORA-04061: existing state of has been invalidated ORA-04061: existing state of has been invalidated

Changes

A patch was applied

Cause

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