Oracle Point, Oracle Life.

Oracle Discoverer Version Messup

Recently, we experienced a weird problem on using oracle discoverer. Situation: Discoverer Client at version 4.1.37 Discoverer Administraion at version 9.0.4

Problem: Business Area changed on discoverer administration side will not applied in client side.

Solution:

1. Re-install Discoverer Administration Edition 4.1.37

2. Create a new Oracle account with SELECT on DDEF2000 tables

3. Log into the 4.1.37 Admin tool using the new account and create a new EUL

4. Reconnect as owner of the EUL and import the DDEF2000_DIST business area

5. Check the course level to make sure it is varchar

6. Give users’ access to the new EUL and the new business

7. Get user to log on and use Tools/Options/EUL to set his EUL to the new EUL

8. Reconnect user and open a workbook to verify that his issues are fixed. Note: It’s unbelivable that same software only with different version acts totally differently. There must be some significant changes on new version of oracle administration side. Also, experienced that new version didn’t accept importing of business area which is exported in version 4.1.37.

Popularity: 3% [?]