Synonym PA_PERIODS returns no rows
We are upgrading from 11.5.10 to 12.1.3. In R12, PA_PERIODS is now a synonm where as in 11i it was a view. The synonym points to PA_PERIODS_ALL table which contains records. When I query the synonym, PA_PERIODS, it does not produce any output. Any idea what might be preventing or what needs to be looked into?
Thanks and appreciate your help.