For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Customers / Support
This has been one of the top requested enhancements from customers - the ability to search for requisitions using a supplier or an item.
In Update 19C, we introduce the feature that provides this capability as part of the Manage Requisitions search functionality.
How it works:
1. At least one is required: The at least one is required set of attributes for Manage Requisitions has been enhanced to add Supplier and Item. Users can now search providing one of these attributes:
a) Entered By
b) Requisition
c) Supplier
d) Item
2. Use a combination of Supplier and Item as well for more refined results
3. You will notice we have also added the attribute Created in the Simple Search panel. If searching by a supplier or an item is going to retrieve historical records that you are not interested in, then use the Created attribute to filter the results further. For instance use Last 60 days to refine the results to very recent requisitions
4. If you want to search for results say for more specific timelines (the last year, last 2 years etc.), use the Creation Date sort on the Search Results table to search using Any time and sort the results in descending order. You can then easily export the results to Excel to refine the results to the desired time frame.
The Manage Requisitions page is one of tactical and operational utility and so we have provided options for the search attribute Created on that basis to be shorter periods of time.
5. The supplier and items fields are enabled with the auto-suggest (similar to several other LOV fields) feature. This helps you to quickly find a supplier or item. You start typing the first 3 characters or keep typing to narrow the results as quickly as possible
6. Remember, when you search for a supplier, the system returns all requisitions in which at least one line contains that supplier. Supplier is an attribute that is available at a requisition line and not header because one requisition can contain multiple lines which may be sourced from different suppliers. You have to drill down into the requisition to view the specific lines where this supplier is a match if you have a reason to
7. Tips and Considerations:
8. Supplier not a Search Result column:
I am adding this observation here as well based on posts and feedback around this. The Supplier being a line level attribute, we do not display a search result column for the same in the Manage Requisitions table. The primary reason is that the requisition may potentially contain multiple lines with different supplier associations. The design thought then was whether that would serve any useful purpose in displaying something like 'Multiple' in the search results column which the user then has to click to view more detail. The design currently does not provide for a line level search on requisitions as this has not been a basic customer need in terms of Requisition search. If that is designed, then we would probably design this as well.
Comment
Hi Ashok,
This feature will be very helpful .. long awaited enhancement
. Thanks for detailing this functionality.
- Ramesh
Average Rating:



1 rating
|
Sign in to rate this
Good feature. Thank you.
Be the first to rate this
|
Sign in to rate this
Great !!
Be the first to rate this
|
Sign in to rate this
This is good enhancement. Quick question: Is Item# can search based on supplier item# also or only internal item#
Regards,
Manish
Be the first to rate this
|
Sign in to rate this
Hi Manish
This searches enables searching using master items, not supplier item numbers.
Be the first to rate this
|
Sign in to rate this
Hi Ashok
This is a very welcome addition. Thank you
Are there any future plans to add 'Supplier' as an additional column in Manage Requisitions to display the supplier name without having to drill down to the requisition to see it? I understand if there are multiple suppliers per requisition you would need to display 'Multiple' or similar as is currently the case with the PO number column where there are multiples POs for the requisition.
Kind regards
Andy
Be the first to rate this
|
Sign in to rate this
No plans at this time Andy. But we recently discussed this with another customer. I will try to find that link and provide here.
Here is the post I was referring to:
https://cloudcustomerconnect.oracle.com/posts/17f99a86e9
NOTE: Be sure to click 2 at the bottom to navigate to the second page where most of this discussion is
Be the first to rate this
|
Sign in to rate this