ORA-00960: ambiguous column naming in select list

[cognos1088]

Hi, all cognos gurus

I've encountered a weird problem when trying to move the content store from machine A to machine B. The problem is after I've exported the content store from machine A and imported it to c8 in machine B, some reports fail to be validated. The error is:

UDA-SQL-0107 A general exception has occurred during the operation "prepare".
ORA-00960: ambiguous column naming in select list

These reports are all working in machine A, some are working in Machine B and others are not. Both machines are using cognos 8.3. The most strange thing is I've unsorted some columns in one of the not working reports, it becomes working. I dont understand why this happen. Does anyone have experienced these before. pls help!

[MFGF]

I'd guess the configuration of the Oracle client on machine B is different somehow to the one on Machine A.  Perhaps the level of qualification is less on machine B?  Feels like an Oracle problem to me...

MF.