(SM) Support Tip: Resolving RTE E Error: SQL code=918 message=ORA-00918: column ambiguously defined
The following error messages are seen when performing either of these two scenarios (there could be other scenarios in addition to this. Please review the error experienced)
1. Navigate to Tailoring > Process Designer > Workflows
2. Selecting CI Type "Computer" and hitting the Search button.
Onscreen error: (display,fdisp.1)- SQL code=918 message=ORA-00918: column ambiguously defined (display,fdisp.1)
sm.log error: RTE E Error: SQL code=918 message=ORA-00918: column ambiguously defined
This is a known problem and is resolved with Service Manager Release 9.51 Hot Fix 3. Please contact HPE Technical Support to obtain this server Hotfix.