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
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...
Thank s for sharing information.
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
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
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
:)
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.
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 .
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
~nivedita
Thanks for sharing information .
~Nivedita
Thanks for sharing information .
~Nivedita
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..
Thank s ....
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.
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.
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
saurabh_provabindiatimes.com
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
You need to Save your Workbook in Database.
Rega rds
Vijay
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
this is very good information.
pls i want details about apps tech architecture
regards
mini
Thanks for sharing the information in a very precise manner...please keep sharing your great work!!
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
just i what to how can we pass Laxical parameters report 6i in the
apps.
wait for u replay.
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,
If you've created a custom folder the pls check the schema name is attached to it.
Regards
vi jay
If you've created a custom folder the pls check the table name should contain schema name with it.
Regards
vi jay
Thanks
sushant kumar
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
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.
Please check schema name is attached with tablename in the Sql query for Custom Folder .
Regards
Vija y
i have some doubts on oracle assets can u pls help me
how to link between discoverer workbook and when we create a function in apps.
plz give me reply.
Regards ,
Naresh Raju.
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
Wha t error ur getting ??
Regards
Vij ay
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
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...
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=
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
(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
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
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
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
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
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.. ,
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..,
Really helpful document..
Tha nks a lot.
-Kiruba
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
dattapmsn.com
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
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.
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
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
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.
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
i want the details about the lexical parameters
Regards
srinivas
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
RSS feed for comments to this post