My Oracle Support Banner

Yield Is found as 0 (zero) In Material Requirement For Jobs created via WIP Mass Load (Doc ID 2098940.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Work in Process - Version 12.1.3.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.3 version, There is a RSN ( Refresh Snap Shot) process which refreshes the data in WIP table WIP_WREQ_OPRS_SN before the data is collected in to ASCP tables. During that RSN ( Refresh Snap Shot) process, the following error occurs.

ERROR
-----------------------
ORA-12008: error in materialized view refresh path
ORA-01476: divisor is equal to zero
Error refreshing individual snapshot : WIP_WREQ_OPRS_SN




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run RSN ( Refresh Snap Shot)  process
2. observe fail


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.