Migrate E-Business Suite 11i Discoverer 4 End User Layers to Discoverer 10.1.2

Make sure Oracle E-Business suite service is stopped.
For this, stop the service by executing the “adstpall.sh”

Ex: su - applmgr cd /u02/oracle/pr/prcomn/admin/scripts/pr_app ./adstpall.sh apps/pass

Create DB schema to host 10g EUL.

Ex: CREATE TABLESPACE disco10g datafile '/u01/oracle/pr/prdata/disco10g_01.dbf' size 4000M autoextend on;

CREATE USER EUL5_US IDENTIFIED BY passwd DEFAULT TABLESPACE DISCO10g TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;


GRANT DBA TO EUL5_US;
GRANT DROP ANY SNAPSHOT TO EUL5_US;
GRANT RESOURCE TO EUL5_US;
GRANT CONNECT TO EUL5_US;
GRANT ANALYZE ANY TO EUL5_US;
GRANT CREATE ROLE TO EUL5_US;
GRANT CREATE VIEW TO EUL5_US;
GRANT CREATE TABLE TO EUL5_US;
GRANT CREATE SESSION TO EUL5_US;
GRANT CREATE SEQUENCE TO EUL5_US;
GRANT CREATE PROCEDURE TO EUL5_US;
GRANT SELECT ANY TABLE TO EUL5_US;
GRANT ALTER ANY SNAPSHOT TO EUL5_US;
GRANT CREATE ANY SNAPSHOT TO EUL5_US;
GRANT GLOBAL QUERY REWRITE TO EUL5_US;
GRANT SELECT ANY TABLE TO EUL5_US ;
GRANT EXECUTE ANY PROCEDURE TO EUL5_US;
GRANT SELECT ON APPLSYS.FND_APPLICATION TO EUL5_US;
GRANT SELECT ON APPLSYS.FND_DATA_GROUP_UNITS TO EUL5_US;
GRANT SELECT ON APPLSYS.FND_ORACLE_USERID TO EUL5_US;
GRANT SELECT ON APPLSYS.FND_PRODUCT_INSTALLATIONS TO EUL5_US;
GRANT SELECT ON APPLSYS.FND_USER TO EUL5_US;
GRANT EXECUTE ON APPS.FND_CLIENT_INFO TO EUL5_US;
GRANT SELECT ON APPS.FND_RESPONSIBILITY_VL TO EUL5_US;
GRANT SELECT ON APPS.FND_SECURITY_GROUPS_VL TO EUL5_US;
GRANT SELECT ON APPS.FND_USER_RESP_GROUPS TO EUL5_US;
GRANT ALTER ANY MATERIALIZED VIEW TO EUL5_US;
GRANT CREATE ANY MATERIALIZED VIEW TO EUL5_US;
GRANT DROP ANY MATERIALIZED VIEW TO EUL5_US;

ALTER USER EUL5_US QUOTA UNLIMITED ON DISCO10G;


Export from EUL 4i

Ex: $ exp EUL4_US/password@pr owner=eul4_us file=eul4_us_011209.dmp log=eul4_us_011209.log

Import EUL 4i objects into new schema


Ex: $ imp EUL5_US/password@pr file=eul4_us_011209.dmp
log=imp_eul5_us_011209.log fromuser=eul4_us touser=eul5_us ignore=y

Upgrade EUL to EUL 5.1.1


Download and install Oracle BI Discoverer Admin tool Open Discoverer Admin tool and provide user name and password details
in order to connect to EUL5_US schema.




Accept the Prompt for Upgrade

As and when you connected to new schema(EUL5_US) through Admin Tool, you
will be prompted EUL Upgrade.

Select “continue” on the above prompt.
Then select the second option button as shown in the above screen shot.
Now the upgrade will start.

Verify connection on BI Admin
Go to Tools/Options , on Connection tab and verify the connection.
Select “Connect to both standard and Application EULs”
Gateway User Id(GWYUID)/password: APPLSYSPUB/PUB
Foundation Name(FNDNAM):APPS

Verify default EUL
Once the EUL upgradation is done, then just very for the default EUL and make sure
it is the newly updated EUL
Go to Tools/Options, on Default EUL tab.
Ex: EUL5_US in this case.