Register Discoverer reports in oracle apps 11i and run it

How to Register Discoverer reports in oracle apps 11i and run it

If your application server has the setup for discoverer then at the time of creating work book it will ask for the responsibility in which this book is going to attached.
Else
You have to register it explicitly by creating new menus or functions.
Please do following steps for this:
1. Crate a report in Discoverer and login to Disc. Admin.
2.Enter Existing Business area or create new business Area.
3.Create a new custom folder
4. Write the SQL for discoverer Report and Name the Custom Folder and Then Validate the SQL.
5.Now Apply Security to the Custom Folder
Tools->Security
6.In Tab acœBusiness Area Useracc Tab
Select Your Business Area then
Select the User/Responsibilities to whom you want to give access to this Report
Select User/Responsibilities from Available User/Responsibilities Use  to
transfer to Selected User/Responsibilities.
7.Once Security is given You must provide the Privileges to your User or Responsibility
Tool->Privileges
Select your User Under Privileges tab
Provide the Privileges you want to give to your User Once done Press Apply then OK.
8.Now Login Discoverer Desktop Edition
Click on Create a New Workbook then Select the type of Workbook .
9.Click Next Select the Business Area from Available Drop Down
10.Then Select Your Folder Created previously in Admin Edition And Use -> to transfer to Selected
11.Click Next
As Required you can Use the Check box acœShow Page Items and hide Duplicate Rows
12. Click next
13.Here You can place some Condition to your Fetched Records
Click New and
Enter Description
Enter Item from Drop Down List ,
Enter your Condition and the Values
14.Click OK and Next
Then You can Sort your data
Click Add and Select the Column
You can also Add multiple Columns
15.Click Next Here You can Perform some Calculation by Click on New
16.Click Finish Once finish it will run the query and display the results
17.Once this is done.
Now its Time to make the report available in Application Login to Application Developer->Function
18.Enter Function , User Function Name, Description(Optional) in Description Tab
19.In Properties Tab
Select Type acœSSWA plsql function
Maintenance Mode Support ac“ None
Context Dependence - Responsibility
20.in Form Tab enter parameters
21.In Web HTML Tab
Enter HTML Call - OracleOasis.RunDiscoverer
22.Add the Function in Any existing or new Menu.