Search This Blog

Thursday, May 7, 2009

How to query/find discoverer reports in Oracle using APPS Schema

The table to store discoverer is stored in the EUL Schema. For e.g. if the name of EUL is EUL4_US then a schema with that name will be created in oracle database. Run following query to know the name of table

 SELECT owner,table_name
FROM all_tables
WHERE owner = 'EUL4_US' AND table_name LIKE '%DOCUMENT%'


The above query in this case will list table_name EUL4_DOCUMENTS

All the discoverer report names are stored in this table, so
SELECT * FROM EUL4_US.EUL4_DOCUMENTS
should display name, owner etc of discoverer reports

4 Comments:

Sahil said...

The query made my task so easy.
Thanks

Anonymous said...

That assumes that one knows the EUL...

Try this:
SELECT OWNER, TABLE_NAME
FROM ALL_TABLES
WHERE OWNER LIKE '%EUL%'
AND TABLE_NAME LIKE '%DOCUMENT%'

Anonymous said...

Actually, I just found that we also have OWNER = 'DISCOVERER'.

Maybe just look for like %DOCUMENT% and look for reasonable OWNER's

فلاطون said...

Right on!
Thank you,
I was looking for the list of reports in Disc EUL

..masoud

Copyright (c) All rights reserved. Presented by Suresh Vaishya