SF Error: Cannot Insert Null Into PS_SF_ACCTG_LN When Running Cashiering GL Interface (Doc ID 1368795.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

On CS 9 in Production, when running the Generate Cashiering Entries process (SFDPTREC.SQR) an error is received.

ERROR
-----------------------
/app/pt8.51/HCRS90/sqr/sfdeptrec..sqr: SFDEPTREC - SQL Statement =
SFDEPTREC.SQR, Create-Acctg-Line, Insert , PS_SF_ACCTG_LN
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("PSOWNER"."PS_SF_ACCTG_LN"."SSF_GL_TRANS_ID")


STEPS
-----------------------

  1.  run the Generate Cashiering Entries process after applying CS 9 Bundle 20

Changes

recently upgraded to CS 9 Bundle 20

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