Getting ORA-918 column ambiguously defined error
Summary:
We have a script for creating product related views which is working fine on lower environment but while setting up production environment we are getting ORA-918 column ambiguously defined error.
Content (required):
Getting ORA-918 column ambiguously defined error even when column has correct table associated.
Version (include the version you are using, if applicable):
Oracle 19.17.0 on cloud
Code Snippet (add any code snippets that support your topic, if applicable):
Getting error at following join condition
LEFT OUTER JOIN S_SBJTMP_VER_LS
ON S_TMPL_PLANITEM.PAR_TMPL_ID = S_SBJTMP_VER_LS.ROW_ID
LEFT OUTER JOIN S_SBJTMP_VER_LS
Tagged:
0