Service Contracts Authoring and Copy Forms Crash Intermittently with FRM-40735 Error (Doc ID 796353.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 12.0.4 and later
Information in this document applies to any platform.
FORM:OKSAUDET.FMB - Service Contracts Authoring
Form:OKCADCPY.FMB - Copy Component Selection
***Checked for relevance on 04-Jun-2014***

Symptoms

Intermittently the Service Contract Authoring form crashes with this sequence of error messages:

FRM-40735 : On-ERROR trigger raised unhandled exception ORA-01001
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 excuted fromthe
file &ERRFILE.
Your logon session has become invalid. Exiting Oracle Applications.

The database Alert log shows:

Errors in file /u30/mate/db/tech_st/10.2.0/admin/mate_major/udump/mate_ora_12169.trc:
ORA-07445: exception encountered: core dump [lxhh2ci()] [SIGSEGV] [Address not mapped to
object]
[0x30000005C] [] []

The database trace file shows:

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [lxhh2ci()] [SIGBUS] [Invalid
address alignment] [0x53545F44455441A5] [] []
Current SQL statement for this session:
SELECT ID1 , NAME LOCATION , DESCRIPTION DESCRIPTION , PARTY_ID FROM
OKX_CUST_SITE_USES_V WHERE ID1 = :b1 AND SITE_USE_CODE = :b2

----- Call Stack Trace -----
ksedmp ssexhd sighndlr call_user_handler sigacthandler lxhh2ci lxgratio
kgmtncch kgmtconv kgmgaicn kgmpia_process_in_args kgmexwi rgs kgmexec evapls
evaopn2 kpofcr qertbFetchByRowID qerjotFetch opifch2 kpoal8 opiodr ttcpip
opitsk opiino opiodr opidrv sou2o opimai_real main start

Similar errors may be found on the Copy Contracts form the following error is received a number of times, after which the forms session disconnects:

"FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001"

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