Error ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ACCOUNTING_DATE") While Saving Distributions Of AP Invoice (Doc ID 1418654.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

Problem Statement
---------------------
When trying to save distribution information on the line level, the below error occurs
"FRM-40735: PRE-RECORD trigger raised unhandled exception ORA-01430"

a) Create Standard Invoice with Distribution Set at header and all other required info.
b) Go to the “Lines” Tab and enter line information
c) After adding line info press “Distributions” button
d) Change the amount and then Save

Error "FRM-40735: PRE-RECORD trigger raised unhandled exception ORA-01430" pops up..

Using FND Debug Log the message was found to be

ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ACCOUNTING_DATE") on package
JAI_AP_STND_TAX_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