ICC EXCHANGE RATE BATCH JOB NOT WORKING AS EXPECTED-ORA-01476 divisor is equal to zero (Doc ID 1993627.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.11 and later
Information in this document applies to any platform.

Symptoms

The ICC Exchange Rate Batch job which loads data into DIM_CURRENCY_RATE table from STG_CURRENCY_RATE table is not working as expected.
The data in DIM_CURRENCY_RATE is not loaded since 09-Oct-13. When the logs are checked, below error is thrown

"ORA-01476 divisor is equal to zero" error is coming in the logs.

Cause

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