EGL9.1+: Journal Generator Abended At FS_JGEN_OUTJ.JrnlHdr.iJrnlHdr (SQL) -- RC = 1400 Error ORA-01400: Cannot Insert NULL into ("SYSADM"."PS_JRNL_HEADER"."ALC") (Doc ID 1339690.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
****Checked for Currency on Feb-18-2013****
****Checked for Currency on Nov-4-2014****

Symptoms

ENVIRONMENT
---------------------------
FSCM 9.1 MP6
TOOLS 8.51

ISSUE
----------------
When running journal generator on a AP voucher, the following error occurs:

ERROR
-----------------
File: e:\pt85105c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_JRNL_HEADER"."ALC")
Failed SQL stmt:INSERT INTO PS_JRNL_HEADER_FS (BUSINESS_UNIT, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, BUSINESS_UNIT_IU, ADJUSTING_ENTRY, FISCAL_YEAR, ACCOUNTING_PERIOD, ADB_DATE, LEDGER_GROUP, LEDGER, AUTO_GEN_LINES, REVERSAL_CD, REVERSAL_DATE, REVERSAL_ADJ_PER, REVERSAL_CD_ADB, REVERSAL_DATE_ADB, UNPOST_JRNL_DATE, JRNL_TOTAL_LINES, JRNL_TOTAL_DEBITS, JRNL_TOT_CREDITS, JRNL_NET_UNITS, SOURCE, TRANS_REF_NUM, JRNL_BALANCE_STAT, CONTROL_TOTAL_STAT, JRNL_EDIT_ERR_STAT, JRNL_HDR_STATUS, SUSP_RECON_STATUS, JRNL_PROCESS_REQST, JRNL_SUMLED_REQST, SJE_TYPE, SCHEDULE, EVENT_OCCURRENCE, POSTED_DATE, PROCESS_INSTANCE, SOURCE_INSTANCE, TRANSACTION_DATE, LAST_LN_COMMITTED, OPRID, DTTM_STAMP_SEC, DESCR, CURRENCY_CD, FOREIGN_CURRENCY, RT_TYPE, CUR_EFFDT, RATE_DIV, RATE_MULT, SYSTEM_SOURCE, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, DOC_SEQ_STATUS, ACCTG_DEF_NAME, BUDGET_HDR_STATUS, KK_AMOUNT_TYPE, KK_TRAN_OVER_FLAG, KK_TRAN_OVER_OPRID, KK_TRAN_OVER_DTTM, KK_SKIP, JOURNAL_LOCKED, PROC_PART_ID, GL_ADJUST_TYPE, JOURNAL_DATE_ORIG, JOURNAL_CLASS, KK_TRAN_BYPAS_FLAG, EE_HDR_STATUS, IU_SYS_TRAN_CD, IU_TRAN_CD, DESCR254) SELECT 'OSHWA', 'PA00162167', TO_DATE('2011-06-21','YYYY-MM-DD'), 0, 'OSHWA', 'N', 2011, 6, TO_DATE('2011-06-21','YYYY-MM-DD'), 'ACTUALS', ' ', 'N', 'N', NULL, 0, 'S', NULL, TO_DATE('2011-06-21','YYYY-MM-DD'), 0, 0, 0, 0, 'JAP', ' ', 'V', 'V', 'V', 'N', ' ', 'N', 'N', ' ', ' ', 0, NULL, 1169299, 1169299.1, TO_DATE('2011-06-21','YYYY-MM-DD'), 0, 'PAT', TO_TIMESTAMP('2011-06-21-11.26.35.000000','YYYY-MM-DD-HH24.MI.SS.FF'), 'AP Accrual', 'CAD', 'CAD', ' ', TO_DATE('2011-06-21','YYYY-MM-DD'), 1, 1, 'GAP', ' ', ' ', TO_DATE('2011-06-21','YYYY-MM-DD'), ' ', 'APDEFN', 'V', '1', 'N', ' ', NULL, '1', ' ', ' ', ' ', NULL, ' ', 'N', 'Y', ' ', ' ', 'AP Accrual' FROM PS_INSTALLATION

Process 1169299 ABENDED at Step FS_JGEN_OUTJ.JrnlHdr.iJrnlHdr (SQL) -- RC = 1400 (108,524)

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