Demantra Workflow With Procedure Step and Recovery Abort Took 3 Hours To Terminate Upon A Failed Step (Doc ID 2263490.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Customer is looking for a way to set the timeout for a workflow that has a stored procedure step and fails due to a legitimate error

Customer had a situation that one of the settlement with split had a value with 257 characters on one of the field and the workflow returned with the following error.
FATAL workflow.general: ORA-12899: value too large for column "DEMANTRA"."CSTM_TPR_DEDUCTION_BRAND"."SETTLEMENTKEY" (actual: 257, maximum: 255)

The above was a legitimate error

The issue was that the Workflow has Recovery option as Abort but did not terminate the workflow. Instead it took 3 hours to terminate. Is there a way to set the workflow configuration on timeout to end the workflow step within 5 minutes or as soon as the step fails.
 

Solution

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