My Oracle Support Banner

PO "Status" Field And PO "Acknowledgment Status" Field Cannot Be Used In The Same Time (Doc ID 2636483.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle iSupplier Portal - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

In the iSupplier Responsibility-> PO Advanced Search Option, user can add different attributes in order to filter the information.
In this case, user is adding "Status" field and "Acknowledgment status".

So for the "Status" field user will have the option to select Cancelled or Closed or Opened.
and
for the "Acknowledgment status" user can select Accepted or Rejected or Requires Acknowledgment.

The problem is that both information are stored in the same column in the database. So user cannot select the "Status": Opened and "Acknowledgment status": Accepted.
In this case the the system will not return any data as the document does not have the status Opened AND Accepted.

So normally the system should restrict user to select both fields for filter.

Solution

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
Goal
Solution
References


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