We have implemented R.12 we have already migrate data from legacy to EBS but during go live period many transaction cannot be record.
I have data in excel I want to upload. What is the best & save way please let me know.
EBS Coordinator I.C.T
what it's the data structure of your data
because is more easy to write a PL/SQL code to load Data from youre source Data
1- open the file
2- organise the read of file (read until the first blanc charcter for exemple and then use DML instucion to insert into your table)
The easiest way to upload data into a table from excel is to use Import Data feature of SQLDeveloper.
What you need to do is :
Right-Click on the table name in the Navigator.
Select Import Data
Choose the excel file you want to load the data from.
Map the columns of the xls file to the columns in the table