Refresh Collection Snapshots Completes In Error Across Database Link
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
Refresh collections snapshots (MSRFWOR) across a database link gets:
*** 2010-04-29 15:03:11.929
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkzgjvsi_insgen()+558] [SIGSEGV] [unknown code] [0x000000000]  
The Refresh Collection Snapshots getting launched from the Data Collections are all failing.
However, if the Refresh Collection Snapshots program is launched separately in the Source Instance either for all Organizations or a single Organization, it will always complete successfully.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms