Query on ITEM_STATUS_TABLE returns "does not exist"

Problem Symptoms

• Using third-party Location Changer tool returns error ORA-00942: table or view does not existwhen querying ITEM_STATUS_TABLE.
• Query on same or other tables using Prepackaged Reports (Reports.mdb) returns 

Could not execute query; could not find linked table.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist (#942)

Cause

Read-only user needs to be refreshed.

Resolution

1. Log onto server as oracle user.

2. cd /m1/utility

3. ksh readonly.ksh

4. Follow prompts to select database and refresh read-only user.

• Article last edited: 08-Nov-2016