While submitting PeopleSoft job, users may experience some permission issues. The job spool may show errors similar to following:
ORA-01031: insufficient privileges
These errors are usually due to inadequate privileges granted to the user, executing PeopleSoft jobs, on the PeopleSoft database.
Check the agent's peoplesoft.log - it would show an SQL query that resulted in the error. For instance:
PSPlugin.ps Internal Thread.PsDbHandler.runUpdateNoReconnect[:534] -
runUpdate: INSERT INTO PS_PRCSRUNCNTL (OPRID, RUN_CNTL_ID, LANGUAGE_CD, LANGUAGE_OPTION) VALUES ('MY_PS_USER','MY_CONTROL_ID','HIN','O') PSPlugin.ps Internal Thread.PsDbHandler.runUpdateNoReconnect[:554] - java.sql.SQLException: ORA-01031: insufficient privileges
In this above example the user 'MY_PS_USER' did not have the INSERT privilege to the PeopleSoft database.
Release: 11.3, 12.0
Component: Workload Automation Agent for PeopleSoft
The user used to execute the PeopleSoft jobs must have adequate privileges to the PeopleSoft database.
If the PS job failed try to run an interactive SQL query on that DB to make sure the user was able to execute one.
As per the PeopleSoft Agent's Implementation guide, the agent plug-in requires the UPDATE and the INSERT privileges to the following PeopleSoft database tables:
The agent's plug-in requires the SELECT privilege to the Process Scheduler database tables.
It is also recommended that you allow the SELECT access to all tables prefixed by PS or PS_.