Discoverer Query

[vamsioracle]

Hi

I have a disocoverer report registered in Apps. Now hw can i find out the detail of that report in apps.

I have navigated through application develoer --> application--> form function and searched for the report name (identifier in desktop version) in the user fucntion name. It shows there is no such record.

If i have the report name and identifier, how can trace the registered report details.

Vamsi

[amitpatel66]

Check below steps for reference:

1. Create an Oracle Function for each Discoverer report.
2. Create the required menus and attach the relevant functions to these menus.
3. Create the required responsibilities and attach the relevant menus.
4. Set Profile Option
5. Assign Responsibilities to Users

details
-----------
1) do define a function, first open your discoverer report in the desktop edition, go to File->Manage workbooks->properties and note down the Identifier name
2) Now log onto Oracle Applications.
Select the System Administrator Responsibility.

Navigate -> Application -> Function

create a function for your discoverer report (note: the function type should be SSWA PLSQL...you can choose from list of values)
3)Once the Function setup is complete, the required menus can be created.
Navigate -> Application -> Menu

and attach your function to this menu
4) next go to
Navigate -> Security -> Responsibility -> Define
and attach the right menu to the right responsibility

5) Navigate -> Profile -> System
and set the ICX:Discoverer Parameters
(eg:_po000011101110111110000)

Once this is done makes sure to go thru your discoverer desktop edition

a) manage workbooks
b) toos->security
to share/manage workbooks

[vamsioracle]

Thanks Amit,

But this is registration of Discoverer report. But I want the reverse process. I have a report registered long time back. I have the report identifier with me, I want to see the registration detials.

Actual Problem is : We added a grand total column in the report. It is displayed in desktop version but not in viewer. When we did some research, we came to know that after some changes in the desktop version of discoverer, we need to take the identifier of that report and replace in the apps screen where previously it was registered. How to do that?


Vamsi