To upload data from a spreadsheet using Web ADI:You can upload data to the Oracle applications database using a spreadsheet created in Web ADI. See: Data Upload Using Web ADI
To upload data from a spreadsheet using Web ADI:If you have saved the spreadsheet on your local PC, locate and open the spreadsheet in Excel.
In the Upl column of the spreadsheet, each row in which you have changed data in any field is flagged for upload. As you change data in a field, the row is flagged for upload.
Select the Oracle menu on the Excel toolbar, and choose Upload.
If you are not already logged in to Oracle applications, a login page appears. Enter your user name and password, then choose the Login button.
In the Set Responsibility page, choose your responsibility, and then choose Select.
In the Upload Parameters page, choose the Parameters button. If you want to upload flagged rows only, choose the Flagged Rows option button. To upload all rows (for example, if uploading from a text file), choose the All Rows option button.
Choose the Proceed to Upload button, then choose the Upload button in the page that appears next. The upload takes place, and a series of upload messages is displayed, indicating the success or failure of the upload.
If the upload fails, return to the spreadsheet and correct any errors, then retry the upload. Further details of errors are available in the Messages column at the end of each row of the spreadsheet. If the upload is successful, the data is uploaded to the database. Confirmation messages indicate the success of the upload.
Note: Web ADI uploads all rows to the database if the data is error-free. If any errors occur, no rows are uploaded.