Purge Posting Process Fails With Error 'Cannot insert the value NULL into column 'FINANCE_CHARGE', table 'PS_GROUP_LINE'; column does not allow nulls'
(Doc ID 2621589.1)
Last updated on AUGUST 27, 2021
Applies to:PeopleSoft Enterprise CS Student Financials - Version 9.2 and later
Information in this document applies to any platform.
The Purge Posting Table (SFBKPOST.SQR) process fails on Campus Solutions 9.2 on MSSQL Server platforms. This process ran successfully on Campus Solutions 9.0.
The error message received is:
SFBKPOST.SQR, Insert-Group-Line, Insert, GROUP_LINE
SQL Status = 515, SQL Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert
the value NULL into column 'FINANCE_CHARGE', table 'PS_GROUP_LINE'; column does
not allow nulls. INSERT fails.
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
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