EAR-BRA 9.1: Error Cannot Insert NULL While Applying Bundle FIN # 876369 or #893574 (Doc ID 2112981.1)

Last updated on MARCH 09, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Documentation

When attempting to upgrade tools as well as FMS Brazil localization from bundle 4 to latest bundle customer is getting following error.


ERROR
-----------------------
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSOPERATION"."IB_REST_OVERRIDE")
Failed SQL stmt: INSERT INTO PSOPERATION (IB_OPERATIONNAME, VERSION, DEFAULTVER, RTNGTYPE, IB_USERPWDREQ, IB_REQUESTSTATUS, IB_ACTIVEDATAGUARD, IB_THINKTIME, IB_READONLY_PERM, IB_RESTMETHOD, IB_REST_SERVICE, IB_RESTBASE_URL, IB_SERVICENAME, IB_ALIASNAME, MSGNAME, IB_MSGVERSION, LASTUPDDTTM, LASTUPDOPRID, OBJECTOWNERID, DESCR, DESCRLONG) VALUES (200,0)

SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSOPERATION"."IB_REST_OVERRIDE")
INSERT INTO PSOPERATION (IB_OPERATIONNAME, VERSION, DEFAULTVER, RTNGTYPE, IB_USERPWDREQ, IB_REQUESTSTATUS, IB_ACTIVEDATAGUARD, IB_THINKTIME, IB_READONLY_PERM, IB_RESTMETHOD, IB_REST_SERVICE, IB_RESTBASE_URL, IB_SERVICENAME, IB_ALIASNAME, MSGNAME, IB_MSGVERSION, LASTUPDDTTM, LASTUPDOPRID, OBJECTOWNERID, DESCR, DESCRLONG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, TO_TIMESTAMP(:17,'YYYY-MM-DD-HH24.MI.SS.FF'), :18, :19, :20, :21)
Error: Unable to insert row 1
Error: SQL execute error for PSOPERATION
Ended: Tue Mar 01 12:19:02 2016
Unsuccessful completion




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1: Upgrade to latest Brazil localization FMS bundles.

BUSINESS IMPACT
-----------------------
Cannot finish upgrade process.

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