Logging of reconciliation elements

Regarding performance and data growth, consider the following parameters in the Reconciliation Groups (tcfin0120m000) session:

• Write Reconciliation Data

  Writing of reconciliation data results in significant data growth and loss in performance. Therefore, you should only select the Write Reconciliation Data check box for reconciliation groups that require detailed analysis. For interim accounts, it is recommended to switch on logging reconciliation data, but for end accounts this is generally not required.

  Note By default, the check box is selected for most of the end accounts.

  When no further analysis is required, you can clear the Write Reconciliation Data check box because all integrations and mappings are correct. Then, reconciliation data for this reconciliation group can be archived and deleted using the Archive / Delete Reconciliation Data (tfgld4295m200) session.

• Log All Reconciliation Elements

  For each reconciliation group, you can specify the reconciliation elements for which reconciliation data must be logged. However, at the time of going live, not all reconciliation groups may yet have a well-defined set of reconciliation elements. Additionally, at some point in time, it could be required for a proper reconciliation to add a new reconciliation element. To do so, the Log All Reconciliation Elements check box must be selected for all reconciliation groups that do not have a well-defined set of reconciliation elements at the time of going live. If this check box is selected, all reconciliation elements will be logged, resulting in huge data growth and severe loss in performance. Therefore, only use this setting as a temporary solution.

  In a stable environment, the Log All Reconciliation Elements check box at reconciliation group level should always remain cleared. If this check box is selected for a specific reconciliation group, it should be cleared as soon as possible, generally no later than a few weeks after going live. When you clear this check box, to remove the logged reconciliation elements, run the Delete Logged Reconciliation Elements (tfgld4296m000) session. When all reconciliation groups have their Log All Reconciliation Elements check box cleared, table tfgld498 can be purged at database level.

• Automatically Finally Accept Reconciliation Data

  If this check box is selected, the status of reconciliation transactions is automatically set to Finally Accepted at the time of logging. You can use this setting for reconciliation groups that require analysis, but do not require a detailed acceptance procedure. Selecting this check box will bypass time-consuming acceptance and final acceptance reconciliation steps.