Re: clean install of oracle apps (ebs) 11i (11.5.10.2)
Date: Sat, 15 Mar 2008 20:11:34 +0100
Message-ID: <47dc1f7a$0$14342$e4fe514c@news.xs4all.nl>
"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')union all
select
'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