French Deductible VAT Declaration Report Is Empty (Error : ORA-01476: Divisor Is Equal To Zero)

(Doc ID 1673988.1)

Last updated on AUGUST 29, 2016

Applies to:

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


On : 12.1.3 version, French Localizations for AP

When attempting to run French Deductible VAT Declaration Report ,The output is empty even there are invoices to declare. The program ends 'Completed/Normal' but the logfile shows:

An error occured while inserting and updating data to the global tmp table. Error : ORA-01476: divisor is equal to zero
End of the before report trigger

The issue can be reproduced at will with the following steps:
Run the French Deductible VAT Declaration Report


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