Invoke Discoverer Report from Oracle Applications

This article from Vijay Dhapola details the steps to invoke Discoverer Report from Oracle Applications eBusiness Suite.

Vijay is an Oracle Applications Technical Consultant with expertise in Reports, Interfaces, Workflows and Data Migration on Oracle Apps.

Link for Invoking Discoverer Report Through Application

Set as favorite

Bookmark

Email This

Comments (61)

Subscribe to this comment's feed

...
written by Rakesh Parwal , July 30, 2007

Hey Vijay,

This is a great docuemnt... thans a lot... It is really very helpful...

Appreciate your help in this... Please keep sharing knowledge.

Rakesh...

report abuse

vote down

vote up

Votes: -1

...
written by Raj43sparsh , July 30, 2007

wonderfully documented and explained. Especially the screen shots attached make it easier to understand. Thank you very much.

report abuse

vote down

vote up

Votes: +0

...
written by Avadh Gautam , July 30, 2007

great doc Vijay. We've been searching for such doc for long.

report abuse

vote down

vote up

Votes: +0

...
written by arati , July 30, 2007

Its a great document.
Thanks for sharing information.

report abuse

vote down

vote up

Votes: +0

...
written by sonali , July 30, 2007

certainly a very helpful document Vijay...thnx so much
I have a doubt ..when we are defining the parameters during the formfunction definition ..we are also embedding the parameter values..so can we change the value of these parameters at the report run time? and how do we do that.
thnx,
sonali

report abuse

vote down

vote up

Votes: +0

...
written by Rich , July 31, 2007

Hi Vijay.
very useful document. I have a disco report that is initiated by a button on SSHR. Do you know the correct method to open the report viewer in a new window. At the moment it opens in the existing self-service window and the navigation is lost.
many thanks
Rich

report abuse

vote down

vote up

Votes: +1

...
written by Rich , July 31, 2007

report abuse

vote down

vote up

Votes: +0

...
written by Vijay Dhapola , August 01, 2007

Hi Sonali,

Yes, we can pass parameter dynamically.
One way is you can accept the parameters through forms and then pass them in
syntax
workbook=¶meters=~*~*~*

The other way is you can ask the parameters from Just before your discoverer sql is to be.
I'll soon release a doc in this regard.

report abuse

vote down

vote up

Votes: +0

...
written by Rajeev , August 01, 2007

Hi vijay ,
I saw your documents , Really this is wonderful . And this is very useful enhancement of the knowledge,of invoke the Discoverer report in apps environment . And way of presenting is very cake work . Thanks for sharing information .

report abuse

vote down

vote up

Votes: +0

...
written by Vijay Dhapola , August 01, 2007

Hi Rich,

If its Form Button then Yes, (else I'm not sure)....
you can achieve this by
1. Create a Folder(Admin) and Workbook(Desktop) as mentioned in doc.
2. Create a Function which is registered to the Workbook as explained in the doc.
3. Attach the Function with Menu (for desired Responsibility) leave Prompt as Blank.
4. In form create a WHEN-BUTTON-PRESSED trigger on Button
call the function using FND_FUNCTION.EXECUTE
FND_FUNCTION.EXECUTE(FUNCTION_NAME => 'Function_name created in step 2',
OPEN_FLAG => 'Y',
SESSION_FLAG =>'Y' );

Regards
Vijay

report abuse

vote down

vote up

Votes: +0

...
written by Ledu , August 01, 2007

Very helpful document Vijay .It realy helped me a lot .Thanks for sharing this .Keep it up...

report abuse

vote down

vote up

Votes: +0

...
written by nivedita , August 01, 2007

Thanks for sharing

~nivedita

report abuse

vote down

vote up

Votes: +0

...
written by nivedita , August 01, 2007

hey vijey..
Thanks for sharing information .

~Nivedita

report abuse

vote down

vote up

Votes: +0

...
written by nivedita , August 01, 2007

hey vijey

Thanks for sharing information .

~Nivedita

report abuse

vote down

vote up

Votes: +0

...
written by Navin Singh Kapkoti , August 01, 2007

This article is truely a good doc. for invoking Discoverer Report...
As i Needed it very urgently and thru the steps given inn this doc it was very easy for me to generate the doc. in lesser time as i am new to the orcale apps.
This is really a very hady doc.
Thanks Vijay..
Hope to see more in near future..

report abuse

vote down

vote up

Votes: +0

...
written by Neeraj Mathpal , August 01, 2007

This is one of the best documents available related to this subject. Vijay, SMEs like you should always write such documents and help oracle / discoverer community. You efforts are appreciated. It will stand you in good stead.

report abuse

vote down

vote up

Votes: +0

...
written by Rahul kaushik , August 03, 2007

This is realy a good document.
Thanks ....

report abuse

vote down

vote up

Votes: -1

...
written by Erkki , August 07, 2007

to Rich.

You can try to change Discoverer invokation function type to "SSWA plsql function that opens a new window (Kiosk Mode)" - WWK.

After that Discoverer Viewer will open in separate window.

report abuse

vote down

vote up

Votes: +0

...
written by Erkki , August 07, 2007

to Rich.

You can try to change Discoverer invokation function type to "SSWA plsql function that opens a new window (Kiosk Mode)" - WWK.

After that Discoverer Viewer will open in separate window.

report abuse

vote down

vote up

Votes: +0

...
written by saurabh_provab , August 08, 2007

HI Vijay..
This doc is really good as you ahve explained ina very simple way with all the diagrams.Actually I am new to discoverer .previously i was developing reports thru oracle reports.. so can you mail me some basic and fundamental document for discoverer .so i can practice with that .....
Thanks & Regards
Saurabh Srivastava
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

report abuse

vote down

vote up

Votes: +0

...
written by Baji , August 09, 2007

Hi Vijay,
Its really a good stuff, After registration when i click on the function name to
invoke the report it transfers to the login page directly. i need this issue should be solved. we have created a report with .dis . where it has to be saved . database or computer.
Thanks in advance for this document. waiting for ur reply

Regards
Vali

report abuse

vote down

vote up

Votes: +0

...
written by Vijay Dhapola , August 09, 2007

HI Vali

You need to Save your Workbook in Database.

Regards
Vijay

report abuse

vote down

vote up

Votes: +0

...
written by Vishal Sharma , August 11, 2007

Its a great document and very helpful. I get some small problem in implementing the similar solution.
When the discoverer report is launched from Oracle Apps. It returns an error saying there is no enough data to be displayed. I hit refresh button under this message then it shows me my Discoverer report and worksheet in it and then I click on worksheet ; it opens and displays the results properly. Is there a way to troubleshoot the misinformed error message.
Below is the error message which I get:
OracleBI Discoverer Viewer was unable to find the necessary data for displaying the results of this event. Please correct any errors and try again.
- -1

report abuse

vote down

vote up

Votes: +0

...
written by k yamini devi , August 15, 2007

hai,
this is very good information.
pls i want details about apps tech architecture

regards
mini

report abuse

vote down

vote up

Votes: +0

...
written by radhikaM , August 15, 2007

Hy vijay

Thanks for sharing the information in a very precise manner...please keep sharing your great work!!

report abuse

vote down

vote up

Votes: +0

...
written by Saurabh.s , August 30, 2007

HI Vijay,
Can you provide that how to create reports in discoverer step wise with diagram ,so that we can practice from that and learn ....
Thankx
Saurabh

report abuse

vote down

vote up

Votes: +0

...
written by kareem , September 11, 2007

hi,
just i what to how can we pass Laxical parameters report 6i in the
apps.
wait for u replay.

report abuse

vote down

vote up

Votes: +0

...
written by Pranjal , September 18, 2007

Hi Vijay,

Nice article , but I am getting following error when I click that function:

Authentication Failed.
(Default or specified schema containing EUL tables is
inaccessible )

Can you help me on above?

Thanks,

report abuse

vote down

vote up

Votes: +0

...
written by Vijay Dhapola , October 01, 2007

Hi Pranjal

If you've created a custom folder the pls check the schema name is attached to it.

Regards
vijay

report abuse

vote down

vote up

Votes: +0

...
written by Vijay Dhapola , October 01, 2007

Hi Pranjal

If you've created a custom folder the pls check the table name should contain schema name with it.

Regards
vijay

report abuse

vote down

vote up

Votes: +0

Discoverer
written by sushant kumar , October 08, 2007

Can u explain me regarding custom folder ,how to use function like nvl etc.. in item calculation,join,how to create summary folder and how to save Sql query in summary folder and use later when required.how to create function in pl/sql and how it's using in item.

Thanks
sushant kumar

report abuse

vote down

vote up

Votes: +0

Very good document
written by nitin tugave , October 12, 2007

This a very good document, you helped lots of people through this greate thing.
One doubt how to create pl sql functions in discoverer and triggers in discoverer.
one more question how to set multi org becaz when you access the multi org table to make worksheet it wont display reult how to acheive it

report abuse

vote down

vote up

Votes: +0

Authentication Failed
written by Vishal Goyal , October 21, 2007

Hi Vijay,

I tried all the steps as per the pdf file you have attached and it gave me error as below when i invoked the report using this new function.

Authentication Failed.
(Default or specified schema containing EUL tables is inaccessible )

Please advise what could be the reason ?

Thanks.
Vishal.

report abuse

vote down

vote up

Votes: +0

Vishal Goyal
written by Vijay Dhapola , October 22, 2007

Vishal

Please check schema name is attached with tablename in the Sql query for Custom Folder .

Regards
Vijay

report abuse

vote down

vote up

Votes: +0

...
written by venkat , November 01, 2007

hi sonali
i have some doubts on oracle assets can u pls help me

report abuse

vote down

vote up

Votes: +0

Doubt on discoverer
written by Nresh Raju , November 17, 2007

Hi to all,

how to link between discoverer workbook and when we create a function in apps.

plz give me reply.

Regards,
Naresh Raju.

report abuse

vote down

vote up

Votes: +0

Discoverer report in apps
written by husenaiah , November 26, 2007

Dear Vijay,
I am unable to getting the report output in apps.
I followed all steps what ever u prepared.
After attaching the user function to menu and conn to the our resp
i am unable to open the output.Pls send me how can we see the output after attaching the function to our menu.
Advance in thanks.
Regards,
Husenaiah

report abuse

vote down

vote up

Votes: +0

Hi husenaiah
written by Vijay Dhapola , November 26, 2007

Hi husenaiah,

What error ur getting ??

Regards
Vijay

report abuse

vote down

vote up

Votes: +0

Invoking the discoverer report in apps
written by husenaiah , December 05, 2007

report abuse

vote down

vote up

Votes: +0

unable to save a document
written by amita , December 21, 2007

Dear vijoy
when i am going to save a report a error occure..that is rep-1070:while opening or saving a document.how can i recover it???is there any solution to you.....please help me...

report abuse

vote down

vote up

Votes: +0

husenaiah
written by Vijay Dhapola , February 02, 2008

Hi Husenaiah

Sorry for the delay reply....

Please check the Name of Workbook should contain Name of the Identifier
you can get the same by Log into Desktop edition
Open the Workbook
File --> Manage Workbook --> Properties

Copy the name of the Identifier name paste it to
form function -->Form Tab--> Paramter
workbook=

report abuse

vote down

vote up

Votes: -1

Error while running discoverer report from oracle
written by prasoon , February 07, 2008

Hi Vijay,

The error facing by husenaiah I am also facing the same error. As per your comments I checked the workbook parameter and its value is same as identifier. Please suggest what should I do

Regards
Prasoon

report abuse

vote down

vote up

Votes: +0

report error
written by saurabh.s , February 08, 2008

HI vijay . i have follow your doc regarding registering discoverer report with application but i m getting this error " Authentication Failed
(Default or specified schema containing EUL tables is inaccessible )" ..I have tried all the possible ways and even i have checked the schema also , but still it is not coming.can you plz tell me in detail tht how to rectift this problem ..
regards
saurabh

report abuse

vote down

vote up

Votes: +0

Saurabh.s
written by Vijay Dhapola , February 08, 2008

Hi Saurabh

Please Open ur worksheet in Desktop edition and
go to File --> Manage Workbook --> Sharing

Share the Workbook for ur required Responsibility and User.
I've missed out this step in my PDF..
Anyway, pls try and revert..

vijay

report abuse

vote down

vote up

Votes: +0

Hi Prasoon
written by Vijay Dhapola , February 08, 2008

Pls try this....

Please Open ur worksheet in Desktop edition and
go to File --> Manage Workbook --> Sharing

Share the Workbook for ur required Responsibility and User
Pls try and revert the same.......

Regards
Vijay

report abuse

vote down

vote up

Votes: +0

...
written by saurabh.s , February 08, 2008

Hi Vijay ...
i tried with this and again it is showing same error... now i m testing from dummy table dual and in sharing giving responsibility for AP ....again it is showing same problem...
plz tell me ..
saurabh

report abuse

vote down

vote up

Votes: +0

report error
written by saurabh.s , February 08, 2008

report abuse

vote down

vote up

Votes: +0

...
written by ramu , February 09, 2008

Hi vijay, i am new subscriber and like to join in this discuss.

i was suffully completed, invoke discoverer report through oracle application. this was happened in vision or local instance.

but while i am doing this same in devloper or client instance i am geting the same error " Authentication Failed
(Default or specified schema containing EUL tables is inaccessible )" ..

i going with same properties at vision and devlopement instance, even though i am getting same error.
please kindly revert back

Thanks
Ramu..,

report abuse

vote down

vote up

Votes: +0

discoverer report error
written by ramu , February 11, 2008

Hi vijay, i am new subscriber and like to join in this discuss.

i was sucussffully completed, invoke discoverer report through oracle application. this was happened in vision or local instance.

but while i am doing this same in devlopement or client instance i am geting the same error " Authentication Failed
(Default or specified schema containing EUL tables is inaccessible )" ..

i going with same properties at vision and devlopement instance, even though i am getting same error.
please kindly revert back

Thanks
Ramu..,

report abuse

vote down

vote up

Votes: +0

Developer.
written by Kirubakaran , February 13, 2008

Hi Vijay,

Really helpful document..

Thanks a lot.

-Kiruba

report abuse

vote down

vote up

Votes: +0

...
written by saurabh.s , February 13, 2008

HI vijay .still i m facing that same problem in discoverer report ..that authentication faliure error.plz tell me the solution .and one more thing can you plz tell me that weather we can develop "Trail Balance Report"(which comes under GL) in discoverer.if yes can you guide me for this coz i got thsi report whcih is developed by oracle in report builder .but her i want to develop same thing in discoverer. can you plz guide me ...

report abuse

vote down

vote up

Votes: +0

Discoverer users
written by Caren , March 04, 2008

Is there a way to determine which users are running what report in Discoverer and using what responsibility?

report abuse

vote down

vote up

Votes: +0

Discoverer Reports
written by Datta Padval , March 09, 2008

Hi Vijay,
This document is really very good since you have explained it very simple way with all the screen shots. Actually I am new to discoverer.I develop reports through oracle reports, so can you please mail me some basic and fundamental document on discoverer. so I can practice with that .....
Thanks & Regards
Datta Padval
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

report abuse

vote down

vote up

Votes: -1

error while invoking discovere from oracle apps R12:
written by Mai ammar , July 14, 2008

Hi Vijay
Thanks for this article ,
I follow the stips exactly as in article , but I got this error :this installation does not manage mode Pl/Sql ,
what do you think should be done
appreciate any help

report abuse

vote down

vote up

Votes: +1

Discoverer viewer page is not opening
written by sreedevi , December 03, 2008

Hi Vijay,
I folllowed the same steps as mentioned in the document, but when I am trying to click on the link to invoke the discoverer report, it is opening up the page listing all the responsibilities and is not opening up the discoverer viewer. Can you help me understand what might be the issue? Thanks in Advance.
-Sreedevi.

report abuse

vote down

vote up

Votes: +0

Discoverer Plus Launching
written by Yogesh Belgaonkar , April 24, 2009

Hi Vijay

I followed the steps with existing discoverer report we have. It is launching workbook in Discoverer Plus and not in viewer. Do you reckon there is setup that determines this ?

Thanks
Yogesh

report abuse

vote down

vote up

Votes: +0

Registering discoverer report from Apps
written by Ranjitha_22 , May 11, 2009

Hi,

I document is very informative.Thanks for the information.
I have tried all the steps you have mentioned in the document.But still facing the same "Authentication failed" issue.
Can you please help us.
Thanks for the help in advance.

Thanks
Ranjitha

report abuse

vote down

vote up

Votes: +0

facing authentication problem when launching workbbok from apps
written by madhusudhan reddy , August 31, 2009

I document is very informative.Thanks for the information.
I have tried all the steps you have mentioned in the document.But still facing the same "Authentication failed" issue.
the error is
Authuntication failed.
(could not locate or parse the .dbc file corresponding to the given oracle application instance)
Can you please help us.
Thanks for the help in advance.

report abuse

vote down

vote up

Votes: +0

running same report from disc viewer and desktop
written by HAS , January 25, 2010

Hi

I am having problems running same report from viewer and desktop. In desktop the reports run fina and give me the desired results where as same rep when run in viewer gives me: Error
"
Query execution was not successful.
- null value
OracleBI Discoverer Viewer was unable to find the necessary data for displaying the results of this event. Please correct any errors and try again.
"
regards
Has

report abuse

vote down

vote up

Votes: +0

Error regarding opening report in apps
written by Ramad , March 02, 2010

Am new to oracle discoverer reports, am in to developing a simple dis report using Dis Admin and Dis Desktop and moving it to applications. I have done with Admin(Creation of Business area) and Desktop, now i can see a simple report output in my Dis Desktop edition, but i dont know how to assign this report workbook to a module(PO,AP,AR Etc), but i have registered the same report with reporting name as function in application throuhg application developer.

report abuse

vote down

vote up

Votes: +0

how to create the lexical parameters in reports
written by SRINIVAS , March 27, 2010

hi vijay

i want the details about the lexical parameters

Regards
srinivas

report abuse

vote down

vote up

Votes: +0

Write comment

Name