Main Menu
| Home |
| Technical Articles |
| Training Articles |
| Receive Email for New Articles |
| Contributors |
| Apps Book |
Related Items
Home 
Technical Articles Miscellaneous Technology Invoke Discoverer Report from Oracle Applications
Technical Articles Miscellaneous Technology Invoke Discoverer Report from Oracle Applications 
| Invoke Discoverer Report from Oracle Applications | | Print | |
| 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.
Comments
(53)
wonderfully documented and explained. Especially the screen shots attached make it easier to understand. Thank you very much.
great doc Vijay. We've been searching for such doc for long.
Its a great document.
Thanks for sharing information.
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
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
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 
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.
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 .
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
Very helpful document Vijay .It realy helped me a lot .Thanks for sharing this .Keep it up...
Thanks for sharing
~nivedita
hey vijey..
Thanks for sharing information . ~Nivedita
hey vijey
Thanks for sharing information . ~Nivedita
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..
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.
This is realy a good document.
Thanks ....
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.
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.
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
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
HI Vali
You need to Save your Workbook in Database. Regards Vijay
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
hai,
this is very good information. pls i want details about apps tech architecture regards mini
Hy vijay
Thanks for sharing the information in a very precise manner...please keep sharing your great work!!
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
hi,
just i what to how can we pass Laxical parameters report 6i in the apps. wait for u replay.
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,
Hi Pranjal
If you've created a custom folder the pls check the schema name is attached to it. Regards vijay
Hi Pranjal
If you've created a custom folder the pls check the table name should contain schema name with it. Regards vijay
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
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
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
Please check schema name is attached with tablename in the Sql query for Custom Folder . Regards Vijay
hi sonali
i have some doubts on oracle assets can u pls help me
Hi to all,
how to link between discoverer workbook and when we create a function in apps. plz give me reply. Regards, Naresh Raju.
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,
What error ur getting ?? Regards Vijay
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
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...
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=
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
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
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
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
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
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
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..,
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..,
Hi Vijay,
Really helpful document.. Thanks a lot. -Kiruba
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 ...
Is there a way to determine which users are running what report in Discoverer and using what responsibility?
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.
|
Subscribe to this comment's feed
This is a great docuemnt... thans a lot... It is really very helpful...
Appreciate your help in this... Please keep sharing knowledge.
Rakesh...