Peoplesoft report job failed with the following errors shown in peoplesoft.log:
Tue Sep 21 20:00:00.971 MDT 2010 [ CRITICAL ] [PSPlugin Internal Thread, 5, PSPlugin]
CybWOBRunPsHandler.processWob[:185] - SQL Exception ORA-00904: "XXXXXX": invalid identifier
AFM: 2010092120000083+0600 AGENT_PS JavaAgent#tcpip@MANAGER12 SOMEJOB/
APPLNAME.49/MAIN RUN PS MFUser(USR12) ProcessName(XXXX_XXXX) ProcessType(Application Engine)
RunCntlId(XXXX_XXXX) PsOprId(USER) PsOprPassword(XXXXXXXXXXXXXXXX)
ServerName(PSUNX) OutDestFormat(PDF) OutDestType(WEB) DistrListUsers()
EmailLog(No) EmailWebReport(No)
Peoplesoft plugin was pointed to the 8.49 Peopletool system not the 8.50 one.