Tuesday, March 27, 2007

Login to Discoverer using Oracle Applications Users

To login to Oracle Discoverer Desktop and Oracle Discoverer go to Tools --> Options menu. Then choose Connection tab. There are three radio buttons, choose Connect to applications EULs or Connect to both standard and applications EULs. Standard EULs will allow you to login with database users. Applications EULs will allow you to login with Oracle Applications users.
After selecting the radio button, enter APPLSYSPUB/PUB on Gateway User ID (GWYUID) / password. Enter APPS on Foundation Name (FNDNAM).
Logout and connect to database. Enter Oracle Applications user name and password. Make sure the user has already been given an access to business area and appropriate privileges. On connect dialog check on Oracle Applications User check box.

No comments: