I tried to attach document(CV) for the applicant in R12.But it cannot be viewed though the document is attached.In the package i am getting null value for v_media_id from fnd_gfm.confirm_upload API call.Record is not getting created in the fnd_lobs table.But when v_access_id := fnd_gfm.authorize (NULL); call
I am getting the access_id and new record in fnd_lob_access table with null value for file_id.
v_media_id := FND_GFM.confirm_upload(access_id => p_access_id,
file_name => v_filename,
program_name => 'ADD_ATTACHMENT'