All discoverer folders and workbooks that you create get stored in database. You can use the below queries to find the details.
Find your Discoverer Workbook and Folder Details from Database:
select  fu.user_name owner,
doc.doc_id "Document Id",
doc.doc_name "Document Name",
doc.doc_developer_key,
doc.doc_folder_id,
doc.doc_created_by,
doc.doc_created_date,
doc.doc_updated_by,
doc.doc_updated_date,
min(qs.qs_created_date) first_acc,
max(qs.qs_created_date) Last_Acc
from disco_apps.eul5_documents doc,
apps.fnd_user fu,
disco_apps.eul5_qpp_stats qs
where '#'||fu.user_id = doc.doc_created_by
and qs.qs_doc_name=doc.doc_name
and qs.qs_doc_owner=fu.user_name
and doc.doc_created_date<qs.qs_created_date
group by fu.user_name,
doc.doc_id,
doc.doc_name,
doc.doc_developer_key,
doc.doc_folder_id,
doc.doc_created_by,
doc.doc_created_date,
doc.doc_updated_by,
doc.doc_updated_date
order by doc.doc_updated_date desc;

Find your Discoverer Workbook performance for different Business Areas:

select  ba.ba "Business Area",
usr.user_name,
doc.doc_name "Work Book",
min(qs_act_elap_time) "Fastest",
max(qs_act_elap_time) "Slowest",
round(avg(qs_act_elap_time),2) "AVG (s)",
round(avg(qs_act_elap_time)/60,2) "AVG (m)",
count(*) "Often",
doc.doc_created_date,
min(acc.qs_created_date) "First",
max(acc.qs_created_date) "Last Access"
from disco_apps.eul5_documents doc,
apps.fnd_user usr,
disco_apps.eul5_qpp_stats acc,
(select distinct gd_doc_id from disco_apps.eul5_access_privs ) privs,
(
select distinct doc.doc_id,ba.ba_name ba
from disco_apps.eul5_documents doc
,disco_apps.eul5_elem_xrefs eex
,disco_apps.eul5_ba_obj_links bol
,disco_apps.eul5_objs obj
,disco_apps.eul5_bas ba
WHERE doc.doc_id = eex.ex_from_id
AND eex.ex_to_par_name = obj.obj_name
AND obj.obj_id = bol.bol_obj_id
AND bol.bol_ba_id = ba.ba_id
)ba
where '#'||usr.user_id=doc.doc_created_by
And doc.doc_name=acc.qs_doc_name
And privs.gd_doc_id = doc.doc_id
And usr.user_name = upper(acc.QS_DOC_OWNER)
And doc.doc_created_date<acc.qs_created_date
And doc.doc_id=BA.doc_id
group by ba.ba,
usr.user_name,
doc.doc_name,
doc.doc_created_date;

Oracle Business Intelligence 10g Release 2, a key component of Oracle Application Server 10g Release 2, is an integrated business intelligence solution supporting intuitive ad hoc query, reporting, analysis, and web publishing. Discoverer 10.1.2 is tightly integrated with Oracle E-Business Suite Release 12.  Release 12 users can use Discoverer to analyze data from selected business areas in Financials, Operations, and Human Resources etc.
The following are the Discoverer 10g Installation steps for Oracle R12 environment.

1] Install Oracle Business Intelligence Tools 10g (10.1.2.0.2) using below link

First right click on the zip file (as_windows_x86_bi_tools_101202). Extract all to a directory on your PC. Click on the Extracted folder which has the same name (as_windows_x86_bi_tools_101202). Click on the 10g set up icon and follow only the default settings. This installation creates a home “BIToolsHome_1” (If Default location is selected during install).

2] Apply the latest certified Discoverer Plus and Viewer Patches

To upgrade to Oracle Discoverer 10.1.2.2 – Apply the patch: 4960210
To upgrade to Oracle Discoverer 10.1.2.3 – Apply the patch: 5983622
Follow the installation instructions provided in the patch README to install the patch on your Discoverer 10g Server and to check supported operating systems.

3] Copy Database Connection file

Discoverer needs access to the Database Connection (dbc) file for the database you wish to connect to. A dbc file is a text file which stores all the information required to connect to a particular database.
First identify the Oracle Home for Discoverer. For example: If you could find dis51usr.exe under the directory D:oracleBIToolsHome_1bin. Then the Oracle Home is D:oracleBIToolsHome_1
Create a folder named “secure” in the ORACLE_HOME directory (i.e. D:oracleBIToolsHome_1Secure).
Then copy the dbc file from the $FND_SECURE directory of the E-Business Suite Release 12 instance you are setting up Discoverer with to the Discoverer 10.1.2 “ORACLE_HOMEsecure” directory you just created.
Save the dbc file in lowercase.

4] Update tnsnames.ora file

On your standalone Oracle Business Intelligence Server 10g Release 2 node, update the file ORACLE_HOME/network/admin/tnsnames.ora and include the tnsnames entry to connect to your Oracle E-Business Suite Release 12 database. Use the same entry as exists in the tnsnames.ora file on your Oracle E-Business Suite Release 12 application tier server node.

5] Set the Environment

Discoverer requires Windows Environment variables to dynamically retrieve the location of the .dbc file on the PC.
Open Windows Control Panel and double click on the System icon. Select the Environment tab and create two new System Variables.
FND_SECURE = ORACLE_HOMESecure
FND_TOP= ORACLE_HOME
Note: The Oracle Home is the one identified in step 3.
6] Restart the PC and you should be able to connect to Discoverer in an Oracle Applications mode.
Note: When you are connecting to Discoverer for the first time, then Goto Tools > Options. Check the proper EUL in the Connection Tab.
For More Detailed Information Please refer the below metalink note:
Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12 [ID 373634.1]

How to run Discoverer Reports in Multi-Org Environment?

When you are working in R12 MOAC environment, sometimes discoverer reports which are based on some context based view will not give data. Then do the following setup to make the discoverer reports work in MOAC environment.
1)      Create a Security Profile in HR
1)      Run concurrent program Security List Maintenance

1)      Tag this profile to MO: Security Profile option at responsibility level.
1)      Update profile option “Initialization SQL Statement – Custom” with following pl/sql block at responsibility level.
begin if (fnd_profile.value(‘XLA_MO_SECURITY_PROFILE_LEVEL’)= 0) then mo_global.init(‘S’); else GL_SECURITY_PKG.init(); mo_global.init(‘M’); end if; end;
When multiple organizations are included in Security Profile: TEST SECURITY PROFILE, This profile is attached to resp Discoverer EUL Management.