- ERP System: Oracle
- MarkView Version: ALL
- How can I determine Release and Patchset versions for Oracle Applications?
- For many support and troubleshooting situations, it is very useful to understand the exact release of Oracle Applications as well as the exact patchset of various applications (especially the AP Patchset for DFM issues).
- MarkView 7.0 has introduced Fixpacks and Service Packs that automatically update the MarkView version number. The version number is then displayed in the MarkView Home and Support pages. Fixpacks and Service packs are not available in MarkView 6.x
- For MarkView 7.0 or later:
The version number is updated with each Fix Pack or Service Pack.
Fix Packs tend to refer to the fourth set of digits (i.e. Fix Pack 6 sets the version to 220.127.116.11)
Service Pack tend to refer to the third set of digits (i.e. Service Pack 2 sets the version to 7.0.2)
- For MarkView 6.x
The following work for Oracle Applications Release 11i versions. The Oracle Applications Release:
select RELEASE_NAME from fnd_product_groups
For the various application patchsets:
col short_name form a10 head "Short Name"
col full_name form a40 head "Full Name"
col status head Status
col patch_level form a10 head Patchset
from FND_PRODUCT_INSTALLATIONS fpi
where fpi.APPLICATION_ID = faav.APPLICATION_ID
order by 2
Keywords: release, version, oracle apps, oracle applications, patchset, DFM