My Oracle Support Banner

Error JBO-27122 Occur When Trying to Search EAM Asset Numbers in Self Service (Doc ID 2529113.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

When attempting to query asset numbers from Maintenance Super User Responsibility, the following error occurs.
The issue started after applying patch 19916280.

ERROR

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT *
FROM (SELECT
distinct
msi.concatenated_segments, .....

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance Super User.
2. Click on Assets tab.
3. Query asset.
4. Receive the above error.

WORKAROUND

Query assets using Forms (CORE).


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.