Cannot Apply Prepayment: Error On APP-SQLAP-10000:Occurred In Apply_Prepay_Line
(Doc ID 2079785.1)
Last updated on JANUARY 01, 2019
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.
On : 12.1.3 version, Cannot Apply Prepayment: Error: "APP-SQLAP-10000: occurred in Apply_Prepay_Line
The issue can be reproduced at will with the following steps:
1.Login to Payables Responsibility
2. Create invoice and prepayment and validate
3. Apply prepayment
The issue has the following business impact:
Due to this issue, users cannot apply prepayment normally.
Fnd Debug log:
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
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