My Oracle Support Banner

Spares Parts Search: Business Logic and Required Setups for Enhanced Functionality in 12.1.3+ (Doc ID 1396161.1)

Last updated on AUGUST 23, 2021

Applies to:

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


In Field Service business scenario, most times Technicians need Parts to perform a job. At times Technicians have required Parts on-hand but when they do not, they have to search for Parts, Order and receive them to perform the Task.

From the (HTML) parts requirement creation page the parts requirement can be entered. Then the source organization (i.e. where the part is to come from) can be entered manually. Alternatively, there is a 'Search Parts' button that will go through the sourcing setup and return all potential sources with expected arrival time. The user can then select the one he wants.

This document aims to describe the logic used and setup required for the parts search to return the expected results.


In 12.1.3+,  <patch 12411685> - 12.1.3++ ROLLUP PATCH FOR SPARES MANAGEMENT,  the parts search engine has been enhanced. Setup that may have worked before this may not return any results anymore, depending on what setup exists. Below setup would be required for this patchlevel and above.

Lower patch levels (e.g. 12.1.3 base release) may not require all steps, but they would not cause any trouble either. So setting it up now means the setup is already there when an upgrade happens. This will avoid unpleasant surprises after the upgrade.

Though this document was originally intended for the Parts Search HTML page, the features and setup described in here also apply to the Parts Search functionality in Field Service Wireless. That uses the same engine to execute the search.


There is also a Technical Brief available with more details about the functionality: <Note 2082343.1>


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
 Generic Required Setup
 Profile Options
 Planners Desktop
 Inter-Location Transit Times
 Spares Delivery Times
 Search Parameters
 Part Search Execution
 Spares Supply Chain
 Technical Background

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