Cannot Apply Prepayment: Error On APP-SQLAP-10000:Occurred In Apply_Prepay_Line (Doc ID 2079785.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

 On :  12.1.3 version,  Cannot Apply Prepayment: Error: "APP-SQLAP-10000: occurred in Apply_Prepay_Line


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to  Payables Responsibility
2. Create invoice and prepayment and validate
3. A
pply prepayment

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

Changes

Fnd Debug log:

ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX_API_PUB: CALCULATE_TAX:Calculate_Tax_Pvt returned errors. Return Status: U
EXCEPTION : Unexpected Error
Start Time :11-11-2015 14:45:41
End   Time :11-11-2015 14:45:41
Total Time :0:0:0
Number of partner calls :0
Time taken by partner(secs) :0
Number of records in ZX_TRX_HEADERS_GT :1
Number of records in ZX_TRANSACTION_LINES_GT :2
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

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