Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Check RUP PatchSet level in Oracle Apps 11i Rel.

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Check RUP PatchSet level in Oracle Apps 11i Rel.

    ================================================
    Use the following query to check the RUP Level:
    -----------------------------------------------

    select bug_number, decode(bug_number,'4334965', '11i.ATG_PF.H RUP3','4676589', '11i.ATG_PF.H.RUP4','5473858', '11i.ATG_PF.H.RUP5','5903765', '11i.ATG_PF.H.RUP6','6241631','11i.ATG_PF.H.RUP7') Patch_Description
    from ad_bugs where bug_number in ( '4334965','4676589','5473858','5903765','6241631') ;
    Regards,
    -Amit

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Patch Set level for All Product

    set lines 160
    set pages 1000
    col APPLICATION_NAME format a40
    select t.application_name
    , t.application_id
    , i.patch_level
    , decode(i.status,'I','Fully Installed',
    'N','Not Installed','S','Shared','Undetermined') status
    from fnd_product_installations i
    , fnd_application_vl t
    where i.application_id = t.application_id
    order by t.application_id;
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Quick Reference for commonly used Unix / Linux user level Commands
    By Hemant in forum OS for Oracle Administration
    Replies: 0
    Last Post: 06-26-2012, 01:07 AM
  2. Oracle 11gR2 Table level compression.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-25-2012, 02:53 PM
  3. Health Check script for Oracle RAC Database
    By Amit in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-03-2011, 12:41 PM
  4. Find Current Patchset Level For Oracle Application Modules
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-30-2011, 12:42 AM
  5. Applying patch for Developer 6i from patchset 14 to patchset 19
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 10-25-2011, 07:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics