R12 EBS Upgrade Fails At Patch U6678700.Drv script appdstln.sql with Error ORA-01400: cannot insert NULL into ("AP"."AP_PAYMENT_HIST_DISTS"."INVOICE_DISTRIBUTION_ID") (Doc ID 1353799.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Payables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

In 11.5.10.2 while upgrading to R12.1.1
Patch 6678700 failed while executing appdstln.sql script, with the following errors:

ERRORS
----------------
sqlplus -s APPS/***** @/app_base/LGENV2/R12Apps/apps/apps_st/appl/ap/12.0.0/patch/115/sql/appdstln.sql &un_ap &batchsize 1 4
DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("AP"."AP_PAYMENT_HIST_DISTS"."INVOICE_DISTRIBUTION_ID")
ORA-06512: at line 38

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