My Oracle Support Banner

FA:SCM:SCP: Post 20D Update - Demand Plan is failing at Snapshot Entity (Doc ID 2739405.1)

Last updated on DECEMBER 28, 2020

Applies to:

Oracle Sales and Operations Planning Cloud Service - Version 11.13.20.10.0 and later
Oracle Demand Management Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

Post 20D Update, Demand Plan is fails at Snapshot Entity stage. Logs files for ESS Snapshot Entity shows below Error.

ERROR:
ORA-00001: unique constraint (FUSION.MSC_SOP_LEVEL_MEMBERS_U1) violated

 

Changes

This issue will impact customers who have removed a time bucket which was previously in use. The issue is specific to time aggregated plans (DM, SOP, REPL) only

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.