My Oracle Support Banner

After Patch 12250403 Build 4 The Workflow Step NPIStep_ONGOING Is Ending With Error (Doc ID 2754828.1)

Last updated on AUGUST 17, 2022

Applies to:

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

Symptoms

On : 12.2.8 version, MICC Transfer to TSC

After patch 12250403 build 4 the workflow step NPIStep_ONGOING is ending with error

Execute the workflow EBS Full download workflow.

2020-12-29 16:57:07,303 UTC [WFProcess_7] WARN workflow.general: [NPIStep] Statement Batch Clear failed
2020-12-29 16:57:21,900 UTC [WFProcess_7] FATAL workflow.general: Ongoing Copy completed with errors [return code: *-ERROR-*:-904 : ORA-00904: "M"."END_LIFECYCLE_DATE": invalid identifier]
java.lang.RuntimeException: Ongoing Copy completed with errors [return code: *-ERROR-*:-904 : ORA-00904: "M"."END_LIFECYCLE_DATE": invalid identifier]
at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source) ~[Common.jar:?]
at com.demantra.workflow.step.CustomStepHost.doExecute(CustomStepHost.java:196) [classes/:?]
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:980) [classes/:?]
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1324) [classes/:?]
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:685) [classes/:?]
at com.demantra.workflow.process.WFProcess.execute(WFProcess.java:653) [classes/:?]
at com.demantra.workflow.process

 

ERROR
-----------------------
Ongoing Copy completed with errors [return code: *-ERROR-*:-904 : ORA-00904: "M"."END_LIFECYCLE_DATE": invalid identifier]




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run EBS full download

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to load the data

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


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