Refresh Collection Snapshots MSRFWOR Fails With ORA-01403 (DB Link Mis-Match)

(Doc ID 869094.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

Using Advanced Supply Chain Planning / Standard Data Collection When attempting to perform Refresh Collection Snapshots, the following error occurs.

ORA-01403: no data found


Steps:
1. (R) Advanced Supply Chain Planner
2. (N) Collections > Oracle Systems > Standard Collection
3. Observe MSRFWOR Refresh Collection Snapshots log file containing ORA-01403: no data found without further elaboration.

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