1. Managing Data Using Oracle Visual Builder Add-in for Excel
  2. Manage Data in Table Layouts
  3. Data Consistency

Data Consistency

The add-in helps prevent multiple users from overwriting each other's changes.

Consider this scenario:

  1. Person A downloads information from a business object into a table in their integrated workbook.
  2. Person B downloads the same information into a table in their integrated workbook, edits it, and uploads changes.
  3. Person A then edits the same information (downloaded in Step 1) and uploads the changes.

  4. The add-in provides the service with the necessary information to prevent Person A's changes from overwriting those changes made by Person B. Instead, when the server detects such a change, its response allows the add-in to display an error message similar to the following for any such rows in the table: 

    This row has been modified by another user. Please download before editing.

    If you see this message, you'll have to discard your changes by downloading the latest data and then redoing your changes as needed.

Note:

Some services do not support this conflict detection functionality. If the service does not, then Person A's changes will replace Person B's changes with no warning. Contact the service owner for more information.