Deleting Enrollee In Enroll Individually Gives Error (2,280) after Applying HRMS 9.1 Bundle #12 (Doc ID 1592299.1)

Last updated on APRIL 07, 2015

Applies to:

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

Symptoms

On : HRMS 9.1.12,

Deleting enrollee in Enroll Individually gives error after applying HCM 9.1 Bundle 12 -

ERROR
-----------------------
SQL error in Exec. (2,280) TRN_ENROLL_VW.EMPLID.SavePostChange PCPC:3279 Statement 38
During the execution of SQL, and error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.





REPLICATION STEPS:
-----------------------

1. Navigate to Enterprise Learning > Student Enrollment > Enroll Individually.

2.  Select a course session that has students enrolled.
3.  Click on the [-] in the upper right corner of the Attendance section to delete an enrolled student.
3. Save.

Observe the error, which prevents users from removing a student from course enrollment.

Additional conditions causing the same error, replicated in an environment with HRMS 9.1 Bundle #17 applied

This same error was generated again: The error SQL error in Exec. (2,280) TRN_ENROLL_VW.EMPLID.SavePostChange PCPC:3279 Statement 38 During the execution of SQL, and error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

When an employee has a row already in the PS_SS_KEYS and PS_SS_PROCESS_DTL; and when that employee is enrolled in a Course, and then subsequently the employee cancels.  If the administrator attempts to delte the enrollment record the same error occurs.

 


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