R12: AP: Error APP-SQLAP-10000 Call to calculate tax Applying Prepayment (Doc ID 1197123.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply prepayment, the following error occurs.

 
FND log shows:

ZX_TDS_CALC_SERVICES_PUB_PKG.set_detail_tax_line_def_val(-)
-1400: ORA-01400: cannot insert NULL into ("ZX"."ZX_DETAIL_TAX_LINES_GT"."TAX_LINE_ID")
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
Incorrect return_status after calling ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt
RETURN_STATUS = U
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
Incorrect return_status after calling dump_detail_tax_lines_into_gt()
RETURN_STATUS = U
ZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines(-)
ZX_SRVC_TYP_PKG: IMPORTZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines returned errors
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
Completed the processing loop. Calling db_insert_line_det_factors..
ZX_SRVC_TYP_PKG:DB_INSERT_LINE_DET_FACTORS()+
INSERTING in ELSE...
ORA-22160: element at index [1] does not exist
RETURN_STATUS = U
ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
Handle errors returned by API
Get error message from eTax API
Get error message from stack
An unexpected error has occurred. Please contact your system administrator.
"APP-SQLAP-10000: An unexpected error has occurr occurred in
Apply_Prepay_Line<-Apply Prepayment Form
with parameters (&PARAMETERS)
while performing the following operation:
Call to calculate tax"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a prepayment invoice with tax
2. Create a standard invoice
3. Try applying prepayment invoice to standard invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply prepayment invoice to invoices.

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