We are running Oracle Suite 11i. Our field users search for materials though iProcurement and the search capability within iPro is limited to description and a couple of other fields. When users lookup an item they get a long list of mostly irrelevant items and they must navigate through several pages before they find the item they need.
I created an Oracle Discoverer report to allow our field users to search for inventory items. The query that drives my report joins several Oracle Inventory and Oracle Purchasing base tables. The report includes more Inventory data points, such as category set information, to ensure more relevant query results.
The users have asked if it is possible to integrate the Discoverer report information with iPro. Obviously, Discoverer is not designed to do this easily so I would like to create a custom Oracle form or APEX application that would run the query and allow the user to select items to be sent to either the iPro shopping cart or shopping list. What data structures, processes or services exist within Oracle iProcurement and Oracle Suite 11i to support this? Are there any other development tools available besides Oracle forms that may be useful?
Integrating a discoverer report will not only be hard but also a bandaid.
The search functionality in iProcurement is quite extensive and configurable. It seems that you need to configure it properly. It is certainly not limited to description or a couple of fields. If you need any help with this, let us know.
The other options are using shopping lists/favorite item list.
Hope this helps,
Independent Techno-functional consultant