My Oracle Support Banner

Fluid Create Delegation Request Throws Fatal SQL Error on MySQL Server Environments (Doc ID 2654651.1)

Last updated on AUGUST 06, 2020

Applies to:

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

Symptoms

Customer reports that after applying Bug 30399593 ( Fluid Delegations) when they go to Manager Self Service > Delegation > Create Delegation Request and then try to Submit, they are getting a Fatal SQL Error

First message:


During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.


The issue can be reproduced at will with the following steps:
1. Click on Delegations tile in Manage Self Service
2. Click Create Delegation Request tile
3. Set Start/End date and add a comment
4. Select Delegate
5. Select any transaction
6. Receive the error

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.