Oracle Account
Reconciliation Cloud
Service (ARCS) Training Lab
Document
[Link] 1|Page
Contents
Contents .................................................................................................................................................. 2
1. Perform the Reconciliation ....................................................................................................... 3
2. Working with Transactions ...................................................................................................... 5
3. Importing Data Using Data Management ................................................................................ 7
3.1. Setup Tasks in Data Management ........................................................................................ 7
3.1.1 Setting up Source Systems ....................................................................................................... 8
3.1.2 To register a target application: .............................................................................................. 8
3.1.3 Defining Locations.................................................................................................................. 10
3.1.4 Defining Period Mappings .............................................................................................. 11
3.1.5 Defining Category Mappings .......................................................................................... 13
3.2 Workflow Tasks in Data Management ............................................................................... 13
3.2.1 Creating Member Mappings ........................................................................................... 14
3.2.2 Defining Data Load Rules to Extract Data...................................................................... 14
3.2.3 Using the Data Load Workbench .................................................................................... 16
3.2.4 Executing a Data Load in Reconciliation Compliance and Viewing Results ............... 17
4. Importing Pre-mapped Data................................................................................................... 18
4.1 Importing Pre-mapped Transactions ................................................................................ 18
4.2 Importing Pre-mapped Balances ....................................................................................... 19
5. Importing Transaction ............................................................................................................ 20
[Link] 2|Page
1. Perform the Reconciliation
Select the Period to which the reconciliation to be performed.
Then Select the one account ID then Action and then Open Reconciliation
After Opening Reconciliation
[Link] 3|Page
Next Claim the Reconciliation
Preparer can Release the Reconciliation or Can Submit the reconciliation when
the Unexplained Difference is Zero
[Link] 4|Page
2. Working with Transactions
To add the Balance Explanation Click on “Adjustments to General ledger” or to
“Adjustments to Sub ledger “ depending on the scenario, where to explain the
balance ( source system / subsystem)
[Link] 5|Page
To work with transactions and adjustments, you can take the following actions:
Click + (New) to manually enter a transaction. You can also edit, copy, or
delete.
Click Copy from Prior Period to add transactions
Click Import to add transactions from a file.
Click Export to export transactions,
Click Refresh to refresh the page
To manually enter a new transaction, click + (New) on the Transaction dialog and
then enter the information for that transaction. You can Save or Save and Create
Another transaction.
[Link] 6|Page
3. Importing Data Using Data Management
The overall process is to perform the following tasks:
o Setup tasks (in Data Management)
o Workflow tasks (in Data Management)
o Execute a data load and view results (in Oracle Account Reconciliation
Cloud)
3.1. Setup Tasks in Data Management
These are the setup tasks:
1. Define the source system.
2. Specify your target application (Account Reconciliation Manager)
3. Import format - maps source columns or fields to dimensions in Oracle
Account Reconciliation Cloud.
4. Define location.
5. Define period mapping between Data Management and Oracle Account
Reconciliation Cloud period.
6. Define category mapping to map currency buckets
[Link] 7|Page
3.1.1 Setting up Source Systems
The source system page displays all registered source systems in a table in the
Summary pane. By default, the following columns are displayed:
Name—Name of the source system
Type—A file-based source system is the only supported source system.
Description—The description that you entered when you registered the
source system.
Drill URL—The drill URL you entered when you registered the source
system.
3.1.2 To register a target application:
1. Select the Setup tab, and then under Register, select Target
Application.
2. In Target Application, in the summary grid, click Add, and then select
the type of deployment.
Available options are Cloud (for a Cloud deployment), Local (for an
on-premise deployment) or data source (for Oracle NetSuite or Oracle
HCM Cloud deployments.)
[Link] 8|Page
To add an import format for a file-based data load system:
1. On the Setup tab, under Integration Setup, select Import Format.
2. In the Import Format summary task bar, select Add.
3. In Name, enter a user-defined identifier for the import format.
4. In Description, enter a description of the import format.
5. In Source, select File for the source system.
6. From File Type, select the format of the file. Delimited - Numeric Data
7. In Target, select the target system.
8. In Drill URL, enter the URL used for the drill-through.
9. In the Mapping section, map any dimensions as shown below.
10. Click Save
[Link] 9|Page
3.1.3 Defining Locations
To create, edit, and delete import locations:
1. On the Setup tab, under Integration Setup, select Location.
2. In Location, click Add.
3. From Location Details, in Name, enter the location name.
4. From Import Format, enter the import format.
5. Click Save.
[Link] 10 | P a g e
3.1.4 Defining Period Mappings
You can use various kinds of calendars (for example, monthly, weekly,
or daily) based on your business and statutory requirements.
To define a global mapping:
1. On the Setup tab, under Integration Setup, select Period Mapping.
2. Select the Global Mapping tab.
3. Click Add.
4. Select the Period Key.
5. Select the Prior Period Key.
6. Enter the following:
a. Period Name; for example, August 2005.
b. Target Period Month; for example, August.
c. Target Period Quarter
d. Target Period Year
e. Target Period Day
[Link] 11 | P a g e
f. Year Target
7. Click Save.
Application Mappings
To create period mappings for an application:
1. On the Setup tab, under Integration Setup, select Period
Mapping.
2. Select the Application Mapping tab.
3. In Target Application, select the target application.
4. Click Add.
5. Select the Period Key.
6. Enter the following:
a. Target Period Month
b. Target Period Quarter
c. Target Period Year
d. Target Period Day
e. Year Target
7. Click Save.
[Link] 12 | P a g e
3.1.5 Defining Category Mappings
You define category mappings for categorizing and mapping source system data to a
target Scenario dimension member
3.2 Workflow Tasks in Data Management
[Link] 13 | P a g e
These are the workflow tasks:
1. Define a data load rule for location you defined.
2. Define the data load mapping to map the dimension values from the source to
target.
3. In Data Load Workbench test and validate the data by executing the data load rule
3.2.1 Creating Member Mappings
To define member mappings:
1. On the Workflow tab, under Data Load, select Data Load Mapping.
2. In Data Load Mapping, select the Location.
3. Select the Dimension.
4. Choose the type of mapping by selecting the Explicit tab, Between tab,
Multi-Dimension tab, or Like tab.
5. In Rule Name, specify the data load rule to use with the mapping script.
6. Click Save.
3.2.2 Defining Data Load Rules to Extract Data
[Link] 14 | P a g e
To define the data load details for a source system:
1. On the Workflow tab, under Data Load, select Data Load Rule.
2. In the Data Load summary area, click Add.
3. In Details, in Name, enter the data load rule name.
4. Select a Category. Search for Import formate you created
5. select the Source Options and fetch the File( to be browsed from
local PC).
6. Click Save.
[Link] 15 | P a g e
3.2.3 Using the Data Load Workbench
The Data Load Workbench consists of four sections:
Importing Source Data
Validating Source Data
Exporting Data to Target Applications
Checking the Data
[Link] 16 | P a g e
3.2.4 Executing a Data Load in Reconciliation
Compliance and Viewing Results
To execute a data load in Reconciliation Compliance and view the results:
1. From Home, select Application, then Periods.
2. Next to the period that you want to load data into, click Actions and
select Import Data .
The Data Load Execution dialog contains a history of data loads,
reporting the start date, end date, the user who executed it, the status,
and the result. The status report shows subprocesses and the status of
each
[Link] 17 | P a g e
4. Importing Pre-mapped Data
4.1 Importing Pre-mapped Transactions
To import transactions from a file: From the Home card,
select Reconciliations, and then select a reconciliation with the status
Open with Preparer .Select Actions, and then Import Pre-mapped Data,
and then Import Pre-mapped Transactions.
Browse to the flat file of transactions you want to add. This is an example
of a transactions flat file.
[Link] 18 | P a g e
4.2 Importing Pre-mapped Balances
To import balances from a file: From Home , select Reconciliations, and
then select a reconciliation with the status Open with Preparer.
Select Actions, and then Import Pre-mapped Data, and then Import
Pre-mapped Balances.
[Link] 19 | P a g e
Browse to the flat file of balances you want to add. This is an example of a
balances flat file.
5. Importing Transaction
After defining the match type to Import the transaction in Transaction matching
Admin has to navigate From Home, select Application, then Jobs, and then
select Transaction Matching.
Depending on the Data source defined in match type , browse the file from local PC
[Link] 20 | P a g e
[Link] 21 | P a g e