AP R12: Payables Open Interface Import or During Invoice Validation Errors due to"APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_LINES_ALL"."ACCOUNTING_DATE")" (Doc ID 2215489.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

When attempting to run the payables open interface import(FND debug log output)

or During Invoice Validation of an invoice from Invoice workbench

ERROR
-----------------------

AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Begining of Function
AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Index Value: xx
AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Period Name not there in plsql table:
AP.PLSQL.AP_ETAX_UTILITY_PKG.RETURN_TAX_LINES Insert exclusive tax lines
AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Period Name not there in plsql table:
AP.PLSQL.AP_ETAX_UTILITY_PKG.RETURN_TAX_LINES Insert exclusive tax lines
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-01400: cannot insert NULL into (""AP"".""AP_INVOICE_LINES_ALL"".""ACCOUNTING_DATE"") occurred in
AP_ETAX_UTILITY_PKG.Return_Tax_Lines<-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Calculate_Import<-AP_ETAX_PKG.Calling_eTax<-Import_invoiceswith parameters ( P_Invoice_Id = xx  P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Calculate_Import<-AP_ETAX_PKG.Calling_eTax<-Import_invoiceswhile performing the following operation:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Payables open interface import output:

fnd.src.process.fdpwrt.fdpwrt.log_write "REP-1419: 'beforereport': PL/SQL program aborted.

fnd.src.process.fdpwrt.fdpwrt.log_write "REP-0069: Internal error

fnd.src.process.fdpwrt.fdpwrt.log_write "REP-57054: In-process job terminated:Terminated with error:

fnd.src.process.fdpwrt.fdpwrt.log_write "REP-1419: 'beforereport': PL/SQL program aborted.

fnd.security.AppsConnectionManager getClientDataSupportClass(OracleConnection): END

Cause

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