ORA-00942: table or view does not exist but when I query the table it shows values

I run the following script:

 

select count(*) from pay_us_rpt_totals;

 

I receive values.

Then I do the following:

 

If the count is greater then zero, and there is NO PAYROLL PROCESS EXECUTING

 

truncate table pay_us_rpt_totals;
commit;

 

This is when I receive the ORA-00942: table or view does not exist.

Can someone explain this?

Best Regards

Holly