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

"Niall Litchfield" <niall.litchfield_at_gmail.com> schreef in bericht news:ecaaf381-8189-42e7-b13c-472bd18709f6_at_s8g2000prg.googlegroups.com... On Mar 12, 3:31 am, batman <uspen..._at_gmail.com> wrote:
> we are doing a clean install of 11.5.10.2 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

    ad_bugs
 where

    bug_number = '&bug_no'
    and exists (

            select
                    null
            from
                    ad_bugs
            where
                    bug_number = '&bug_no')

    'NO' applied
 from

    dual
 where

    not exists (

            select
                    null
            from
                    ad_bugs
            where
                    bug_number = '&bug_no');

regards

Niall

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Nial,

maybe I'm overlooking something, but what is the difference between

select

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

    ad_bugs
 where

    bug_number = '&bug_no'
    and exists (

            select
                    null
            from
                    ad_bugs
            where
                    bug_number = '&bug_no')

and

select

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

    ad_bugs
 where

    bug_number = '&bug_no'

?

Don't have ad_bugs here to test this....

Shakespeare Received on Sat Mar 15 2008 - 14:11:34 CDT