Journal Import creates journal entries from accounting data you import from Oracle and non-Oracle feeder systems. You can review, change, and post imported journal entries the same as any other journal entry. Journal Import supports multiple charts of accounts, as well as foreign currency, intercompany, statistical, budget, and encumbrance journals.
Journal Import creates journal entries from data in the GL_INTERFACE table. Oracle feeder systems automatically populate this table. If you are using a non-Oracle feeder system, you must populate this table yourself.
General Ledger validates all data in the interface table before creating journal entries.
Note: For increased security and faster processing, Journal Import only processes accounting data when you have read and write access to the entire ledger or read and write access to all of the import data's balancing segment values, or management segment values when you submit your request.
Caution: Make sure that you have the correct access rights for a particular journal before making any modifications using Journal Import. If you do not have adequate access rights, any modifications you make using Journal Import will be lost.
Note: The Oracle Workflow Business Event System, introduced in Release 2.6, allows products to seed business events and event subscriptions.
Journal Import Started and Journal Import Completed are seeded business events. See: Business Events.
The data access set assigned to your user responsibility controls what journal data you can import into your ledger as follows:
Full Read and Write Access: You can import all valid journal lines into your ledger if your data access set provides full read and write access. The types of full access are as follows:
Full Ledger data access set type that provides read and write access to the full ledger.
Balancing Segment Value data access type that provides read and write access to all of the balancing segment values for the ledger using the All Values checkbox.
Management Segment Value data access type that provides read and write access to all of the management segment values for the ledger using the All Values checkbox.
Partial Read and Write Access: If you have read and write access to some of its balancing segment values and management segment values, you have the following privileges:
Read and write access to specific balancing segment values or management segment values allows you to import journal lines for those balancing segment values or management segment values.
Read-Only Access: If you have read-only access to a ledger, balancing segment values, or management segment values, you cannot import journal data for that ledger.
Read-only access to the ledger prevents you from importing data for that ledger.
Read-only access to balancing segment values or management segment values prevents you from importing data for that ledger. Journal import completes with an error message.
Journal Import groups lines within the same period into the same journal, even if the lines have different accounting dates except for average balance processing enabled ledgers (ADB). Journal Import places lines with different accounting dates into separate journals for ADB enabled ledgers.
If you set the profile option GL Journal Import: Separate Journals by Accounting Date to Yes, Journal Import will place journal lines with different accounting dates into separate journals.
If you use Subledger level Reporting Currencies and you have chosen not to run Journal Import automatically when transferring amounts to General Ledger from your subledgers that are integrated with Subledger Accounting, you must run Journal Import manually in your source ledger and in each subledger level reporting currency.
Note: Make sure the Journal Conversion rules have been defined correctly in Accounting Setup Manager. General Ledger Posting uses the Journal Conversion rules to determine the journals that match a particular source and category combination to be replicated to reporting currencies. The Journal Conversion rules must not allow subledger sources that integrate with Subledger Accounting to be converted to subledger level reporting currencies. This prevents double counting of subledger journals; once by Subledger Accounting and again by General Ledger Posting.
You can bypass currency end date validation during journal import. Transactions denominated in a currency that has been assigned an end date will be imported into Oracle General Ledger if the currency is enabled.
To use this feature, you must define the profile option GL Journal Import: Currency Bypass End Date and set it to Yes.
Below is a list of Journal Import results depending on whether the profile option GL Journal Import: Currency Bypass End Date is set to Yes or No in combination with enabled and disabled currencies.
Set the profile option to Yes and the currency is enabled: The journal import process will skip the end date validation process. Journal import will ignore the assigned effective end date for the currency.
Set the profile option to Yes and the currency is disabled: Batches with a disabled currency will fail during journal import.
Set the profile option to No or Null and the currency is enabled: Journal Import will validate the end date of currencies against the system date.
Set the profile option to No or Null and the currency is disabled: Batches with a disabled currency will fail during journal import.
Sign on to Oracle Applications as an Application Developer.
Navigate to the Define User Profile Option window.
Complete the following:
Name: GL_JI_IGNORE_CURRENCY_DATE
Applications: Oracle General Ledger
User Profile Name: GL Journal Import: Bypass Currency End Date
Description: To bypass journal import's currency end date validation.
SQL:
SQL="select meaning IGNORE_DATE, lookup_code into :visible_option_value, :profile_option_value from fnd_lookups where lookup_types='YES_NO'"COLUMN="IGNORE_DATE(*)"
Set the profile option, GL Journal Import: Bypass Currency End Date to Yes at the site, application, responsibility, or user level.
Save your work.
Note: The default value of this profile option is Null. You must set it to Yes to enable the Journal Import Currency End Date Bypass feature.