Error in the archive log file, when attempting to archive a database object: "ORA-00942 Table or View Does Not Exist".
This error is caused by a missing Stat PeopleTools shadow table, or by improper access to the PeopleTools table that the archive is being taken from.
1. Go to "Maintenance | General | PeopleSoft Connections" from the Stat menu bar.
2. Check/Verify the database login account that is entered for the database in question. Typically this would be the owner of the PeopleTools tables (SYSADM). but security restrictions may result in a custom defined/created user being entered.
3. Check the database object access for this user is correct. For proper Stat functionality the user should be able to select, update, insert and delete from the PeopleTools tables.
If the above checks/steps do not resolve the "ORA-00942", please contact Quest Support for further assistance, noting Solution 17078 in the case.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center