You can use Web ADI to upload data that you have previously downloaded to a spreadsheet, or data that you have entered in an empty spreadsheet. You can do this only if the spreadsheet was created using an upload integrator.
Note: When you upload data from a spreadsheet, you have to select the appropriate security setting for macros in Microsoft Excel. See: Selecting Macro Security Settings in Microsoft Excel topic in the Oracle Web Applications Desktop Integrator Implementation and Administration Guide
You can only upload data using an integrator that has been created for this purpose (for example, the HR Update Salary Proposals integrator available from the Salary Management folder). You must specify at the time you download the data that you intend to upload it again, by unchecking the Reporting check box. You must also have access to a responsibility that gives you access rights to upload data as well as download it.
Data to be uploaded is validated before the upload occurs. You must ensure that you enter values in all mandatory fields, so that validation is successful when the data is uploaded to the application. If you do not, the data is not uploaded, and an error message appears in the Messages column in the spreadsheet for the record with the invalid data.
For example, if you are using the HR Update Salary Proposals integrator, you must enter values in the Proposed_salary and Change_date fields, as a minimum, for any row you want to upload. If your organization has created its own integrators for uploading data, your system administrator can tell you which fields you must enter.
When you change any field in the spreadsheet, the row is flagged for upload. By default, only flagged rows are uploaded. You can change this setting so that all rows are uploaded.