My Oracle Support Banner

Autoinvoice fails with APP-AR-11526: Ora-01400: Cannot Insert Null (Doc ID 750681.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle E-Business Tax - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Oracle Receivables - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

 

Merged Into Note 465592.1

 

 

-- Problem Statement:
Interfacing invoices from Oracle projects to Oracle AR.

Autoinvoice Import Errors with the following in the log file:

APP-AR-11526: ORA-01400: cannot insert NULL into ("AR"."RA_CUSTOMER_TRX_LINES_ALL"."
begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :!
APP-AR-11526: 5069629/ar/src/autoinv/raaebt.lpc 121
Error calling raaebt()
Error calling raapic()

Tax Debug log showed:

ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount.BEGIN,ZX_TDS_TAX_ROUNDING_PKG: convert_amount(+)
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount,p_from_currency = USDp_to_currency = CADp_conversion_date = 31-OCT-08p_tax_conversion_type = Userp_trx_conversion_type = User
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate.BEGIN,ZX_TDS_TAX_ROUNDING_PKG: get_other_rate(+)p_from_currency = USDp_to_currency = CADp_conversion_date = 31-OCT-08p_tax_conversion_type = Userp_trx_conversion_type = User
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate,No rate found for tax conversion type: User
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate.END,ZX_TDS_TAX_ROUNDING_PKG: get_other_rate(-)rate =
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount.END,converted amount =
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount.END,ZX_TDS_TAX_ROUNDING_PKG: convert_amount(-)E

fnd.src.process.fdpwrt.fdpwrt.log_write,APP-AR-11526: ORA-01400: cannot insert NULL into ("AR"."RA_CUSTOMER_TRX_LINES_ALL"."

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

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