Once you make all the changes that you want to make, you are almost ready to upload all your changes to the web application.

Review the Change column in your layout. You'll see a message for each row marked for change: Create for new rows, Update for changed rows, and Delete for rows marked for deletion. If you have performed an action on a row, the Change cell for the row will indicate the action to be performed (such as Approve for an expense report) on the next upload.

When you are ready, click the Upload Changes button from the Oracle Visual Builder Add-in for Excel tab. The add-in performs all the requested operations, as indicated in the Change column. When the upload has completed, the add-in displays an Upload completed message in the Status Viewer and status messages for each processed row in the Status column of the table.

Review the Status column to see which rows succeeded and failed. You might see status messages such as Create Succeeded, Update Failed, Delete Failed, and Skipped. Skipped means that a row marked for update had no changes and was not included in the upload.

In this example, the Status column displays a Create Failed message in the cell of a row that the add-in failed to create. You can review the Selected Row Status in the Status Viewer for additional information on the failure. Here, a required value for Hire Date was not entered. Enter a hire date and click Upload Changes to try and upload the modified data again.

Successfully deleted rows are removed from the Excel worksheet while failed attempts to delete a row result in the row remaining in the Excel worksheet. You can inspect the reason for the failure to delete in the status in the Status Viewer.

Some web applications may issue warning messages for successfully uploaded rows. The message in the Status column contains an indication that there were one or more warnings for that row. Select a row with a warning icon to display details of the warning in the Status Viewer.

In some cases, your workbook may be configured to upload all changes to a parent row and its descendant rows (child rows, grandchild rows, and so on) in the same request. If this is the case for your workbook, then the add-in can only successfully upload your changes if there are no errors in any of the associated rows.

If there are one or more errors in a set of changed rows, those rows and their associated rows are marked as failed. To troubleshoot the error, review the errors in the Status Viewer for each form, table, and descendant table in your workbook. Once you've fixed the errors in the pending changes, you can retry the upload operation.