<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Who's Online

We have 1 guest online

Related Items

Home
This website has now moved to http://apps2fusion.com





Invoke Discoverer Report from Oracle Applications | Print |  E-mail
Written by Vijay Dhapola   
Sunday, 29 July 2007

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

 

 

Comments (53)add
...
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...
...
written by Raj43sparsh , July 30, 2007
wonderfully documented and explained. Especially the screen shots attached make it easier to understand. Thank you very much.
...
written by Avadh Gautam , July 30, 2007
great doc Vijay. We've been searching for such doc for long.
...
written by arati , July 30, 2007
Its a great document.
Thanks for sharing information.
...
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
...
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

...
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
smilies/smiley.gif
...
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=&parameters=~*~*~*

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.
...
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 .

...
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


...
written by Ledu , August 01, 2007
Very helpful document Vijay .It realy helped me a lot .Thanks for sharing this .Keep it up...
...
written by nivedita , August 01, 2007
Thanks for sharing smilies/smiley.gif

~nivedita
...
written by nivedita , August 01, 2007
hey vijey..
Thanks for sharing information .


~Nivedita
...
written by nivedita , August 01, 2007
hey vijey

Thanks for sharing information .

~Nivedita
...
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..

...
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.
...
written by Rahul kaushik , August 03, 2007
This is realy a good document.
Thanks ....
...
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.
...
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.

...
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
saurabh_provab@indiatimes.com
...
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
...
written by Vijay Dhapola , August 09, 2007
HI Vali

You need to Save your Workbook in Database.

Regards
Vijay
...
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




...
written by k yamini devi , August 15, 2007
hai,
this is very good information.
pls i want details about apps tech architecture


regards
mini
...
written by radhikaM , August 15, 2007
Hy vijay

Thanks for sharing the information in a very precise manner...please keep sharing your great work!!
...
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
...
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.
...
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,
...
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
...
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
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
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
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.
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
...
written by venkat , November 01, 2007
hi sonali
i have some doubts on oracle assets can u pls help me
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.

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
Hi husenaiah
written by Vijay Dhapola , November 26, 2007
Hi husenaiah,

What error ur getting ??

Regards
Vijay
Invoking the discoverer report in apps
written by husenaiah , December 05, 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.
I ma getting this type of error
'x' function is not available under the 'xx' responsibility.Pls calrify me.
Advance in thanks.
Regards,
Husenaiah


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...
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=
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 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

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
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
...
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 error
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
...
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..,


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..,

Developer.
written by Kirubakaran , February 13, 2008
Hi Vijay,

Really helpful document..

Thanks a lot.

-Kiruba
...
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 ...
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?
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
dattap@msn.com
You must be logged in to a comment. Please register if you do not have an account yet.

busy