SQL Error On Monitor Approvals Page: "A Fatal PeopleCode SQL Error Occurred" (Doc ID 1318468.1)

Last updated on JULY 12, 2016

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


Issue with Approval Workflow Engine (AWE) when using Workforce Administration > Self Service Transactions Approvals and Delegation Monitor Approvals. The following error occurs.

ERROR
-----------------------
A fatal PeopleCode SQL error occurred

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Workforce Administration > Self Service Transactions > Approvals and Delegation > Monitor Approvals
2. Enter the approver id
3. Click on Search

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