Advanced Search Fetching Wrong Results, Approver Action "Does Not Contain" "Awaiting Approval" For Engineering Change Order (ECO) Are Returned in the Search Results (Doc ID 2905309.1)

Last updated on OCTOBER 26, 2022

Applies to:

Symptoms

Advanced Search Results showing improper results for Approver Action does not contain Awaiting Approval for Engineering Change Order (ECO). When performing the search, it is still returning results that contains Awaiting Approval.

Steps to reproduce:

1. Log into Web Client from URL: http://{server_name}.{domain_name}:{port}/Agile/PLMServlet
2. Create new ECO, C00001.
3. Set Workflow to Default Change Order.
4. Change Workflow status to Submitted.
5. Add approver (admin) by clicking "Add Reviewers".
6. Change Workflow status to CCB.
7. Add observer (admin2) by clicking "Add Reviewers".
8. Do an advanced search with the below criteria:

Changes | ECO | Object Search
Status | In | $STATUSTYPE.REVIEW | And
Approver Action | Does Not Contain | Awaiting Approval

Result: C00001 is included in the search result.

Cause

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