Error during Invoice Validation "ORA-01476: Divisor Is Equal To Zero"

(Doc ID 1943362.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : 12.2.3 version, Tax Deducted at Source-Payables

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

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

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

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


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