My Oracle Support Banner

Data Discrepancy In PC_ECO_SIGNOFF_F And PC_ECO_SIGNOFF_DATA (Doc ID 2238025.1)

Last updated on AUGUST 23, 2018

Applies to:

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


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


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.