This content has been marked as final. Show 4 replies
You do not need Middleware if you only intend to use Desktop. You have to use Administrator to create the EUL then you can create reports using Desktop.
The question is answered, so thank you. Since it is related, I want to ask the question here:
Oracle BI Discoverer Administrator - version 220.127.116.11.0
Oracle BI Discoverer Desktop - version 18.104.22.168.0
I was able to export from an old version (4i) and import it into a newly created EUL in my E-Business Suite 12.1.3 database (DB version 22.214.171.124 64-Bit), so I am able to login with the EUL user in Administrator, but I am not able to connect with an Application User using Discoverer Desktop.
I followed the document "Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12 [ID 1074326.1]"
In Desktop -> Options -> Connections; "Connect to application EULs" is selected since the EUL I created was for Application Users ONLY.
Gateway UserID/password: applsyspub/pub
Foundation Name: apps
I get the infamous error message:
"Unable to connect to: APPSUSERNAME@PROD
Failed to connect to database - Unable to connect to Oracle Applications database: invalid username/password."
If I change the option -> Connections to "Connect to both standard and applications EULs" I CAN login into Desktop using APPS/APPS@PROD or EUL5_US/EUL5_US@PROD, but I cannot see any of the imported Workbooks from the database.
Can you please advise as to what maybe wrong? Is this version of Discoverer certified with 12.1.3 on a 64-Bit Linux system? Could that be the reason?
This is unlikely to be a problem with certified versions, more likely to be a problem with the setup on the PC.
The EUL should have been created as a apps mode EUL. Therefore first check that you can connect using Disco Admin to the EUL with a apps user. To do this you need to connect with Disco Admin as the EUL owner and grant admin privileges to an apps user or responsibility then connect as this user or responsibility. Once you have this working then try with Disco User.
Check that you only have one EUL in the database and that Disco User attempting to connect to the correct EUL.
There are many reasons why you get an invalid username/password error. One reason is that the application is running in secure mode and you haven't copied across the .dbc file. See this [url https://forums.oracle.com/forums/thread.jspa?messageID=3460029�]thread for details or search the forum.
Rod West wrote:Above did the trick.
To do this you need to connect with Disco Admin as the EUL owner and grant admin privileges to an apps user or responsibility then connect as this user or responsibility. Once you have this working then try with Disco User.