ERROR IN DEFINE ASSET ROUTES FORM AFTER RPC3 PATCHING

(Doc ID 2315801.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Asset Definition

When attempting to define Asset route, we are querying for the asset number,
the following error occurs.

ERROR
-----------------------
FRM-40735: PRE-QUERY trigger raised unhandled exception ORA-06502.


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

1. Login to application
2. Navigate to eam no planner asset resp
3. Assets - Asset routes
4. Define Asset routes screen opens
5. F11 and query for an asset, no results returned but error encountered at
    the bottom of the page. (FRM-40735: PRE-QUERY trigger raised unhandled exception ORA-06502.)



Changes

 

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