Data Discrepancy In PC_ECO_SIGNOFF_F And PC_ECO_SIGNOFF_DATA (Doc ID 2238025.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

For few changes, where multiple users added as approvers at Review states, all of the Approver names are not present in PC_ECO_SIGNOFF_F table.

Expected Behavior

All of the Approver names including users at awaiting for approval to be present in PC_ECO_SIGNOFF_F table.

Steps to Reproduce

  1. Launch Agile Web Client and create a ECO and add the workflow with two or more review status
  2. Route the workflow to Pending and Submit status
  3. Add multiple approvers for Review status from workflow tab
  4. Route next review state by keeping at least one approver as Waiting for Approve and remaining approvers should approve it
  5. On OPLA, run Full ETL
  6. Validate PC_ECO_SIGNOFF_DATA table for the approvers added in Step for respective state

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