My Oracle Support Banner

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

Last updated on APRIL 07, 2020

Applies to:

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

Symptoms



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

ERROR
-----------------------
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.




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
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.