Load External File into Group Post or Create New Group Returns ORA-00001:unique constraint (SYSADM.PS_GROUP_LINE) violated
(Doc ID 2893378.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise CS Student Financials - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to load an external file the following error occurs.
SFPRGPLD.SQR, Insert-Group-Line-Null-Due, Insert, PS_GROUP_LINE
SQL Status = 1, SQL Error = ORA-00001:unique constraint (SYSADM.PS_GROUP_LINE) violated
Error on line 71:
(SQR 3301) Program stopped by user request.
SQL Status = 1, SQL Error = ORA-00001:unique constraint (SYSADM.PS_GROUP_LINE) violated
Error on line 71:
(SQR 3301) Program stopped by user request.
The issue can be reproduced at will with the following steps:
1. Student Financials > Charges and Payments > Group Processing > Load External File
2. Populate the required fields (file name, directory where the resides, group type, layout id) and click run.
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 |