Click here to view in video format

Oracle's EPM Cloud Account Reconciliation (ARCS) is purpose-built to efficiently manage and improve global account reconciliation by automating and addressing security and risk typically associated with the reconciliation process.

ARCS features Transaction Matching as part of the Reconciliation Compliance feature set. With Transaction Matching, companies can automate preparation of high volume, labor intensive reconciliations and seamlessly integrate those results into the tracking features within Reconciliation Compliance.

In ARCS, you can import up to 1 million transactions from a flat file, from your source system, or database.
Assure that the load files are formatted correctly to avoid import errors. There should be no null values on Required Attributes such as Balancing Attributes and attributes used in Match Set Rules

Use Text as a Data Type

A good rule to remember is to make all non-essential attributes Text data types. If the attributes are not used in Match Rules, declaring those attributes as Text data types will minimize the need to troubleshoot import errors.

Import Error Example - Null Dates

Error at line no 5 : Cannot be converted to number NULL. Error processing value for attribute Date_Approved.

---

You only need the Accounting Date as a Date data type for Recon. If the Accounting Date attribute is Sales_Date, then any extra date attributes can be set to text, otherwise null dates in your import file will cause import failure.

Import Error Example - Unformatted Numbers

Error at line no 2 : Error processing value for attribute Amount_Calc. Number has to be a maximum 18 digit long and cannot contain any non numeric characters including separators such as decimal or thousands.

Only one Amount column is needed as a Number data type, and that is the Balancing Attribute (example Sales_Amount). If your import file contains another amount such as Amount_Calc that contains the same amount value, but has 14 decimal places, Oracle will reject the import. Instead, make the Amount_Calc attribute a text data type, since Sales_Amount is already the balancing attribute used for the reconciliation.

Make visual audits and reviews easier by creating lists in the Matching section of ARCS

By default, Oracle displays columns for Matches and Unmatched Transactions in a random fashion. Click View -> Select Columns and arrange the columns for Source and Sub Systems using a standard order.

Good practice would be to order the columns by accounting date, balancing attribute, and match set rule attributes.

You can Remove unnecessary fields and save the List. Visual Auditing is now much easier to do without all the non-essential attributes in the way, and Amounts are easier to find when a user does not need to scroll across columns to find the Amount column.