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
-- 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 |