CUR_WKFLW_STATE_FLG Column in PC_ECO_WORKFLOW_DETAIL_DATA Table Is Not Correct for Some Changes (Doc ID 2238024.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Product Lifecycle Analytics - Version 3.4.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

CUR_WKFLW_STATE_FLG is not updated properly in PC_ECO_WORKFLOW_DETAIL_DATA table.
No record with Current Workflow Flag as 1, in spite of the current workflow state of the below changes is 'Sourcing and Compliance Review' for some Change objects

Expected Behavior

CUR_WKFLW_STATE_FLG to be updated properly in PC_ECO_WORKFLOW_DETAIL_DATA table.

Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Launch Agile Web Client and create a ECO and add the workflow which has at least 2 review status
  2. Route the workflow to Pending and Submit status
  3. Add the multiple approvers for Review status from workflow tab
  4. Route next review state by keeping at least one approver as Waiting for
  5. Approve and remaining approvers should approve it
  6. On OPLA, run Full ETL
  7. Validate the CUR_WKFLW_STATE_FLG column in PC_ECO_WORKFLOW_DETAIL_DATA table




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