Buy file upload on Oracle EBS R11

[elton.souza]

Good morning people.

I need to develop a customization in Oracle EBS R11 that imports a local machine file into the application. Can anyone tell me a practical and quiet way to solve this problem? I'm waiting;

Thanks

[dr_gori]

I believe the easiest way to do this is to use Attachments.
Note that there is a clip in Toolbar. http://crmweba.wgresorts.com/wiki/image ... hments.pdf and http://docs.oracle.com/cd/E18727_01/doc ... 458262.htm
Ali serves for you to attach things.
You can create a program that allows attachments.
In my opinion, it's the easiest way.

The file will be available in fnd_lobs ;

There are some packages, API to take care of this:

Select all

fnd_attached_documents_pkg 
fnd_webattch.add_attachment

I have a program that does the opposite of what you need:
He picks up files from a directory on the server and creates a row in the Attachments of an inventory item.
(In case, it is the figure of the inventory item). I'll post here, maybe help.

Select all

declare 
  l_blob blob := EMPTY_BLOB(); 
  l_bfile bfile; 
  l_rowid varchar2(50); 
  l_attac_doc_id number; 
  l_document_id number; 
  l_user_id number := fnd_global.user_id; 
  l_media_id number; 
  l_file_id number; 
  lv_exists number:=0; 
  lv_name varchar2(100); 
  lv_dir varchar2(100); 
  v_access_id   NUMBER; 
  x_access_id   NUMBER; 
  v_file_id     NUMBER; 
  x_file_id     NUMBER; 
  x_errbuf      VARCHAR2 (200); 
  v_filename VARCHAR2 (200); 
begin 
-- fnd_global.apps_initialize (1318, 20420, 1); 
 
   for C in (select attribute2, SEGMENT1, INVENTORY_ITEM_ID from MTL_SYSTEM_ITEMS_B  
             where segment1 = '0060527' 
             and organization_id = 84) loop 
              
     l_bfile := bfilename( 'DIR_PICTURES', nvl(c.attribute2,c.segment1)||'.jpg');   
     LV_EXISTS := DBMS_LOB.FILEEXISTS(L_BFILE); 
     DBMS_LOB.FILEGETNAME(L_BFILE, LV_DIR, LV_NAME); 
 
      if LV_EXISTS = 1 then    
          -- 
          L_ROWID := null; 
          --    
          select APPLSYS.FND_ATTACHED_DOCUMENTS_S.NEXTVAL 
            into L_ATTAC_DOC_ID 
            from DUAL; 
          -- 
          l_document_id := null; 
          L_MEDIA_ID := null; 
          V_ACCESS_ID := FND_GFM.AUTHORIZE (null); 
          X_ACCESS_ID := V_ACCESS_ID; 
          --             
          fnd_attached_documents_pkg.insert_row(l_rowid, 
                                     l_attac_doc_id, 
                                     l_document_id, 
                                     sysdate, 
                                     l_user_id, 
                                     sysdate, 
                                     l_user_id, 
                                     null,                          -- last update login 
                                     999,                            -- seq num 
                                     'MTL_SYSTEM_ITEMS', 
                                     null,                          --column1 
                                     '84', --pk1_value 
                                     to_char(c.inventory_item_id), 
                                     null,null,null,           -- pk*_value 
                                     'N',                           -- Automatic Added 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     null,null,null,null,                                
                                     -- 
                                     6,             -- DATATYPE_ID 
                                     1,             -- CATEGORY_ID         
                                     1,             -- secutity_type 
                                     84,          -- security_id  
                                     'Y',           -- publish_flag 
                                     null, 
                                     null, 
                                     'O', -- usage type 
                                     'PTB', 
                                     null, 
                                     lv_name, -- FILENAME 
                                     l_media_id, 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     null,null,null,null, 
                                     'N', 
                                     null, 
                                     null );                                 
                                     -- 
                                     delete FND_LOBS_DOCUMENT 
                                     where name = lv_name; 
                                    -- 
                                     insert into fnd_lobs (file_id, file_name, file_content_type, file_data, 
                                                           LANGUAGE, ORACLE_CHARSET, FILE_FORMAT) 
                                     values (l_media_id, lv_name, 'image/jpeg', EMPTY_BLOB(), 'PTB','WE8MSWIN1252','binary' ) 
                                     returning FILE_DATA into L_BLOB; 
                             
                          -- 
                          DBMS_LOB.FILEOPEN( L_BFILE ); 
                          DBMS_LOB.LOADFROMFILE( L_BLOB, L_BFILE, DBMS_LOB.GETLENGTH( L_BFILE ) ); 
                          DBMS_LOB.FILECLOSE( L_BFILE );   
                           
               commit; 
         else  
           rollback; 
        end if; 
    end loop; 
end; 
/ 

may have a fully customized thing in Java (OAF), but I believe it's much worse.

[elton.souza]

Friend, good afternoon. How are you?

So it's next, what you explained me already gave me a light but I saw that it is possible to do this with Open Dialog, that is, opening a dialogue box on the windons, only researching On the net I found some solutions and the code is giving a bug in this trigger (when-custom-item) in Forms 6 saying that it is necessary to declare it, checking I saw that it does not have this trigger in the list of triggers of the item. Do you know if I have to install any lib or something?

Thanks and I'm waiting.

Hugs

[dr_gori]

I think this is a custom trigger. (Not standard). The EBS has it.
Are you using an EBS template to create this form?

[elton.souza]

Hello good day. Yes I used an EBS tam to create this forms. However this functionality of making the Open Dialog of the file into the EBS I have verified that in the HR module in the people registration it is possible to do this when it will register the photo of the official. Thinking about it I got this forms from the HR module on the application server and I'm trying to do the same thing in my forms following the same idea, but it's giving this mistake a lot of stretching the trigger should be declared. Do you have any idea?

Thanks

[dr_gori]

Can you tell me if in the HR module it opens a screen forms to upload?
usually to do this kind of thing is fired a java screen. (as in the case of attachments)

[elton.souza]

The process in HR occurs as in the Annex: it is a forms that opens. And I need to do just that in my custom forms.

[dr_gori]

I had never seen a screen like that in EBS. I always thought every file upload was made by Java screens. (Living and learning! )

So it seems that this program uses Webutil. (which is the new d2kwutil).
I think the way is to look at what's inside that button, see even using Webutil. (I always thought it was not installed in EBS). Then give me the name of this program, I was curious. I'll open it here!

If the case, here is an example of upload using Webutil. (But I do not think so). https://sites.google.com/site/craigsora ... into-forms

[elton.souza]

So friend, because it is in EBS R12 is through Java screens even, but in EBS R11 does not have this functionality. The functionality is the way I showed you in the Annex. I had read something air respect from this UMLIL web, but I could not understand very well what it is and how to install .... could you give me a more detailed explanation about it?

Thanks