Creating a Reconciliation Compliance Balances Integration

You can load balances imported as source system and sub system data sources to a Reconciliation Compliance Balances target application by creating an integration.

1. From the Data Integration home page, click, and then select Integration.

   The General page is displayed in Create Integration view.

2. In Name and Description, enter a name and description for the Reconciliation Compliance Balances integration.

3. In Location, enter a new location name, or pick an existing location to specify where to load data..

4. Click (Select a Source).

5. From the Select a Source page, select the source system to use for the integration. File.

   The source can be an ERP, an on-premises database, a file, or any source system.

6. (Optional): If the source system in step 5 is file-based, from the File Browser, select the transactions file from which to load to the Reconciliation Compliance Balances application and click OK.

   You can double-click the inbox or outbox folders, or any other folders to see a list of files in folders.

   You can also click Upload and navigate to a file to upload it.

   Optionally, you can create a file-based load in which you designate the file to be loaded at runtime. However, the column number and column name are designated only when you map the dimensions. See Mapping Dimensions.

   You can select the following types of files.

   • comma separated file (CSV)
   • tab separated file (TXT)
   • custom delimiter file

7. Click (Select a Target).

8. From the Select a Target page, select the Reconciliation Compliance Balances target application.

9. From Category, select a currency bucket.

   Options include:

   • Entered
   • Functional
   • Reporting

10. Click Save.