My Oracle Support Banner

iProcurement Requisitions Search Page Does Not Consider Requester Criteria When Supplier Criteria Is Also Entered (Doc ID 1547581.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.


In Oracle iProcurement, Release 12.1.3, when performing a requisition search, the Requester search value is ignored when the Supplier search value is selected from the Supplier list of values, and as a result the search results include all requisitions for the supplier, regardless of the requester on the requisition.  It is expected that the search results return only those requisitions that match both the Requester and Supplier search values entered by the user.

The correct and expected results are returned when the iProcurement user manually enters (types) the supplier name in the Supplier search field, instead of using the Supplier LOV to select the supplier name.

Steps To Reproduce

The issue can be reproduced at will in a Vision Demo environment with the following steps:

1. Log in as <USER>
2. iProcurement > Requisitions > Search
3. Perform the following test using the Supplier LOV:
a. Click the Clear button.
b. Specify Requester = <REQUESTER_NAME>
c. Click the LOV icon next to the Supplier field.
d. Search for and select the supplier <SUPPLIER_NAME> (site <SUPPLIER_SITE>, organization) from the list of values.
e. Back on the Search page, click Go --> more than ten rows are returned.  These rows are for various requesters, instead of returning only the rows for the requester specified in the search criteria.

4. Perform the following test by entering the Supplier name manually:
a. Click the Clear button.
b. Specify Requester = <REQUESTER_NAME>
c. Type in the value <SUPPLIER_NAME> in the Supplier field without using the list of values.
d. Clicked Go --> two rows are returned.  Both of these rows are for requester <REQUESTER_NAME>. This is the correct and expected result.

Business Impact

The issue causes confusion among the iProcurement users that utilize the Supplier list of values, as it makes it more difficult to find the requisitions that they need to take review and/or take approval action on.




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.