We can use standard file attachment functionality to transfer file into Apps from users desktop and can call that file in your custom package.This way you can elimiate the ftp between client and server.Also, we can avoid giving unix access to users.
Step1:
Create a customer from to call attachment functionality
Step2:
In the attachment button , call FNDATTCH with pk1 value as parameter ( select unique sequence)
Oracle upload the file into fnd_lobs table with unique file id, you can get file id from fnd_attached_docs_form_vl using the unique id you supplied.
Please leave me comment if you need more information or procedure to read lob column
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment