Thursday, January 18, 2007

Installing WEB ADI in EBS 11.5.10.2


Install Webadi (BNE.D) on EBS 11.5.10.2

1. note 287080.1 on Metalink

2. check if WEB ADI is spliced into your environment

[oracle@ebs2 prod_ebs2]$ sqlplus apps/apps
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan 16 08:23:42 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> Select * from APPLSYS.FND_APPLICATION where APPLICATION_SHORT_NAME = 'BNE';


APPLICATION_ID APPLICATION_SHORT_NAME

-------------- --------------------------------------------------
LAST_UPDATE_DAT LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN
--------------- --------------- --------------- ---------- -----------------
BASEPATH PRODUCT_CODE
-------------------- --------------------------------------------------
231 BNE01-SEP-04 2 01-JAN-80 1 0BNE_TOP BNE

SQL>

If a record returns, then WEB ADI has been spliced.

2. install patch 4291053
3. install patch 3218526 (BNE.D)
4. from the adadmin menu compile apps schema (1)
Compile/Reload Applications Database Entities

---------------------------------------------------
1. Compile APPS schema
2. Compile menu information
3. Compile flexfields
4. Reload JAR files to database
5. Return to Main Menu


5. in the same adadmin session compile flexfield data in AOL tables (option 3)

6. restart application middle tier
7. Now you have a responsability 'Desktop Integraton' (see screen print on top..)


1 comment:

mimi miao said...

Got problem in installing Oracle ADI,
I successfully installed it before but my Orawin95 got problem after installing ADI so I have to uninstall it and re-install Orawin95 and ADI,
I already set default_home for ADI according to installation manual, but to my dismay I got error, re. "Object variable or with block variable not set Error Number:91.", I again uninstall and re-install for so many times and cleaned the registry and path but still the error persists.
Thanks for the help! God Bless!