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
Buy file upload on Oracle EBS R11
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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:
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.
may have a fully customized thing in Java (OAF), but I believe it's much worse.
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:
fnd_attached_documents_pkg
fnd_webattch.add_attachment
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.
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.
-
- Rank: Programador Pleno
- Posts: 38
- Joined: Wed, 30 Jan 2013 6:22 pm
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
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
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I think this is a custom trigger. (Not standard). The EBS has it.
Are you using an EBS template to create this form?
Are you using an EBS template to create this form?
-
- Rank: Programador Pleno
- Posts: 38
- Joined: Wed, 30 Jan 2013 6:22 pm
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
Thanks
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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)
usually to do this kind of thing is fired a java screen. (as in the case of attachments)
-
- Rank: Programador Pleno
- Posts: 38
- Joined: Wed, 30 Jan 2013 6:22 pm
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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
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
-
- Rank: Programador Pleno
- Posts: 38
- Joined: Wed, 30 Jan 2013 6:22 pm
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
Thanks
-
- Information
-
Who is online
Users browsing this forum: No registered users and 2 guests