Re: clean install of oracle apps (ebs) 11i (

From: Niall Litchfield <>
Date: Fri, 14 Mar 2008 16:00:45 -0700 (PDT)
Message-ID: <>

On Mar 12, 3:31 am, batman <> wrote:
> we are doing a clean install of on a win 2003 server.
> it is a a multi-tier installation with a single DB node and a single
> apps/etc node.
> all pre-reqs check out ok and the installlation goes smoothly and all
> post install checks are ok too. postinstall, however, we have gotten
> mixed opinions about installing patches. when we look into one patch
> it asks for a prereq of a different one and the cycle seems to go on
> forever. the only modules we need is HR and financials. the install
> is
> a fresh download that only about 3 weeks old. does anyboy have a list
> of specific patches (including pre-reqs), if any, we need to download
> to be up to date and stable. we are primarilly a microsoft shop and
> definetly a bit spoiled with the single click updates to all our
> microsoft software without any user interaction.

Welcome to the wonderful world of apps, and ERP in general.

We use the script below to check whether pre-reqs are applied, but yes it isn't for nothing that there are courses on applying patches for apps - and that other ERP makers release patches daily as well.

 set verify off
 ACCEPT bug_no PROMPT 'Enter Bug Number: '  select

    'YES on '||to_char(CREATION_DATE,'dd-Mon-yyyy') applied  from


    bug_number = '&bug_no'
    and exists (

                    bug_number = '&bug_no')
 union all

    'NO' applied


    not exists (

                    bug_number = '&bug_no');


Niall Received on Fri Mar 14 2008 - 18:00:45 CDT

Original text of this message