Database internal error: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-01476: divisor is equal to zero (Doc ID 949101.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Apr-2012***
***Checked for relevance on 11-Sep-2013***

Symptoms

-- Problem Statement:
On 7.2 in Production:
When attempting to run workflow for publishing demantra consesus forecast to DENORM table
the following error occurs:

ERROR
'
Description : Process ID: 12032
Schema ID: 1102
Schema name: 'Publish Consensus Forecast'
Step ID: 'Step29'
Step name: 'Populate Denorm table'

Error description 'Database internal error: ORA-20015: Exception:
msd_dem_upload_forecast.upload_forecast - ORA-01476: divisor is equal to zero'
Source : dm
'

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Publish consesus forecast workflow


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