Data Correction Self-service - Support for Orphan Record Deletion

The new Data Correction Request Root, Orphan Record Deletion, and Orphan Record Deletion Type business objects can be used together to create a request to process orphan records. In addition, there are new Backup Table Cleanup and Backup Table Cleanup Type business objects to deal with the backup tables created by the deletion request. The following points highlight features supported by these new objects:

• The Orphan Record Deletion Type defines the parameters for the deletion request, including whether to verify record counts before performing deletion and whether a backup cleanup request should be created.
• The Data Correction Request Root and Orphan Record Deletion business objects define the steps in the deletion process, including:
  • Capturing the table with orphan records, and the number of records affected.
  • Generating the SQL to perform deletion directly in the database.
  • Sending the data correction request to another user for approval.
  • Submitting a batch process to perform the deletion in background.
  • Trapping errors and allowing for the request to be cancelled or restarted if the errors are fixed.
  • Creating a new request to clean up backup tables added during the deletion processing.

Deletion of "orphan" records (child table records where the parent record no longer exists) is one of the most common data correction requests from cloud implementations. Using a request configured to generate and run the SQL to delete such records allows users to manage this process without having to request special database updates.

Steps to Enable

Provide the required access before using the feature. Details are in the Access #Requirements section.

Tips And Considerations

To enable users to create requests for orphan record deletion, you must give them add access to the application service for the new Data Correction Request Root business object (F1-DATACORRECTIONRBO).

Upgrade scripts ensure that users with Read access to the existing request type all-in-one portal will have access to the new application service associated with the new query portal. The table below lists the existing and new application services.

Object	New Application Service	Access Added to any User Groups with this Application Service / Read Access
Request Type Portal	F1REQTYQ	F1REQTYP

Access Requirements

System administrators should grant access to the F1-DATACORRECTIONRBO application service for any user that is going to create requests for orphan data correction.