2 Overview

This guide contains information about tables within Oracle Account Reconciliation and their columns, primary keys, indexes, and foreign keys, if applicable. The guide also includes information about views within Oracle Account Reconciliation along with the columns and queries associated with each view.

Basic terminology that may be helpful:

• Tables are the basic unit of data storage in Oracle Account Reconciliation, where data is stored in rows and columns. For example, the FCM_USERS table is a common table and stores information about the users such as first name, last name, time zone preference, user interface skin preference.

  Note:

  In Transaction Matching, there are also dynamically created tables that are created for each datasource once a match type is approved successfully. See Transaction Matching Dynamic Tables and Views

• A view is a logical representation of a table or combination of tables. A view is a stored query that derives its data from the tables on which it is based. For example, the ARM_BALANCE_DETAIL_SUMMARY view is a Reconciliation Compliance view that shows the Source and Sub-system balances that are shown on the Detail Balances list.

How This Guide is Structured

This guide is divided into four sections:

• Common Tables - these tables start with FCM
• Reconciliation Compliance Tables and Views - these tables and views start with ARM
• Transaction Matching Tables - these tables start with TM
• Transaction Matching Dynamically Created Tables - these tables start with TM_TRANS