R12.1 Upgrade Fails with error ORA-01400: cannot insert NULL into (XLA.XLA_CONTROL_BALANCES.PARTY_TYPE_CODE)

(Doc ID 1345622.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
R12.1 Upgrade Fails with error ORA-01400: cannot insert NULL into (XLA.XLA_CONTROL_BALANCES.PARTY_TYPE_CODE)

Symptoms

Running u6678700.drv driver to upgrade to 12.1.1

one of the worker failed with below error

sqlplus -s APPS/***** xlaaxbal.sql &un_ax &batchsize

Session altered.

DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("XLA"."XLA_CONTROL_BALANCES"."PARTY_TYPE_CODE")
ORA-06512: at line 84

Changes

Apply upgrade patch 6678700

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