1. User Guide
  2. Data Administration
  3. Balance Reconciliation
  4. Reconciliation using Batch Process

3.7.5 Reconciliation using Batch Process

You can do Reconciliation using the Scheduler Services.

To run the Reconciliation using Batch Process, follow these steps:

  1. With the Define Batch feature, it is possible to create new batches and review existing ones.
  2. Click + to create a new batch.
  3. In the Create Batch screen, enter the following values:
    1. Code (spaces are not allowed in the code section).
    2. Batch Name
    3. Select the Service URL name as RUN_CMD_SERVICE.
    4. Click Save.
  4. In the Define Task screen, you can define the tasks related to a specific batch.
    1. Navigate to Define Task.
    2. Select the name of the batch that has been created for this task.
  5. Click + to create a new task.
  6. In the Create Task screen, enter the following values:
    1. Task Code (Spaces are not allowed in the code section). b.
    2. Task Name.
    3. Select the task type as REST.
    4. Select the component as RUNCMD.
    5. Select Batch Service URL as RUN_CMD_SERVICE.
    6. Click Save.
  7. In the Task Parameter section, enter the following values:
    1. Select the Code as RUN CMD RECONCILIATION.
    2. Select the Execution Venue as NATIVE.
    3. Select the Optional Parameter as THRESHOLD_OBJECTCODE_OPTION format.
    4. Select the IP as localhost.
    The allowed values for the Option are either 0 or 1.
    • 0: Truncate all existing data for concerned AS_OF_DATE/MIS_DATE for which reconciliation batch is getting executed and insert new data.
    • 1: Append data on top of existing data for concerned AS_OF_DATE/MIS_DATE to ledger instrument and reconciliation difference Audit table (Table to retain comments for each plug entry).

    Threshold values must be greater than or equal to zero (0), negative values are not supported. Threshold values should be expressed as “threshold >= 0” The threshold will accommodate null values, allowing all data to be inserted into the ledger instrument and reconciliation difference audit tables.

    When a threshold is applied, plug entries will be created only for filtered data into the ledger instrument and reconciliation difference audit tables.

    Note:

    Select the appropriate object code/reconciliation definition to avoid errors in the batch process.

    The optional values should be passed in the following format: “THRESHOLD_OBJECTCODE_OPTION”

    Example 1: ‘’_F405734331FD795BE053D71A000AD329_0

    (Threshold is null, and object code is: F405734331FD795BE053D71A000AD329, option value is 0)

    Example1: 12_F405734331FD795BE053D71A000AD329_1

    (Threshold is 12, and object code is: F405734331FD795BE053D71A000AD329, option value is 1)

  8. Schedule the batch using the Schedule Batch screen.

    Select the Name of the batch that has been created.

    You can use the Edit Parameters option to review the batch parameters and make any necessary changes to initializing the batch process.

  9. The following tasks should be performed in a manner similar to what was outlined in point number 7.
    1. The MIS Date is used as the As of Date in the Reconciliation UI. Select the appropriate MIS Date.
    2. The values in point 6 are the default values for a specific environment.
    3. After completing the changes, click Execute or Save.
      1. By clicking Save, the definition of the batch will be saved, however, the batch will not be executed.
      2. By clicking Execute, the batch will be executed.

    After the batch is executed, an Execute Status dialog is displayed, providing information about the executed batch.

    After the batch is executed, the information about the executed batch will be available in the Monitor Batch screen. Select the following options and check the Batch Status.

Sometimes, a batch may fail. The reason for the batch failure could be as follows:

  • Entering an incorrect object code.
  • Entering an incorrect option value. Only values of 0 or 1 are supported.
  • Entering an incorrect threshold value. Only null or a value >= 0 are supported.

Note:

Following roles mapping to the SKU User group should be present to enable RUNCMD listing and execution.
  • RCMDREAD
  • RCMDADVND

For detailed instructions for defining, executing, and monitoring a Batch, see the Scheduler Service documentation.