My Oracle Support Banner

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 APRIL 30, 2020

Applies to:

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

Symptoms

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.


Changes

 

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