Download attachments in bulk
I use the following script to identify the file id required in the FNDGFU utility to be able to download the attachment.
select distinct pha.PO_HEADER_ID,
pha.AGENT_ID,
pha.TYPE_LOOKUP_CODE,
pha.SEGMENT1,
pha.VENDOR_ID,
pha.ATTRIBUTE2,
pha.ATTRIBUTE10,
fadfv.SEQ_NUM,
fadfv.CATEGORY_DESCRIPTION,
fadfv.DOCUMENT_DESCRIPTION,
fadfv.DATATYPE_NAME,
fadfv.FILE_NAME,
fadfv.ATTACHED_DOCUMENT_ID,
fadfv.USER_ENTITY_NAME,
fadfv.DOCUMENT_ID,
fadfv.PK1_VALUE,
fadfv.MEDIA_ID,
fl.FILE_ID,
fl.FILE_NAME
from po_headers_all pha,
FND_ATTACHED_DOCS_FORM_VL fadfv,
FND_LOBS fl
where pha.PO_HEADER_ID = fadfv.PK1_VALUE