My Oracle Support Banner

Create Similar Product Functionality For Existing Item. (Doc ID 2188856.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.4 version, Worksheet

When attempting to  run  'Data Modification Create Similar' workflow ,
the following error occurs.

ERROR
-----------------------
2016-09-04 17:32:07,941 AST [WFProcess_268] FATAL workflow.general: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series]
java.lang.RuntimeException: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series]
at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source)
at com.demantra.workflow.step.CustomStepHost.doExecute(CustomStepHost.java:196)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:944)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series]
at com.demantra.NPI.OnGoingCopyProcess.onGoingSeriesCopy(Unknown Source)
at com.demantra.NPI.OnGoingCopyProcess.runProcess(Unknown Source)
at com.demantra.NPI.NPIProcess.execute(Unknown Source)
... 6 more
2016-09-04 17:32:07,942 AST [WFProcess_268] ERROR dpweb.general: #################################### Step Failure. ####################################
2016-09-04 17:32:07,944 AST [WFProcess_268] ERROR dpweb.general: Process ID:  794152
Schema ID:   1336
Schema name: 'Data Modification Create Similar'
Step ID:     'Step1'
Step name:   'NPIStep_ONGOING'

Error description 'Program internal error:'
2016-09-04 17:32:07,944 AST [WFProcess_268] ERROR dpweb.general: ######################################################################################



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Workflow Manager.
2. Go to 'Data Modification Create Similar' workflow.
3. Run the workflow.
4. It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the ongoing copy of history for NPI .

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.