How to use Attachment APIs 1. Create Directory - Optional CREATE DIRECTORY test as '/home/oracle/' Grant all on directory test to public 2. Upload file to the location / Identify the location of the Document to be attached 3. DECLARE l_rowid ROWID ; l_attached_document_id NUMBER ; l_document_id NUMBER ; l_media_id NUMBER ; l_category_id NUMBER ; l_pk1_value fnd_attached_documents.pk1_value% TYPE := 747085 ; ----<Primary Key information that uniquely identifies the product (such as the product_ID)>; l_description fnd_documents_tl.description% TYPE := 'Test Attachment' ; l_filename VARCHAR2 ( 240 ) := 'FNDWRR.pdf' ; --'cost allocation code.txt'; --'<File Name>'; l_file_path varchar2 ( 240 ) := 'test' ; ---'SALE_INVOICE_PATH'; --Server Directory Path for upload files l_seq_num NUMBER ; l_blob_data BLOB ; l_blob BLOB ; l_bfile BFILE ; l_byte NUMBER ; l_fnd_user_id NUMBER ; l_short_d...