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 laterInformation 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 |