ORA-00918: column ambiguously defined after upgrade to 10.2.0.5 PSU 2
We have upgraded our prod database from 10.2.0.4.0 to 10.2.0.5.2 last week.
Config:
2 node RAC
HPUX IA
Current version: 10.2.0.5.2
After upgrade, I found that an application job which was running fine earlier started reporting below error after upgrade. Same query is running fine in another environment where the version is 10.2.0.4. Could not find any known issues for our version.
Any help is appreciated.
ORA-00918: column ambiguously defined
select account_num, random_hash, bs.event_seq, case when event_archive_status is null or (archive_dat <= to_date('20110718 162622', 'yyyymmdd hh24miss')
and archive_dat > to_date('20110605 155039', 'yyyymmdd hh24miss')) then 0 else 1 end archived_flag, sum(costedevent_rec_count) from account a join bills