How to Store Image/PDF Attachments on the File System (like Attachment file directory)

Dear All,

From 11i oracle store images/PDF attachments in the FND_LOBS table instead of file system. but there are still a requirement to store the attachments in the file system to manage file system space in better way.

there a way to store attachments in the file system in 11i/r12 version.

attachment windows (form) in oracle application.

in the attachment form there a field called DATA TYPE, there is two value of DATA TYPE FIELD.

1. FILE

2. WEB PAGE

If you want to store images in the file system then select the DATA TYPE as WEBPAGE and give the mapped network sharepoint address like above mentioned.

z: is a mapped drive of network sharepoint.

same like you can give the URL of ftp and http like below

for ftp

select data type as webpage

and give the file/URL as follow

ftp://doc.mycompany.com/image.jpg

for http

select data type as webpage

and give the file/URL as follow

http://doc.mycompany.com:8020/myfiles/image.jpg

you can check the attachment successfully stored in the file system by click on OPEN DOCUMENT BUTTON.

for more info check metalink note: 294525.1