My Oracle Support Banner

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 JANUARY 16, 2018

Applies to:

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


In while upgrading to R12.1.1
Patch 6678700 failed while executing appdstln.sql script, with the following 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
ERROR at line 1:
ORA-01400: cannot insert NULL into
ORA-06512: at line 38


To view full details, 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 a vibrant support community of peers and Oracle experts.