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 choose to:
Import Journal References: To import detail reference information for summary journals you import from your Oracle feeder systems. If you choose this option, you can also use the Account Inquiry window to drilldown to subledger transactions, transferred from Oracle subledgers in summary or detail, for a specified source.
Freeze Journals: To freeze the journal source, preventing users from making changes to any unposted journals from that source, or reversing journals for Subledger Accounting journal sources.
Require Journal Approval: To require journals with a specific journal source be approved by higher management levels before posting. Journal Approval must be enabled for your ledger.
Import Using Key: To use a language-independent and instance-independent key, as specified in the Source Key field. This option allows you to identify a particular journal source and category consistently across all languages and instances.
General Ledger provides predefined journal entry sources, listed in the table below:
| 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 |
| Carry Forward | Carry Forward Journal Entry |
| Closing Journal | Closing Journal |
| Consolidation | Consolidation Transfer |
| Contract Commitment | Contract Commitment |
| Conversion | Historical Data Conversion |
| Elimination | Intercompany Elimination |
| Encumbrance | Manual Encumbrance Entry |
| Inflation | Inflation Journal Entry |
| Inflation Accounting | Inflation Accounting |
| Intercompany | Intercompany Transactions |
| Intercompany Allocations | Allocations transferred from Oracle Intercompany |
| Inventory | Inventory Control System |
| Lease | Oracle Lease Management |
| Manual | Manual Journal Entry |
| Manufacturing | Manufacturing |
| Marketing | Marketing Online System |
| MassAllocation | MassAllocation |
| Move/Merge | Move/Merge |
| Move/Merge Reversal | Move/Merge Reversal |
| Other | All other sources |
| Payables | Accounts Payable System |
| Payroll | Payroll System |
| Periodic Inventory | Periodic Inventory Control System |
| Personnel | Personnel System |
| Projects | Project Accounting |
| Property Manager | Property Manager |
| Public Sector Budget | Public Sector Budget |
| 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 |
| Student System | Student System |
| Transfer | Budget Transfer |
| Treasury | Treasury |
Navigate to the Journal Sources window.
Enter a unique Source, Source Key and Description for your journal entry source. The Source and Source Key can be the same or different. You cannot delete a source name after saving your work.
Note: You can change the source name at any time. For user-defined sources, you can change the source name and source key at any time.
Enable/Disable the following check boxes for this journal source:
Import Journal References
Enabled:
In the Account Inquiry window, you can drilldown to subledger transactions, transferred from subledgers in summary or detail, for this source.
Journal References will be imported from your feeder systems to maintain a mapping of summarized transactions when you run Journal Import, whether you run Journal Import in summary or detail. 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.
Disabled:
In the Account Inquiry window, you cannot drilldown to subledger transactions, transferred from subledgers in summary or detail, for this source.
Warning: Do not disable Import Journal References if you plan to drill down to transactions from the Account Inquiry window. Once you disable Import Journal References, you will not be able to drill down to transactions subsequently imported using that journal source.
Freeze Journals
Choose an option from the list:
Yes: Journals from this source cannot be changed in the Enter Journals form nor the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that are frozen.
No: Journals from this source can be changed in both the Enter Journals form and the Journal Correction form. In addition, you can reverse journals with unfrozen Subledger Accounting journal sources.
Journal Entry Page Only: Journals from this source cannot be changed in the Enter Journals form but can be changed in the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that have this option.
Require Journal Approval
If journal approval is enabled for your ledger and you enter a journal whose journal source requires journal approval, the batch must be approved before it can be posted.
Import Using Key
Enabled:
If you enable this checkbox, the Journal Import program uses the value entered in the Source Key field, instead of the Source field, when importing journals for a given source.
The Source Key is a language-independent and instance-independent key that helps you identify a particular journal source and category consistently across all languages and instances.
You should check the checkbox for custom sources if want to use the Source Key values instead of the Source values upon importing journals.
Disabled:
By default, the checkbox is unchecked. The Journal Import program uses the value entered in the Source field when importing journals for a given source.
(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 ledger.
Save your work.
Navigate to the Journal Sources window.
Query the journal entry source you want to review or change. You can change the Name, Description, Import Journal References setting, Freeze Journals setting, Require Journal Approval, and Import Using Key setting, You can change the Effective Date Rule for any journal source except Average Consolidation.
Warning: Do not disable Import Journal References if you plan to drill down to transactions from the Account Inquiry window. Once you disable Import Journal References, you will not be able to drill down to transactions subsequently imported using that journal source.
Save your work.