Home » Developer & Programmer » Reports & Discoverer » Error Code ORA-00918 Column ambiguosly defined (Discoverer Administrator 10g)
Error Code ORA-00918 Column ambiguosly defined [message #590450] Thu, 18 July 2013 05:46 Go to next message
imtiazg
Messages: 3
Registered: July 2013
Junior Member
Hi...I have written this code below in Disco Admin 10g but get Ora-00918 column ambiguosly defined error even though I have used alias in the table name. Can anyone please tell me what the error is for? Thanks

Select

porh.segment1
,Porh.creation_date
,Porh.last_update_date
,porh.closed_code
,porh.authorization_status
,porh.description
,porh.note_to_authorizer
,porh.cancel_flag
,porh.enabled_flag
,porl.line_num
,porl.item_description
,porl.quantity
,porl.unit_price
,porl.suggested_vendor_name
,mtl.segment3
,mtl.description
,glcc.segment1
,glcc.segment2
,glcc.segment3
,glcc.segment4
,glcc.segment5

From
apps.po_requisition_headers_v porh
,apps.po_requisition_lines_v porl
,apps.Mtl_categories_v mtl
,apps.Gl_code_combinations_v glcc

Where
Porh.requisition_header_id=porl.requisition_header_id
and Porl.category_id=mtl.category_id
and Porl.charge_account_id=glcc.code_combination_id
Re: Error Code ORA-00918 Column ambiguosly defined [message #590452 is a reply to message #590450] Thu, 18 July 2013 05:50 Go to previous messageGo to next message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As all columns have aliases, this code most probably didn't raise that error. Is there any other code in that ... huh, Disco Admin 10g? (Obviously, I don't use Discoverer).
Re: Error Code ORA-00918 Column ambiguosly defined [message #590455 is a reply to message #590452] Thu, 18 July 2013 05:55 Go to previous messageGo to next message
imtiazg
Messages: 3
Registered: July 2013
Junior Member
Hi...this is the only code I am using.
The code has been written in OracleBI Dicoverer Administrator.
Re: Error Code ORA-00918 Column ambiguosly defined [message #590459 is a reply to message #590455] Thu, 18 July 2013 06:02 Go to previous messageGo to next message
imtiazg
Messages: 3
Registered: July 2013
Junior Member
Hi...I managed to sort it. I added the text "Desc" after mtl.description and the code was accepted! Thanks
Re: Error Code ORA-00918 Column ambiguosly defined [message #590540 is a reply to message #590459] Fri, 19 July 2013 03:11 Go to previous message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Aha, it means that Discoverer objects because PORH.DESCRIPTION and MTL.DESCRIPTION are ambiguous ... That's different from Reports Builder (which, in such a case, automatically renames the second one to "DESCRIPTION1").

Thank you for letting us know!
Previous Topic: Can I auto export reports
Next Topic: frm-41214 : Unable to run report
Goto Forum:
  


Current Time: Fri Oct 31 13:10:43 CDT 2014

Total time taken to generate the page: 0.11809 seconds