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.
When attempting to query asset numbers from Maintenance Super User Responsibility, the following error occurs.
The issue started after applying patch 19916280.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT *
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.
Query assets using Forms (CORE).
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