My Oracle Support Banner

Error FRM-92101 When Doing A Blind Query On Incident Address LOV (Doc ID 1448362.1)

Last updated on JANUARY 03, 2023

Applies to:

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

Symptoms


On : 12.1.3 version, Service Request Form

In the Service Request form header, when attempting to change the incident address by searching the incident address field using a blind query (%), the following error occurs.

ERROR
-----------------------

There is an FRM-92101 and the form session is closed.
  
The Details of the FRM-92101 error indicates:
  
  Java Exception:
  oracle.forms.net.ConnectionException: Forms session <7> aborted: unable to
  communicate with runtime process.

Sometimes the LOV shows the following errors:

ORA-01403: no data found

FRM-40502: ORACLE error: unable to read list of values.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Service Request form
2. Query a customer
3. In the Incident Address region open the LOV and perform a query using %
4. Reported error occurs

Cause

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
Symptoms
Cause
Solution
References


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