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

batman

unread,

Mar 11, 2008, 11:31:09 PM3/11/08

to

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.

thx

DA Morgan

unread,

Mar 12, 2008, 11:53:02 AM3/12/08

to

The patches you apply depend on what modules you are using and whether
the intention is to migrate to R12. You will need to be more specific
to figure out what you must/should do.

If you send me an email off-line I can get you the list of patches we
apply during our E-Business Suite class on the Vision database.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Niall Litchfield

unread,

Mar 14, 2008, 7:00:45 PM3/14/08

to

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

hpuxrac

unread,

Mar 14, 2008, 8:11:54 PM3/14/08

to

Ahh that's why oracle consulting loves to get involved with stuff like
this!

Niall Litchfield

unread,

Mar 15, 2008, 2:19:51 PM3/15/08

to

> this!- Hide quoted text -
>
> - Show quoted text -

I should probably have mentioned the Patch Wizard in OAM (Oracle
Applications Manager) in case you haven't found it yet. That will give
you lists of all updates, recommended updates and new code levels (in
case you wish to patch but not introduce new functionality in an
automated way).

Niall Litchfield
http://www.orawin.info/

Shakespeare

unread,

Mar 15, 2008, 3:11:34 PM3/15/08

to

"Niall Litchfield" <niall.li...@gmail.com> schreef in bericht
news:ecaaf381-8189-42e7...@s8g2000prg.googlegroups.com...

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