| Logging of reconciliation elementsRegarding performance and data growth, consider the following
parameters in the Reconciliation Groups (tcfin0120m000) session: 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. 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. 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.
Performance aspects - Effect on CPU: Yes
- Effect on database growth: Yes
| |