Data Integration Pipeline Extended to Account Reconciliation

The Pipeline in Data Integration is now available to Account Reconciliation environments.  The Pipeline is used to orchestrate a series of routine tasks within Cloud EPM Platform as a single process.

New Pipeline job types specific to Account Reconciliation include:

  • Create Reconciliation: (Reconciliation Compliance) Copies all selected profiles to a period and return success or failure status.
  • Generate Report for Account Reconciliation: Generates either a single predefined Reconciliation Compliance report, predefined Transaction Matching report or a custom report.
  • Import Attribute Values: Imports attribute values into an existing list attribute or group attribute. In Transaction Matching, you can only import group attributes.
  • Import Balances: (Reconciliation Compliance) Imports balances data using Data Integration from a previously created integration definition and returns a success or failure status.
  • Import Pre-Mapped Balances: (Reconciliation Compliance) Imports pre-mapped balances and returns the success or failure status.
  • Import Pre-Mapped Transactions: (Transaction Matching) Imports a file of pre-mapped transactions into Transaction Matching and returns the success or failure status.
  • Import Rates: (Reconciliation Compliance) Imports rates for a particular period and rate type, and returns the success or failure status.
  • Run Auto Match: (Transaction Matching) Runs the auto match process in Transaction Matching.
  • Run Auto Alert: (Transaction Matching) Runs the auto alert process for the specified match type in Transaction Matching. This job processes the alert rules defined for the match type and then automatically creates alerts for unmatched transactions. You can monitor the status of an Auto Alert job through the Job History tab in Account Reconciliation.
  • Set Period Status:  (Reconciliation Compliance) Changes the status of a period (open, closed, pending, locked) and returns the success or failure status. When a period's status is changed to Open, the returned job corresponds to the opening of reconciliations for the specified period. The job's success or failure does not impact the period's status because this change is made immediately. Even if there are failures while reopening,  reconciliations, the period status still remains Open.

    If a period's status is set to Closed or Locked, no job is returned.

Business Benefit: The Pipeline functionality allows users to conduct a sequence of Account Reconciliation focused operations such as importing balances, pre-mapped balances and transactions, rates and so on, streamlined in one location and executed then in serial or parallel mode.

Key Resources