Cancel PO Shipment With Error APP-FND-01564: ORACLE error 3114 in audfrm (Doc ID 2049931.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Purchase Order

When attempting to cancel purchase order shipment,
the following error occurs.

ERROR
-----------------------
APP-FND-01564: ORACLE error 3114 in audfrm
Cause: audfrm failed due to ORA-03114: not connected to ORACLE.
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-03114.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing > Purchase Order > Purchase Order Summary > query purchase order navigate to shipment level > tools > controls > cancel PO shipment, system shows error message:
APP-FND-01564: ORACLE error 3114 in audfrm
Cause: audfrm failed due to ORA-03114: not connected to ORACLE.
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
2. Click OK, system shows:
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-03114.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cancel purchase order shipment successfully, this will make unuseful purchase order shipment continue to perform following receiving transactions which is not required.

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