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)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