My Oracle Support Banner

Error during Invoice Validation "ORA-01476: Divisor Is Equal To Zero" (Doc ID 1943362.1)

Last updated on AUGUST 13, 2018

Applies to:

Oracle Financials for India - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Tax Deducted at Source-Payables

Invoice Validation Error: ORA-01476: divisor is equal to zero

ERROR
-----------------------
Unexpected error occurred during Tax Calculation.
Exception: Error-trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all: jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate
ORA-01476: divisor is equal to zero
Please correct the problem or contact your System Administrator

STEPS TO REPRODUCE
-------------------------------------
1. Navigate to India Local Payables
2. Enter Invoice with base tax code and save.
3. Click on "CALCULATE tax" button.
4. Apply TDS & WCT Taxes through Tools > TDS Tax Details
5. Validate the invoice and observe error

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.