Automatic Snapshot Refresh Is Failing With Error ORA-01403: NO DATA FOUND After Upgrading

(Doc ID 1063403.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 09-May-2013 ***


Symptoms



After upgrading to R12, the client ran Refresh Snapshots and encountered the following error refreshing certain snapshots since these new R12 snapshots were missing.  An example of one of the failure logs is below:

MSRFWOR module: Refresh Snapshots
...
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
06-FEB 14:25:34 : ref mode - 3
06-FEB 14:25:34 : snp name - MTL_SYS_ITEMS_SN
06-FEB 14:25:34 : ORA-01403: no data found
06-FEB 14:25:34 : ORA-01403: no data found
06-FEB 14:25:34 : ORA-01403: no data found
06-FEB 14:25:34 : User-Defined Exception


Other Snapshots that failed included:

MTL_OH_QTYS_SN

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