Page 1 of 1

Dataload (natural accounts)?

Posted: Mon Jul 30, 2007 3:38 am
by headboy
I am trying to upload natural accounts segment vaues into Oracle GL R11 using dataload.

The problem is that all the columns in dataload are being dumped into one column in GL i.e. the column highlighted

For example, if the cursor in GL is in value, dataloads populates it with all the values e.g. value, description, translated value etc.

Help

Posted: Mon Jul 30, 2007 5:06 am
by cnubandi
Hai ,
You have to give tabs for each cursur movement.
try this .....
*IR 01 TAB Rent TAB TAB TAB TAB TAB TAB TAB TAB EXPENCE TAB TAB TAB SAVE

Posted: Mon Jul 30, 2007 4:55 pm
by headboy
Thanks cnubandi,

Your solution works until the upload gets to the 'EXPENSE' tab where it gets stuck because it tries to select 'YES' which is not an option. This is despite the fact that i've got 'EXPENSE' not 'YES' in the dataload file.

Thanks

Headboy