Loading Balances
You can load balances using pre-mapped text files that are loaded using the Account Reconciliation Manager user interface or load data using Data Management.
Loading Pre-mapped Balances
To load pre-mapped balances:
- From Navigate, select Applications, then Financial Close Management, and then Reconciliation Manager.
- Select Tools and then Import Pre-mapped Balances.
- On Import Pre-mapped Balances, do the following:
- Browse to your pre-mapped balances text file and select it.
- In Balance Type, select the balance type, for example, Source System or Subsystem
- Select the Period.
- Select the Currency Bucket, for example, Functional.
- Select the file delimiter that you are using in the text file selected. For example, Comma or Tab.
- Click Import.
Loading Data Using Data Management
Data Management manages Account Reconciliation data loads. Data Management includes data adaptors to import balances and FX rates from certain general ledgers. These data adaptors provide direct connections into the general ledgers, avoiding the requirement to first export data into flat files.
Data Management also includes a flat file adaptor for loading balances from flat files, ensuring that data can be imported from subledgers and general ledgers for which no prebuilt adaptor is available. When a flat file adaptor is used to load balances, FX rates must be imported from a flat file as well. In this case, import of FX rates occurs within Account Reconciliation, without using features of Data Management .
Administrators and Power Users can execute data loads. However, to run a data load as of 11.1.2.4.200 release, the Administrator or Power User must have the Data Management role of Run Integration (the Data Management Administrator role includes Run Integration.)