How Do I Find the Version Of HRMS in oracle APPS

How Do I Find the Version Of Human Resources (HR) On My System? [ID 269286.1]
		Modified 06-JAN-2012     Type HOWTO     Status ARCHIVED

In this Document
  Goal
  Solution
  References

---

Applies to:

Oracle Human Resources - Version: 11.5.5 to 11.5.10.2
Information in this document applies to any platform.

Goal

How do I determine the patch level of HRMS application code on our system?

Solution

1. You can run one of the general HRMS diagnostic scripts such as:
Note:462555.1 "Collecting Data Using The SSHR11i.sql Script as Requested by Support"
Note:211747.1 "HRMS11i.sql"
Note:208964.1 "PAY11i.sql"

2. Or you can run the following script from the SQL prompt:

SELECT substr(fpi.application_id,1,6) APP_ID
,substr(fat.application_name,1,40) APPLICATION
,substr(l.meaning,1,9) STATUS
,substr(decode(fpi.patch_level,null,'11i.'||
fa.application_short_name||'.?',fpi.patch_level),1,12) PATCH
FROM fnd_product_installations fpi
,fnd_application_tl fat
,fnd_application fa
,fnd_lookups l
WHERE (fpi.application_id between 800 and 850
OR fpi.application_id in (178,275,712,777))
AND fpi.application_id = fat.application_id
AND fpi.application_id = fa.application_id
and l.lookup_type = 'FND_PRODUCT_STATUS'
and l.lookup_code = fpi.status
ORDER BY fat.application_id;

3. Either of these methods requires and 11.5 instance and that AD MiniPack "G" (2344175) or greater has been applied.