EGL : 9.2 Conversion Process Abended at UPG_GL.GLZ02.STEP01A - ORA-01400: cannot insert NULL into ("PS92MTP1"."PS_INSTALLATION_GL"."SKIP_IU_OPT") (Doc ID 1952716.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : 9.2 version

When attempting to Upgrade from FSCM 9.0 to 9.2 conversion failed with
the following error occurs.

ERROR
-----------------------
Return: 1400 - ORA-01400: cannot insert NULL into ("PS92MTP1"."PS_INSTALLATION_GL"."SKIP_IU_OPT")
Failed SQL stmt: INSERT INTO PS_INSTALLATION_GL (APPROVAL_METHOD , JRNL_DEL_METHOD , SERVERNAME , SLEEPTIME , JRNL_SOURCE , GEN_IU_OPT , SYSTEM_ID , TRANSFER_ID , YTP_BALANCE) VALUES ('V' , 'P' , ' ' , 10 , ' ' , 'N' , 0 , 1 , 'N' )
Process XXXX ABENDED at Step UPG_GL.GLZ02.Step01A (SQL) -- RC = 1400 (108,524)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run data conversion process for 9.0 to 9.2

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