9.2 Utilizing Route Reconciliation Exception

Purpose: Use this document as a reference for utilizing route reconciliation exceptions in ctcLink.

Audience: Settlement Manager, GL Accountant

If you plan to route exceptions for automatic reconciliation to a user’s Worklist or email account, you must select Automatic in the Recon Method field, and choose either the Notification Framework or Workflow notification method for the bank account on the External Accounts – Reconciliation page.

Note: If you are using a reconciliation method other than automatic, the system sets the Recon Method field to No Workflow.

If you choose the Notification Framework method for automatic reconciliation, the Notification Registry definition for Bank Reconciliation Exceptions is delivered as system data and provides the integration between Treasury and the Notification Framework. You can allow users to override the Worklist or email notifications on the Notification Registry page.

Information provided for system-level notifications can be changed in the Notifications System Overrides component. If required, you can modify the Email Notification and Worklist Notification details in the System-Level Notification page. Options to allow user overrides for Worklist or email notifications must be selected on the Notification Registry page in order to enter notification details at the system level. By default, the system notifies users with the Bank Manager role by Worklist if any reconciliation exceptions are found. In order to trigger email notifications, you must enter user IDs or email addresses in the Override Email Notification section.

Navigation:  NavBar > Navigator > Banking > Analyze Exceptions > Route Reconciliation Exception

Utilizing Route Reconciliation Exception

  1. The Route Reconciliation Exception run control ID search page displays.  It defaults to Find an Existing Value.  In this example, we'll create a new run control ID.
  2. Select Add a New Value.
  3. Enter a meaningful run control ID for the Route Reconciliation Exception in the Run Control ID field.

Note: A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process that you are running. The Run Control ID defines parameters that are used when a process is run. These parameters ensure that when a process runs in the background, the system does not prompt you for additional values.

  1. Select Add.
Route Reconciliation Exception Add a New Value page
  1. The Route Reconciliation Exception parameters page displays.
    1. Enter or select a bind variable name of either 'BNK_ID_NBR' or 'BANK_ACCOUNT_NUM' in the Bind Variable Name field.
    2. Enter the corresponding bank ID number or bank account number in the Value field.
    3. Select Run.
  1. The Process Scheduler Request page displays.  Use it to enter or update parameters, such as server name and process output format.
  2. Use the Server Name drop-down button to select the appropriate processing server for the request.

Note: You can leave the field blank.

  1. Select OK.
  1. The Process Scheduler Request page disappears.  The updated Route Reconciliation Exception page displays.  Note the Process Instance number.

Note: A Process Instance number appears. This number helps you identify the process you have run when you check its status.

  1. Select Process Monitor.  Refer to the Process Monitor QRG for instructions.


  1. The Process List page displays.  Use it to view the status of submitted process requests.

Note: The process has finished successfully when the Run Status column indicates ‘Success.’

  1. Process complete.