12.1.0.2 : select from table results in 01031: insufficient privileges
Hello,
We have a EBS R12.2.8 database . The db version is 12.1.0.2. Selecting from one of the table results in "01031: insufficient privileges" error. I am trying to query this from same schema as the table owner. Other tables in this schema does not have this issue but only this table. The table has around 450000 records.
select count(*) from wip_discrete_jobs;
ORA-01031: insufficient privileges
I have connected to same schema as the table owner.
There are no error in alert.log and I checked for block corruption and did not find any block corrupt.
Please advise.
Thanks
Ram