How to list discoverer documents by user access log

List user access log on discoverer documents and sheets

SELECT b.user_name Doc_Owner
               ,a.doc_name
               ,a.doc_developer_key
               ,c.QS_DOC_NAME
               ,c.QS_DOC_DETAILS
               ,d.user_name accessed_by
               ,QS_CREATED_DATE
FROM <schema name>.EUL5_DOCUMENTS a
            ,fnd_user b ,
           ,<schema name>.EUL5_QPP_STATS c ,
           ,fnd_user d
WHERE a.DOC_CREATED_BY <> 'ORACLE_APPS'
AND '#'||TO_CHAR(b.user_id) = a.DOC_CREATED_BY
AND a.doc_name = c.QS_DOC_NAME
AND '#'||TO_CHAR(d.user_id) = c.QS_CREATED_BY

ORDER BY QS_CREATED_DATE DESC 

How to list All User Created Discoverer Worksheets Using SQL statements

Below query can display, all discoverer documents created by any user with dates.

SELECT b.user_name Doc_Owner
             , a.doc_name
             , a.doc_developer_key
             , a.DOC_CREATED_DATE
             , a.doc_updated_date
FROM <schema name>.EUL5_DOCUMENTS a
           , fnd_user b
Where a.DOC_CREATED_BY <> 'ORACLE_APPS'
AND '#'||TO_CHAR(b.user_id) = a.DOC_CREATED_BY

Unable to connect to the Discoverer Server: null..

Unable to connect to the Discoverer Server (10g or Higher):


Could not initialize class

oracle.disco.model.xml.ModelElementToClassMapper

Please contact your Oracle Application Server administrator
 
Solution:
Clear the temporary internet files and cookies and java cache


Steps to clear java cache:



1.Go to Start > Settings > Control Panel and click the Java icon.

2. Click on 'Settings'
3. Delete files

4. Close all browsers

5.Open new browser and test it
 
OR 
close all browsers and delete all files from "C:\Users\<>\AppData\LocalLow\Sun\Java\Deployment\cache".
 
 
(<> replace this with your windows login name)