Getting the data from other schema in the same database
I have a report that has few subreports. Some times some of these sub reports retreives the data from the same table in different schema.
ex: if I have table TEST on both schema A and B, and I use A.TEST in my report, but it get the data from B.TEST when I had login as user A.
Do anybody have any idea what is going on here. I use CR XI and Oracle 10g.
Thanks and appreciate any help.