Page 1 of 1

cannot connect as application user

Posted: Tue Nov 20, 2007 10:00 am
by AIMAM
hello,
I foolowed the following steps to use discoverer with oracle apps
1. Create new Discoverer End User Layer.
2. Verify Location of Database Connection File and Update tnsnames.ora file
3. Regenerate your Business Views
4. Set up Applications User/Responsibility for EUL Administration: SYSADMIN/System Administrator
7. Import the backup file from erpdev instance to production.
8. Refresh the Discoverer End User Layer
9. Grant EUL User Privileges for Oracle Applications responsibilities
10. Grant Access to Responsibilities, Users, and Workbooks
Log in to the Discoverer Administration Edition 4.1 as Applications User which was granted full Administration Privileges and Security:
connect as sysadmin/pwd
I failed to conect. what am i missing? Can anybody provide me with a detailed checklist to ensure that i can login to discovere administrator and desktop as application user.
Please help..

Posted: Tue Nov 20, 2007 11:21 am
by admin
Pl download Sys Admin v4 from tutorials section and there is a topic of Discovered there so just follow that. thanks

Posted: Wed Nov 21, 2007 7:07 am
by jscrunch
Hi,
same answer as in ORAFaQ:

it's more o less what you said buit.. may be it helps:

http://download-uk.oracle.com/docs/html ... htm#634203

Regards,
Jose L.

;-)

Posted: Wed Nov 21, 2007 8:37 am
by AIMAM
thank you all.

i fixed the problem. my mistake was that i didn't copy the dbc file from the application server to my pc and did not modify the tns file of my discoverer node.

Now, it's working perfectly.