Technology Stack - EBS (MOSC)

MOSC Banner

Download attachments in bulk

edited Aug 20, 2021 11:20AM in Technology Stack - EBS (MOSC) 1 commentAnswered
 Dear all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center