AP R12: Payables Open Interface Import Errorsdue to"APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_LINES_ALL"."ACCOUNTING_DATE")" (Doc ID 2215489.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Open Interface and Inv Import

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

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

AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Begining of Function
AP.PLSQL.AP_UTILITIES_PKGGet_Open_Gl_Date Index Value: 16-JAN-2017-82
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 = 2151385 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.security.AppsConnectionManager getClientDataSupportClass(OracleConnection): Using class oracle.jdbc.internal.ClientDataSupport
fnd.src.process.fdpwrt.fdpwrt.log_write "Enter Password:
"
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

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