Updating the database

After you update the data in a set, you must perform the final update to update the records in the database table.

Extraction records with a Status Type of Pending are processed individually in this order, based on the Status Operation:

  1. Update

    Only the fields that meet this criteria are updated:

    • The field was selected on the Extracted Columns page.
    • The value of the field was changed through the mass maintenance function.
  2. Create
  3. Delete

If an extraction record is successfully processed, the Status Type changes to Complete. If an error occurs, the Status Type changes to Errors. The error is displayed in the Errors column.

These are some circumstances under which an error can occur:

  • You attempt to delete a record that cannot be deleted, based on standard logic for that type of record. For example, you cannot delete a ARSC-Customer Master record if the customer has active transactions or open balances.
  • The record contains bad data. An error can occur even if the bad data was not included in an extraction column for the set.

Errors can also occur because of values that are not in your database. The ICSC-Catalog Master table is not company-specific, but many of the fields in the table are entities that are company-specific, such as vendor number. The company in which the set was created is used for validation, but errors can occur for values that do not exist in the company. To correct this type of error, you must update the catalog record with your company-specific value.

If errors occur, the record in the database table is not updated. You can correct the error, reset the error status on the record, and then perform the final update for the corrected records. When you reset the error status, the Status Type changes to Pending.