Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

×

Warning

JUser: :_load: Unable to load user with ID: 886

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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   

0 #1 Rakesh Parwal 2007-07-30 10:38
Hey Vijay,

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

App reciate your help in this... Please keep sharing knowledge.

Rak esh...
Quote
0 #2 Raj43sparsh 2007-07-30 10:47
wonderfully documented and explained. Especially the screen shots attached make it easier to understand. Thank you very much.
Quote
0 #3 Avadh Gautam 2007-07-30 10:54
great doc Vijay. We've been searching for such doc for long.
Quote
0 #4 arati 2007-07-30 11:49
Its a great document.
Thank s for sharing information.
Quote
0 #5 sonali 2007-07-30 15:29
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,
son ali
Quote
0 #6 Rich 2007-07-31 21:03
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
Quote
0 #7 Rich 2007-07-31 21:05
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
:)
Quote
0 #8 Vijay Dhapola 2007-08-01 02:22
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.
Quote
0 #9 Rajeev 2007-08-01 06:10
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 .
Quote
0 #10 Vijay Dhapola 2007-08-01 06:51
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(Deskto p) 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-PRE SSED trigger on Button
call the function using FND_FUNCTION.EX ECUTE
FND_FUNCT ION.EXECUTE(FUN CTION_NAME => 'Function_name created in step 2',
OPEN_FLAG => 'Y',
SESSION_FL AG =>'Y' );

Regards
Vij ay
Quote
0 #11 Ledu 2007-08-01 11:49
Very helpful document Vijay .It realy helped me a lot .Thanks for sharing this .Keep it up...
Quote
0 #12 nivedita 2007-08-01 11:56
Thanks for sharing :)

~nivedita
Quote
0 #13 nivedita 2007-08-01 11:57
hey vijey..
Thanks for sharing information .


~Nivedita
Quote
0 #14 nivedita 2007-08-01 11:58
hey vijey

Thanks for sharing information .

~Nivedita
Quote
0 #15 Navin Singh Kapkoti 2007-08-01 12:15
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..
Quote
0 #16 Neeraj Mathpal 2007-08-01 14:09
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.
Quote
0 #17 Rahul kaushik 2007-08-03 11:41
This is realy a good document.
Thank s ....
Quote
0 #18 Erkki 2007-08-07 11:52
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.
Quote
0 #19 Erkki 2007-08-07 11:54
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.
Quote
0 #20 saurabh_provab 2007-08-08 06:08
HI Vijay..
This doc is really good as you ahve explained ina very simple way with all the diagrams.Actual ly 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
Quote
0 #21 Baji 2007-08-09 06:20
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.
Thank s in advance for this document. waiting for ur reply

Regards
Vali
Quote
0 #22 Vijay Dhapola 2007-08-09 09:14
HI Vali

You need to Save your Workbook in Database.

Rega rds
Vijay
Quote
0 #23 Vishal Sharma 2007-08-11 22:09
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
Quote
0 #24 k yamini devi 2007-08-15 08:52
hai,
this is very good information.
pls i want details about apps tech architecture


regards
mini
Quote
0 #25 radhikaM 2007-08-15 19:07
Hy vijay

Thanks for sharing the information in a very precise manner...please keep sharing your great work!!
Quote
0 #26 Saurabh.s 2007-08-30 05:09
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
Quote
0 #27 kareem 2007-09-11 09:46
hi,
just i what to how can we pass Laxical parameters report 6i in the
apps.
wait for u replay.
Quote
0 #28 Pranjal 2007-09-18 13:22
Hi Vijay,

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

Auth entication Failed.
(Defaul t or specified schema containing EUL tables is
inaccessible )

Can you help me on above?

Thanks,
Quote
0 #29 Vijay Dhapola 2007-10-01 06:32
Hi Pranjal

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

Regards
vi jay
Quote
0 #30 Vijay Dhapola 2007-10-01 06:32
Hi Pranjal

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

Regards
vi jay
Quote
0 #31 sushant kumar 2007-10-08 15:03
Can u explain me regarding custom folder ,how to use function like nvl etc.. in item calculation,joi n,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
Quote
0 #32 nitin tugave 2007-10-12 10:30
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
Quote
0 #33 chetandeep 2007-10-21 23:52
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.
(Defaul t or specified schema containing EUL tables is inaccessible )

Please advise what could be the reason ?

Thanks.
Vish al.
Quote
0 #34 Vijay Dhapola 2007-10-22 11:25
Vishal

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

Regards
Vija y
Quote
0 #35 Sajid 2007-11-01 10:49
hi sonali
i have some doubts on oracle assets can u pls help me
Quote
0 #36 Nresh Raju 2007-11-17 15:02
Hi to all,

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

plz give me reply.

Regards ,
Naresh Raju.
Quote
0 #37 husenaiah 2007-11-26 07:23
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
Quote
0 #38 Vijay Dhapola 2007-11-26 07:40
Hi husenaiah,

Wha t error ur getting ??

Regards
Vij ay
Quote
0 #39 husenaiah 2007-12-05 10:30
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
Quote
0 #40 amita 2007-12-21 06:15
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...
Quote
0 #41 Vijay Dhapola 2008-02-02 06:27
Hi Husenaiah

Sorry for the delay reply....

Plea se 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

Cop y the name of the Identifier name paste it to
form function -->Form Tab--> Paramter
workbo ok=
Quote
0 #42 prasoon 2008-02-07 05:08
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
Pra soon
Quote
0 #43 saurabh.s 2008-02-08 07:17
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
saur abh
Quote
0 #44 Vijay Dhapola 2008-02-08 09:21
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
Quote
0 #45 Vijay Dhapola 2008-02-08 09:35
Pls try this....

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

Re gards
Vijay
Quote
0 #46 saurabh.s 2008-02-08 10:34
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
Quote
0 #47 saurabh.s 2008-02-08 11:07
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
Quote
0 #48 Vivek Kumar 2008-02-09 14:07
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.. ,
Quote
0 #49 Vivek Kumar 2008-02-11 03:57
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..,
Quote
0 #50 Kirubakaran 2008-02-13 06:42
Hi Vijay,

Really helpful document..

Tha nks a lot.

-Kiruba
Quote
0 #51 saurabh.s 2008-02-13 11:50
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 ...
Quote
0 #52 Caren 2008-03-04 17:26
Is there a way to determine which users are running what report in Discoverer and using what responsibility?
Quote
0 #53 Datta Padval 2008-03-09 18:24
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
Quote
0 #54 Mai ammar 2008-07-14 13:08
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
Quote
0 #55 sreedevi 2008-12-03 08:19
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 responsibilitie s and is not opening up the discoverer viewer. Can you help me understand what might be the issue? Thanks in Advance.
-Sreed evi.
Quote
0 #56 Yogesh Belgaonkar 2009-04-24 11:56
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
Quote
0 #57 Ranjitha_22 2009-05-11 01:24
Hi,

I document is very informative.Tha nks 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.

Thank s
Ranjitha
Quote
0 #58 madhusudhan reddy 2009-08-31 15:01
I document is very informative.Tha nks 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.
Quote
0 #59 HAS 2010-01-25 04:34
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
Quote
0 #60 Ramad 2010-03-02 13:16
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.
Quote
0 #61 SRINIVAS 2010-03-27 07:33
hi vijay

i want the details about the lexical parameters

Regards
srinivas
Quote
0 #62 Danny 2010-12-01 16:33
After following the directions (which are GREAT by the way), I get the following error:
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

I have shared the report with both the user and responsibility. Can you offer any suggestions?

T hanks
Quote
0 #63 abhay 2011-10-17 08:28
Dear Vijay, please would you know the use of logo in discvoerer report on module level , ex., if i want to use HR module then display the logo as "My HR" and ...
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner