The Batch Job, PO_WFREQAMT, Is Going To No Success, abending at Step PO_WFREQAMT.MAIN.Step01 (PeopleCode) -- RC = ? (Doc ID 1608852.1)

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

PO_WFREQAMT and PO_WFREQCF are abending when run on UNIX process scheduler with the following error:

File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 656 Error Position: 0 Return: 601 - [IBM][CLI Driver][DB2/AIX64] SQL0204N "FSPRD.PS_PO_MAINT_WRK" is an undefined name. SQLSTATE=42704 Failed SQL stmt: SELECT OPRID_ENTERED_BY, OPRID_APPROVED_BY, OPRID_MODIFIED_BY, ENTERED_DT, APPROVAL _DT, LAST_DTTM_UPDATE, FIELD_LABEL1, FIELD_LABEL2, FIELD_LABEL3, GROUP1, GROUP2, GROUP3 FROM PS_PO_M AINT_WRK

The same processes are working fine on NT process scheduler

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms