ORA-01403 and FRM-40735 error occur while opening any forms (Doc ID 1358117.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 10-April-2013***

Symptoms

On R12, When trying to open any forms, the following error message occurs:

ERROR
------
ORA-01403: no data found
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502.


The dabase alert log file shows the following error messages
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 12-SEP-2011 10:43:29
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.xxx)(PORT=yyy))
WARNING: inbound connection timed out (ORA-3136)
Mon Sep 12 10:43:29 2011
***********************************************************************

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