Defining Journal Sources

Journal sources identify the origin of your journal entries. General Ledger supplies a number of predefined journal sources. In addition, you should define at least one journal source for each of your own, non-Oracle feeder systems to help you track imported journal entries.

For each journal source, you can specify whether to import detail reference information for summary journals you import from your feeder systems. You can also choose to freeze the journal source, preventing users from making changes to any journals that are posted to General Ledger from that source.

If you have journal approval enabled for your set of books, you can require that journals with a specific journal source be approved by higher management levels before the journal can be posted.

You can define intercompany and suspense accounts for specific sources, run the AutoPost program for specific sources, import journals by source, and report on journals by source using the Foreign Currency Journals or General Journals reports.

General Ledger provides the following predefined journal entry sources:

Name	Description
AX Inventory	AX Inventory Entry
AX Payables	AX Payables Entry
AX Receivables	AX Receivables Entry
Assets	Fixed Asset System
Average Consolidation	Average Balance Consolidation
Budget Journal	Budget Journal
Carryforward	Carry Forward Journal Entry
Consolidation	Consolidation System
Conversion	Historical Data Conversion
Encumbrance	Manual Encumbrance Entry
Inventory	Inventory Control System
Manual	Manual Journal Entry
Manufacturing	Manufacturing
MassAllocation	MassAllocation
Move/Merge	Mass Maintenance Move/Merge
Move/Merge Reversal	Mass Maintenance Move/Merge Reversal
Other	System default
Payables	Accounts Payable System
Payroll	Payroll System
Personnel	Personnel System
Project Accounting	Project Accounting
Purchasing	Purchasing System
Receivables	Accounts Receivable System
Recurring	Recurring Journal Entry
Revaluation	Revaluation Journal Entry
Revenue	Revenue Accounting System
Spreadsheet	Spreadsheet
Statistical	Statistical Journal Entry
Transfer	Budget Transfer

To define a new journal entry source:

1. Navigate to the Journal Sources window.

2. Enter a unique Name and Description for your journal entry source. You cannot delete a source name after saving your work.

3. Choose whether to Import Journal References from your feeder systems to maintain a mapping of summarized transactions if you choose to create summary journals when you run Journal Import. This information is stored in the GL_IMPORT_REFERENCES table.You can request a mapping report from your feeder systems after Journal Import completes. Or, you can write your own report referencing the GL_IMPORT_REFERENCES table which stores the mapping information.

4. Check whether to Freeze Journals for this journal entry source. If you mark this checkbox, journals from this source cannot be changed in the Enter Journals window. If you subsequently unmark this checkbox, you can make changes to journals from this source.

5. Check whether to Require Journal Approval for this journal source.If journal approval is enabled for your set of books and you enter a journal whose journal source requires journal approval, the batch must be approved before it can be posted.

6. (Average Balance Processing only) From the poplist, select an Effective Date Rule for this journal source:

Fail: Journal Import will reject transactions when the effective date is not a valid business day. No posting takes place.

Leave Alone: Journal import will accept all transactions regardless of the effective date.

Roll Date: Journal Import will accept the transaction, but roll the effective date back to the nearest valid business day within the same period. If there is no prior valid business day within the same period, the effective date is rolled forward.

Note: The Effective Date Rule field will not appear unless you have average balance processing enabled for at least one set of books.

7. Save your work.

 To review or change an existing journal entry source:1. Navigate to the Journal Sources window.2. Query the journal entry source you want to review or change. You can change the Name, Description, Import Journal References setting, Freeze Journals setting, and Require Journal Approval setting. You can change the Effective Date Rule for any journal source except Average Consolidation.3. Save your work.