Description:
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: "LSEQNO": invalid identifier
AFM: 2010092120000083+0600 WATER1_PS JavaAgent#[email protected] DEPRCALC2000/
FS_AMDAILY.49/MAIN RUN PS MFUser(PRDUSR) ProcessName(AM_DEPR_CALC) ProcessType(Application Engine)
RunCntlId(AM_DEPR_CALC) PsOprId(PRODUSER) PsOprPassword(A716A790D128C075)
ServerName(PSUNX) OutDestFormat(PDF) OutDestType(WEB) DistrListUsers()
EmailLog(No) EmailWebReport(No)
Solution:
Peoplesoft plugin was pointed to the 8.49 Peopletool system not the 8.50 one.