Tuesday, 20 January 2015

How to find Applied/Present Patches, Mini Packsand Family Packs

SELECT a.application_name,
DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
patch_level
FROM apps.fnd_application_vl a, apps.fnd_product_installations b
WHERE a.application_id = b.application_id;

SELECT patch_name, patch_type, maint_pack_level, creation_date
FROM applsys.ad_applied_patches
ORDER BY creation_date DESC

1 comment:

  1. this is very nice article and very good information for Oracle ADF Learners. our Cubtraining also provide all Oracle Courses

    ReplyDelete

Number of Visitors