R11i and R12 Asset Workbench (FAXASSET) Form Errors With: "ORA-00918: column ambiguously defined" and/or "FRM-40505: ORACLE error: unable to perform query"

(Doc ID 736802.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Assets - Version to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.
FAXASSET - Assets Workbench

This knowledge document is a replacement for 753405.1 which has been deleted.


When clicking "Find" on Assets workbench and using criteria "Asset Book" and "Employee Name" to query assets, the following error occurs:

ORA-00918: column ambiguously defined
FRM-40505: ORACLE error: unable to perform query.


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