Operator knowledge and skill requirements

Restrict security to system administrator- or database administrator-level operators who meet knowledge and skill requirements. The mass maintenance functions allow an operator to perform the steps needed for Mass Maintenance of master database tables and transactional database tables.

Use of these mass maintenance functions requires the operator have a solid understanding of the Distribution SX.e database table structure and schema [data dictionary]. The operator must make decisions as to how master and transactional database table source records are to be extracted and manipulated. The operator must also understand the ramifications of changing data in the database.

The user interface for these functions provides flexible lists of database column information. Therefore, the operator must also have a solid understanding of the domain of values for common fields; for example, Warehouse, Terms, Ship Via, Sales Reps. The operator must access the appropriate menu function to check the list of valid values. This is required to perform various steps within the Mass Maintenance processes.

The operator must also discern when another tool would be better to use for some changes. For example, when creating new order entry records, it is more prudent to use the SXAPI call, sxapiOEFullOrderMnt*. This allows header and line items, and other related data, to be sent in one call.

We recommend that you develop your own company-wide guidelines and restrictions to use mass maintenance based on your operations, business hours, performance requirements, and database.