Integrating General Ledger Using Journal Import
Use Journal Import to integrate information from other applications such as payroll, accounts receivable, accounts payable and fixed assets with your General Ledger application. For each accounting period, you can import accounting data from these feeder systems, then review, update and post the journal entries. You can also use Journal Import to import historical data from your previous accounting system.
To import subledger and feeder system data to General Ledger:
1. Set up General Ledger to accept Journal Import data by defining your set of books, currencies, accounts, journal sources, and categories. You should also run the Optimizer program, and define your concurrent program controls.
2. Export data from your feeder system and populate the GL_INTERFACE table.
Note: If you use Multiple Reporting Currencies and Oracle subledger systems, you must post to General Ledger from each subledger multiple times. Post first using your primary subledger responsibility, which transfers amounts denominated in your functional currency. Post next using each of your subledger reporting responsibilities, which transfers amounts denominated in your reporting currencies.
If your import program converts your journal entries from other sources into the required data format, and all of the data is valid in your General Ledger application, then Journal Import should run successfully the first time. However, if you load data into the GL_INTERFACE table which is not valid in your General Ledger application, Journal Import informs you of the specific errors on the Journal Import Execution Report.
Note: If you use Multiple Reporting Currencies and Oracle subledger systems, and have chosen not to run Journal Import automatically when posting amounts to General Ledger from your subledgers, you must run Journal Import manually in your primary set of books and in each of your reporting sets of books.
4. Use the Journal Import Execution Report to review the status of all import journal entries. The Journal Import Execution Report prints a line for each journal entry source from which you are importing journal entries.
5. If you encounter relatively few Journal Import errors, you can correct the data in the GL_INTERFACE table.
6. If you encounter several Journal Import errors, you should delete the Journal Import data from the GL_INTERFACE table, and correct the information in your feeder system before rerunning Journal Import.
7. Review the journal entries created by Journal Import before you post them.
8. Post your Journal Import journal entries.
See Also
Preparing to Import Journals
Exporting Data from Your Feeder System
Running the Optimizer Program
Setting the Concurrent Program Controls
Importing Journals
Setting the Journal Import Run Options
Correcting Journal Import Data
Deleting Journal Import Data
Submitting a Request
Creating Journal Batches
Posting Journal Batches