I'm sure the answer is 'No, of course not.'

But thought I'd ask!!

Hi Geoff,

I don't think so this can be retrieved ,reason for this is Disc report is a extract of data from the system. I doubt there will be any meta data definitions updates for every run??


Regards
Krishna Prasad Rapolu

Inexplicably, they won't take 'No'for an answer here in the lovely window frame works in Holland. Anyone know of any audit tables perhaps that might be used to log this?

I humbly offer for your delectation and delight the following piece of PL/SQL

Those who know me can be assured that I played no part whatsoever in the production of this!!!!!!!!!!!
---------------------------------------------------------------

SELECT doc.doc_name "Workbook Name",
NVL(doc.doc_description,'No description') "Description",
usr.user_name "Owner",
usr.description "Owner's Name",
TO_CHAR(qs_created_date, 'RRRR') "Run Date" ,
count(*) "Number"
FROM eul4_us.eul5_documents doc,
eul4_us.eul5_qpp_stats qs,
apps.xxfnd_user usr,
hr.per_all_people_f ppf
WHERE qs.qs_doc_name = doc.doc_name
AND doc.doc_content_type = 'application/vnd.oracle-disco.wb'
AND usr.user_id = substr(doc.doc_created_by,2,10)
AND ppf.person_id(+) = usr.employee_id
AND sysdate between ppf.effective_start_date(+) and ppf.effective_end_date(+)
GROUP BY doc.doc_name ,
NVL(doc.doc_description,'No description') ,
usr.user_name ,
usr.description ,
TO_CHAR(qs_created_date, 'RRRR')
ORDER BY 6 desc

Hmm, most enlightening Mr Dixon

However, may I refer you (or indeed the original author) to this J&J Archive for a compelling reason to use 'trunc(sysdate)' in the where-clause rather than just 'sysdate'.

And yes, I do know you well enough to know you could not have written that! Great post though, nice one!

Edit: Questions for the originator - What is the object XXFND_USER? Is that some custom view or table based on the standard table FND_USER? Also, on an instance what I have just had a look at, all the tables owned by EUL4_US start with EUL4_, not EUL5_. Is there some special reason why I don't have disco tables starting EUL5?