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.

Wednesday, March 7, 2007

Change Oracle Applications Host Name

I found a very good link to rename Oracle Applications host name. This can be useful to restore a backup to other machine or cloning the application.
This is the link: http://oraclesoon.blogspot.com/2006/11/oracle-e-business-suite-is-dependent-on.html.