My Oracle Support Banner

Extract Data For Oracle Supply Chain Planning Cloud Concurrent Program Errors With ORA-01578 (Doc ID 2731138.1)

Last updated on NOVEMBER 24, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Request Processing

Extract data for Oracle Supply Chain Planning Cloud concurrent program errored out in R12.1.3
While running the Extract data for Oracle Supply Chain Planning Cloud parent program, the child programs "Create MRP Snapshots" and "Refresh Collection Snapshots (Refresh Collection Snapshots)" are errored out.

While the log file does not show an error, the output file contains the following:
 
ERROR
-----------------------
DECLARE
*
ERROR at line 1:
ORA-20001: MSCMRPSN: ORA-20001: Index Creation failed: ORA-01578: ORACLE data
block corrupted (file # 335, block # 105563)
ORA-06512: at line 500


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Extract data for Oracle Supply Chain Planning Cloud concurrent program.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.