Overview

Use SA Mass Maintenance Administration to perform mass maintenance of records in your Distribution SX.e database tables, and the associated table data in your database.

Using the mass maintenance function, you can extract copies of records from a database table into a set. You can change, add, or delete extraction records within the set, and then perform a final update to update the records in the database table. Standard rules and validations apply, based on the table.

You can perform some operations that are associated with mass maintenance in SA Mass Maintenance Administration. You can also use Microsoft Excel to change data and add records to a set, but the associated export and import operations are performed in SA Mass Maintenance Administration.

The SA Mass Maintenance Utility Report is a background process that is performed through Report Scheduler. The report executes most operations that you perform in SA Mass Maintenance Administration. The report also generates output that contains information about the operation, such as record counts, processing times, and errors. Review the report after you perform an operation to verify that the records were processed correctly. The SA Mass Maintenance Utility Report is not intended to be run as a separate report.