R12: AP/CLL: Unable to Pay an Invoice with Withholding Tax Due to Error : "APP-SQLAP-10000: ORA-01476: divisor is equal to zero"
(Doc ID 2211818.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterLAD Add-on Localizations - Version 12.0 and later
Information in this document applies to any platform.
Symptoms
When a user attempts to pay an Invoice with Prepayment Application on it the following error occurs:
APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in
AP_WITHHOLDING_PKG.Create_AWT_distributions<-AP_WITHHOLDING_PKG.AP_Do_Withholding
with parameters ( Invoice Id = 134406, Calling module = QUICKCHECK Create dists = PAYMENT, Payment Num = 1, Currency code = PEN)
while performing the following operation:
Fetch CURSOR C_NONPREPAY_AWT
AP_WITHHOLDING_PKG.Create_AWT_distributions<-AP_WITHHOLDING_PKG.AP_Do_Withholding
with parameters ( Invoice Id = 134406, Calling module = QUICKCHECK Create dists = PAYMENT, Payment Num = 1, Currency code = PEN)
while performing the following operation:
Fetch CURSOR C_NONPREPAY_AWT
The issue can be reproduced at will with the following steps:
1. Using Payables Manager responsibility
2. Navigate to Payments : Entry > Payments
3. Enter the Payment Header and select the Invoice (which has Prepayment applied) for Payment
4. Try to save the Payment and hit the error.
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 |