Technology Stack - EBS (MOSC)

MOSC Banner

how to export/download actual attachment files ( pdf's , rtf', GIF etc ) from FND_LOBS table?

edited Aug 20, 2021 11:37AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi ,

We are archiving our attachments from fnd_lobs to a different reporting system.( attachments to PO's, Invoices etc )

how do i export/download actual attachment files ( pdf's , rtf', GIF etc ) from FND_LOBS table?

i have extracted the details of the files like file_id,file_path,file_name etc.but how to get the actual files?

i tried exporting from sql-developer in loader format, it does export the files but in a LDR format ,not in a readable original format. its useful only for loading into target system.

but we are not going to load them on target system, we are just going to store them in a sharepoint like system.

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