My Oracle Support Banner

Merge Statement Is Failing After Upgrade To 19.3 with ORA-01400 (Doc ID 2655508.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 to 20.1 Beta [Release 19 to 20.0]
Information in this document applies to any platform.

Symptoms

merge is failing after upgrade from 12.1.0.2 to 19.3 In 12102 it used to work fine


After the upgrade we noticed:

ERROR at line 1:
ORA-01400: cannot insert NULL into
ORA-06512: at "XXXXX", line 42
ORA-04088: error during execution of trigger 'XXXXXXX'




Changes

Database Upgrade to 19.4

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.