How do I create a report that lists attachments?

While there's no subject area for you to use in creating a BI report on attachments, you can use Oracle BI Publisher to get the information.

Sign in to BIP and use the below query.

Select ENTITY_NAME,count(*)

FROM FUSION.FND_ATTACHED_DOCUMENTS

WHERE ENTITY_NAME not in ('ESS_REQUEST_HISTORY','ZCA_EXP_BATCHES','MKT_CM_CAMPAIGNS','MKT_IMP_JOBS','MKT_TM_TREATMENTS','MOO_STG_B')

Group by ENTITY_NAME

Other columns of interest in FND_ATTACHED_DOCUMENTS are 

Object Type

ENTITY_NAME

Object Id

PK1_VALUE

AttachmentId

ATTACHED_DOCUMENT_ID

Document Id

DOCUMENT_ID

 

The other table which can tells file name with extension is

select a.ENTITY_NAME,a.PK1_VALUE,a.ATTACHED_DOCUMENT_ID,

        d.DOCUMENT_ID ,d.TITLE ,d.DM_DOCUMENT_ID ,d.FILE_NAME

FROM FUSION.FND_ATTACHED_DOCUMENTS a ,FUSION.FND_DOCUMENTS_TL d

Where a.DOCUMENT_ID = d.DOCUMENT_ID

and a.ENTITY_NAME not in ('ESS_REQUEST_HISTORY','ZCA_EXP_BATCHES','MKT_CM_CAMPAIGNS','MKT_IMP_JOBS','MKT_TM_TREATMENTS','MOO_STG_B')