My Oracle Support Banner

Fluid Class Enrollment SQL Exec Error -PTAI_ACTION_ITEMS (Doc ID 2656359.1)

Last updated on DECEMBER 10, 2021

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.


When attempting to enroll in Fluid Enrollment using Search and Enroll,the following error occurs.

SQL error in Exec
PTAI_ACTION_ITEMS.ActionItem.OnExecute Name:deleteDependents PCPC63813 Statement 1123
Called From... ... SSR_MANAGE_CLASSES.C (see attached doc for screen pic of error) and also error from app server log file

The issue can be reproduced at will with the following steps:
1. Have multiple student log in and try to enroll using Fluid Class Search and Enroll
2. Note that there is a deadlock occurring.


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

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