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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms