1. Connect to the Discoverer Administrator Server
2. Add the TNS Entry to D:\ODisc10g\network\admin\tnsnames.ora
3. Ensure that TNSPING works for the TNS entry made in step 2.
4. Open Discoverer Administrator Tool D:ODisc10g\bin\dis51adm.exe
5. Connect as SYSADMIN (Make sure you check the Box "Oracle Application User")
6. Open all the Business Area
7. Select all the Business Area
8. Select File >> Refresh , this process involves two steps.
The first step validates , it gives a difference report at the end.
If there are differences then the second step refresh continues.
Using adrfseul.sh:
1. Mount EBSO Application Tier Server Node $AU_TOP/discover to Oracle10gAS Discoverer Instance.
2. Start the Refresh Process by Executing the below command
sh adrfseul.sh
connect=sysadmin/
resp="System Administrator"
gwyuid=APPLSYSPUB/PUB
fndnam=APPS
secgroup="Standard"
eulschema=EUL5_US
eulpassword=
twotask=
iashome=$ORACLE_BI_HOME
logfile=refresh_eul_us_