PL/SQL :: Getting Ora-12170 Error?

In my database while querying the below sql statement i am getting the ora-12170 error.

select AVAIL_QTY from CCH_AVAILABLE_QUANTITY;

when i used the describe command

DESC CCH_AVAILABLE_QUANTITY; it is executing and showing the 'AVAIL_QTY' column in the output.

i tried using all_tab_columns, all_tables to identify the schema of this table. the strange thing i found is

select * from all_tab_columns where column_name like '%AVAIL_QTY%'; this line is giving showing me the table name in the output.

but,

select * from all_tables where table_name like 'CCH_AVAILABLE_QUANTITY'; this line is executing but not giving me the out put.