Page 1 of 1

load data from excel to oracle apps

Posted: Mon Mar 29, 2010 4:09 am
by lincyj
hi

is it possible to load data from excel into oracle apps ie to the responisbility INV ABC Super user-Items-Mater I tems

kindly someone help me


thanking in advance

regards
oracleuser[:(][:(]

Posted: Mon Mar 29, 2010 8:22 am
by oteixeira
Hello.

Do you mean to load the data from Excel into Oracle Forms?

Octavio

Posted: Mon Mar 29, 2010 8:36 am
by lincyj
hi

yes from excel to the form in oracle apps

i tried downloading dataloader classic version but then don't know how to use ,i mean when the flexfield in the form is filled ,the data loader is not able to proceed to next item i tried command \%F%V(save and proceed) still not able to proceed
kindly help

Posted: Mon Mar 29, 2010 8:50 am
by AmanKhan
HI,

You can use WEBADI to upload data for others Dataload is good tool.

let us know, in which form u want to place data...

Regards,

Posted: Mon Mar 29, 2010 9:23 am
by lincyj
hi

i have dataloader classic version with me ,i need to take data from excel sheet and put it in INV ABC SuperUser-Item-Master item

as mentioned before i get stuck at flexfield

kindly help

thanking in advance

Posted: Mon Mar 29, 2010 10:28 am
by oteixeira
Hello.

Probably you are not filling in all the requested data. Do you see any message at the bottom? Execute Dataload in Step Mode to see what is failing.

Octavio

Posted: Tue Mar 30, 2010 2:11 am
by lincyj
hi
i tried loading sampe data into forms in test server and
the issue i am facing is ,when i tried to load the data to the form ,the flex field also gets populated and the flexfield window has options of OK,CANCEL... i mean how is the loader supposed to know after populating flex field it is supposed to move to the next item in form

eg the form has the following fields

item

item number

item description []

abc

i mean after item field and item number the item description flex field gets populated ,the loader just stayed in the flexfield window and gave the message "data loaded successful" it did not populate the next field abc
i tried giving /[%F%V] which means "save and proceed" but still it stops in the flexfield window
i gave the above keystroke from edit-commands for ebs 11i in dataloader

kindly help me

Posted: Tue Mar 30, 2010 4:17 am
by AmanKhan
use tab command to decide to move to next field in the form.
Use enter command on Flexfield after filling the data.
just save data once after u fill all fields on specific form.