Settings for Transaction Matching
Administrators can configure settings that improve performance and make transaction matching easy to use.
Settings that can be configured include search mode, enabling or disabling inline edits for unmatched transactions, and batch size for purging transactions.
To configure transaction matching settings:
- From Home, click Application, then Configuration.
- On the System Settings tab, select Transaction Matching.
- Set Search Mode to tune the performance of transaction
search. Select one of the following options:
- Normal: Uses default database query optimization.
- Parallel Mode: Uses parallel mode database query optimization. Select this mode when your typical search is across all accounts within a Match Type. This is the default setting.
- Full Scan Mode: Uses full scan database query optimization. Select this mode when your typical search requires selection of a single account.
- To enable inline editing of the values of editable attributes in the Unmatched
Transaction dialog, select Enable Inline Edit.
This acts as a master on/off switch for all editable attributes and for all unmatched transactions. For new applications, the default setting for Enable Inline Edit is ON. For existing applications, if this setting was never configured, the default remains OFF.
- In Batch Size under the Purge
Transactions section, specify the batch size that must be used when
purging transactions.
The default is 200000. The minimum value is 1000 and the maximum value is 200000.
-
In Batch Size under the Archive Transactions section, enter the number of matched transactions that must be stored in a single .csv file within the archive.
The default value is 500000. The minimum value is 10000 and the maximum value is 1000000.
-
Under Import Transactions, select Ignore Invalid Accounts to ignore transactions with invalid, unmapped, or inaccessible accounts during a data load. The data load succeeds and the import log file contains warnings for the transactions that were not loaded.
When this setting is unchecked, the import fails when the load file contains transactions with invalid account IDs or unmapped accounts.
-
In the Automatch section:
- Thread pool size: Specify the number of accounts that can be run in parallel by systems across all Automatch processes. The minimum value is 1 and the maximum value is 32. The default value is 10 for non-OCI environments and 24 for OCI environments. The default setting is appropriate for most scenarios. Change the default value only if Oracle Support recommends that you do so. If this value is updated, the change will take effect when the service is restarted.
- Optimization: Select one of the following options:
- Normal: Uses default database query optimization.
- Full Scan Mode: Uses full scan database query optimization.
Change the default setting only if Oracle Support recommends that you do so.
-
In the Balance Summary section:
- Thread pool size (OCI environments only): Specify the number of tasks that can run in parallel for balance summary recalculations. The minimum value is 16 and the maximum value is 32. The default value of 16 is appropriate for most scenarios. Change the default setting only if Oracle Support recommends that you do so. If this value is updated, the change will take effect when the service is restarted.
- Queue Optimization: Optimizes the submission of balance summary recalculation tasks. This option is enabled by default. If this value is updated, the change will take effect when the service is restarted.