Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Getting ORA-918 column ambiguously defined error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting ORA-918 column ambiguously defined error

Received Response
33
Views
1
Comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!