R12: AP: Payables Open Interface Import Ends in Error ORA-01476: Divisor is Equal to Zero
(Doc ID 1943793.1)
Last updated on FEBRUARY 03, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Payables Open Interface Import process ends in error
When attempting to to link the Credit Note to a invoice with at least one
distribution with amount zero, the following error occurs :
"APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in
Get_Dist_Proration_Info<-Create_Invoice_Lines_Dists<-AP_INVOICE_CORRECTIONS_PK
G.Invoice_Correction<-APXIMPTCH - CREDIT_MATCH
with parameters (Corrected Invoice Id = XXXXXX, Line Amount = 0, Prorate
Distributions Flag = Y)
while performing the following operation:
Populate distribution proration info"
distribution with amount zero, the following error occurs :
"APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in
Get_Dist_Proration_Info<-Create_Invoice_Lines_Dists<-AP_INVOICE_CORRECTIONS_PK
G.Invoice_Correction<-APXIMPTCH - CREDIT_MATCH
with parameters (Corrected Invoice Id = XXXXXX, Line Amount = 0, Prorate
Distributions Flag = Y)
while performing the following operation:
Populate distribution proration info"
Steps to reproduce
1. Navigate in Payables to Other > Requests > Run
2. Run the Payables Open Interface Import
3. Review the log for errors
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 |