My Oracle Support Banner

Demand Plan Errors Out -ORA-06512: At "FUSION.MSC_SOP_ROLAP_SNAPSHOT", Line 1973 (Doc ID 2566931.1)

Last updated on JULY 18, 2019

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

In version 11.13.19.01.0

The client reported their Weekly Demand Plan fails with error - ORA-06510: PL/SQL: unhandled user-defined exception

ERROR
---------
Execution started for Snapshot of Plan Members at : 05-Jul-2019 12:49:34-058
JOB PARAMETERS:
===========================================================
Plan ID: 300000028218483
Snapshot Mode: 1
Web Service Method Name: snapshotPlanMembersAsync
Job ID: 1099000
Parent Job ID: 1098998
Plan Type: 1
Stage: 1
===========================================================
SnapshotPlanMembers in MscSnapshotsService invoked! at 05-Jul-2019 12:49:34-270
SnapshotPlanMembers job got business error from method: snapshotPlanMembersAsync
SnapshotPlanMembers job got business error with message: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "FUSION.MSC_SOP_ROLAP_SNAPSHOT", line 1973
ORA-06512: at line 1


STEPS TO REPRODUCE
--------------------------
1. Set up user-defined weekly calendar.
2. Run plan for weekly forecast.
3. Error is received.

Changes

 N/A

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
Changes
Cause
Solution
References


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