My Oracle Support Banner

Receive Error Message And Get Logged Out of Oracle After Opening Collections And Performing Search (Doc ID 456210.1)

Last updated on JANUARY 28, 2022

Applies to:

Oracle Advanced Collections - Version 12 and later
Information in this document applies to any platform.


After opening Collections Agent form and performing search, receive error message and get logged out of Oracle.

Error received:
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001.
your log on session has become invalid . exiting oracle applications

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.
APP-JTF-210604: Program error: Please inform your system administrator or support representative that:
JTF_GRID package reports error:

DEVELOPER_ERROR:jtf_grid.reset reports that:
has not been initialized. A grid must be specified using BLOCK.ITEM_NAME in UPPERCASE.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

Collectors Agent Responsibility
Opens form
Select Torch from Tool Menu to enter Search details
Enter Search Details and select search button - Operating Unit = OU: ACM
Results return
Then get the errors


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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