How To Find The Module Patch Levels On An eBusiness Suite Instance (Doc ID 1076033.1)

Oracle Field Service - Version 11.5.10.2 and later
Oracle Depot Repair - Version 11.5.10.2 and later
Oracle Scheduler - Version 11.5.10.2 and later
Oracle Mobile Field Service - Version 11.5.10.2 and later
Oracle Spares Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Sep-2013***

GOAL

How can one determine the patch level for an eBusiness Suite module?



SOLUTION

To determine the patch level for an eBusiness Suite module there are three options:

Either
(A) Run Diagnostics Apps Check Concurrent Request for the module (for example for the Field Service module use the parameters listed below):

Navigation path to run the concurrent request:
(R) Oracle Order Management
(N) Reports,Requests > Run Requests > Single Request

Name = Diagnostics: Apps Check
Parameters
----------
Application 1 = Field Service

To retrieve the output navigate to:
View > Requests > Relevant Request ID (button)
Click View Output > Save File as "filename.txt"

or

(B) In a similar way it is possible to obtain this information by running the 'Diagnostics' report from Order Management or Purchasing module. The required information can be gathered using the following steps:

1. Responsibility: Order Management Super User (or Purchasing Super User).

2. Navigation Path: Request -> Run Request ->  Single Request.

3. Choose "Diagnostics: Apps Check".

4. Select 'Product Name' from the Application LOV (You can choose up to 5 products).

5. Submit the request.

The generated report contains many details, but the data of particular interest is under the heading: Application Installation Details, where it lists the patch set level for each licensed application.

Or

(C) run the following SQL

select fpi.patch_level,
fa.application_short_name,
fa.application_id
from fnd_product_installations fpi,
fnd_application fa
where fa.application_short_name = '&short_name'
and fa.application_id = fpi.application_id;

The values for the variable &short_name would be:
CSF - Field Service
CSD - Depot Repair
CSR - Scheduler
CSM - Mobile Field Service
CSP - Spares Management