AE: PSJobs fail due to ORA-00942 table or view does not exist

book

Article ID: 105805

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

PeopleSoft jobs fail with ORA-00942 indicating "table or view does not exist." 
This could be a permissions related issue internal to the AutoSys database.

Environment

Release:
Component: ATSYAP

Resolution

Ensure that the autosys DB user is granted access to the PS_PRCSOUTDESTTYPE table