EGL: Year End Closing Error: Cannot Insert NULL Into EFF_STATUS (Doc ID 662861.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201071523



"****Checked for Relevance on 01-20-2015****


Symptoms

Problem:
Year End Closing error: cannot insert NULL into EFF_STATUS

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01400
Error Message : ORA-01400: cannot insert NULL into ("SYSADM"."PS_CLO_ACCT_TMP001"."EFF_STATUS")
Dynamic Stmt : GLPCPROC_I_DB340
SQL Statement : INSERT INTO PS_CLO_ACCT_TMP001 (ACCOUNT,ALTACCT,BALANCE_FWD_
SW,STATISTICS_ACCOUNT,BOOK_CODE,BAL_SHEET_IND) SELECT A.ACCO
UNT,' ',B.BALANCE_FWD_SW,A.STATISTICS_ACCOUNT,A.BOOK_CODE,A.
BAL_SHEET_IND FROM PS_GL_ACCOUNT_TBL A,PS_ACCT_TYPE_TBL B WH
ERE A.SETID=:1 AND A.ACCOUNT_TYPE=B.ACCOUNT_TYPE AND B.SETID
=:2 AND A.EFFDT=(SELECT MAX(D.EFFDT) FROM PS_GL_ACCOUNT_TBL
D WHERE D.SETID=:3 AND D.ACCOUNT=A.ACCOUNT AND D.EFFDT<=TO_D
ATE('2008-06-30', 'YYYY-MM-DD')) AND A.STATISTICS_ACCOUNT='N
'

SEVERE ERROR IN PGM:(5820,6) PI(272103) Program(GLPCPROC)
SQLRT error in DB340-INSERT ACCT TMP.

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