General Ledger's open interface table provides a convenient interface to allow you to import GCS subsidiary data from any external source, such as an entirely separate non-Oracle accounting system. There are three options available for gathering data from non-Oracle sources:

• You can use Applications Desktop Integrator (ADI) to work in a spreadsheet environment. Simply transfer the subsidiary information from the external system into ADI's journal worksheet. Then upload the entries to the GCS system where it can be posted to the target instance. Depending on the format of the subsidiary data, you may need to create a dummy ledger for the subsidiary in this instance.

• You can use SQL Loader to load data from diverse sources into GL's open interface table called GL_INTERFACE.

To Use SQL Loader to Load Data from a Non-Oracle Source

1. Use SQL Loader or another Loader program to prepare your data to load into the GL_INTERFACE table.

   For more information, on the GL_INTERFACE table and its columns, see: Importing Journals.

2. Load each system's data into the corresponding dummy ledger.

3. Run Journal Import for each subsidiary dummy ledger to import transactions. Journal import validates and converts your data into postable journal entries in the subsidiary's dummy ledger.

4. Post the journals in each subsidiary dummy ledger to update balances.

   Now your data is ready for you to use consolidation definitions and mapping rules to map account values from each of your dummy ledgers into the GCS parent.

Other Sources

• Oracle Applications Desktop Integrator User's Guide