Handling Data Load Failures in Account Reconciliation

Unexpected data load failures may occur in Account Reconciliation while loading the data or during post-processing of loaded data. When a data load or post-processing fails unexpectedly, Account Reconciliation attempts to clean up balances. However, because it does not store old values, Account Reconciliation is unable to revert the modified balances for the failed data load.

If the failure occurs during the data load or post-processing phase, run Auto-Reconcile to allow Account Reconciliation to automatically complete reconciliations. Running Auto-Reconcile corrects unexplained data deviation occurring after data load failures. See Administering Account Reconciliation for information to run Auto-Reconcile.

If data load failure occurs at the staging phase, you do not need to run Auto-Reconcile. Instead, check the data integration process logs to resolve the failure.