My Oracle Support Banner

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 APRIL 04, 2019

Applies to:

Oracle Product Lifecycle Analytics - Version 3.4.0 to 3.6.0 [Release 3.4.0 to 3.6.0]
Information in this document applies to any platform.


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


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

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