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

#21

"Niall Litchfield" <niall.litchfield (AT) gmail (DOT) com> schreef in bericht
news:ecaaf381-8189-42e7-b13c-472bd18709f6 (AT) s8g2000prg (DOT) googlegroups.com...
On Mar 12, 3:31 am, batman <uspen... (AT) gmail (DOT) com> wrote:

Quote:

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

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

Re: clean install of oracle apps (ebs) 11i (11.5.10.2) - 03-15-2008 , 01:11 PM