Link to home
Start Free TrialLog in
Avatar of newbie27
newbie27Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Unable to run oracle report; Single Sign-On page appears.

Hello Experts,

Need urgent help please!

I intend to connect a report from form through a push button..

But when i click that button during run time, it is re-directing to the page of Single Sign-On instead of displaying the report.

Application and Database version details.

Oracle Application 10.1.2
Rac Database 11.1.0.6.0
Entry in Tns File :

TESTDB =
 (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP) (HOST = XX.XX.XXX.XX) (PORT = 1521))
    )
   (CONNECT_DATA =
    (SERVICE_NAME = TESTDB)
  )
 )

Report server is running. Single Sing-On service is disabled i.e. the parameter is commented under the report config file. Still i am facing the same single sign-on page when ever i try to generate the report from the forms.

Please advise.

Thanks in advance.
Avatar of newbie27
newbie27
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Correction in the TNS file.

TESTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.xxx.xx)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.xxx.xx)(PORT = 1521))
      (LOAD_BALANCE = YES))
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)
    )
  )
You must have installed Identity Management which includes SSO. Reports is protected by SSO.
You'll need to unprotect Reports.

Do you not use SSO? Do you not authenticate users?
Is this a new installation?

R.
I will also suggest you change this question to the correct zone Oracle IAS to get more help from relevant experts.

R.
See if this helps

http://download.oracle.com/docs/html/B14048_02/pbr_sec_arch.htm

I'll try and go through it later to see how to unprotect reports services (if you don't get there before me). I'm very busy today so please have a look through the doc.

R.
ASKER CERTIFIED SOLUTION
Avatar of newbie27
newbie27
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Problem solved by myself.