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

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

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

Load External File into Group Post or Create New Group Returns ORA-00001:unique constraint (SYSADM.PS_GROUP_LINE) violated (Doc ID 2893378.1)

Applies to:

Symptoms

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!