R11i/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 JULY 18, 2016

Applies to:

Oracle Assets - Version 11.5.10.2 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.


Symptoms

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

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

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