Journal Import in Oracle

For All the entries in the subledger modules , the data will be transferred to the GL and subsequently  journals will be created and posted.
In order to create journals in Oracle the data should be present in GL_INTERFACE , once the data is loaded into the GL_INTERFACE the Jounal Import programs "Import Journals" needs to be submitted.

Data can come into GL_INTERFACE either from the Subledgers eg :AP/AR/INV or uploaded by Web ADI.
Once the data is available in GL_INTERFACE , launching Jounral import will pick up data for the Ledger for which the program is run , validate the data and create journals.

Some of the important points to remember when running Journal Import :

• Group Id : When you are running Journal Import you can import data for multiple sources by specifying the Group Id Pramater. When specified journal import will process only the records of the specified Group Id. If the Group Id is not provided then Journal Import will only process the records for which Group Id is not specified ie Group ID NULL , records with group id will be left un-processed
• Chossing : Import Descriptive Flexfields, and whether to import them with validation : If we are not creating Summary Journals then we can choose to import the Descriptive Flexfields . Here we can choose to import DFF with our without validation . With Validation Imports journals only if the Descriptive Flexfields pass the validations or you can choose to import journals without Flexfiled journals  where Oracle will not validate the DFF and generate all the journals

Journals in Oracle

Journal entries are the entering/recording of financial transactions and their monetary value in the transaction accounts of the accounting journal as debits or credits.

Journal entry is strating point of the accounting cycle , Journals are first created for any accounting entry and are then take forward.

For a business any transaction that affects the finances of the business needs to be recorded in the general ledger with proper accounting entries. Oracle creates journal entries for these transactions. Each transaction will have minimum 2 entries one debit and other credit to keep a track of the transaction and its financial impact.

In a complete EBS setup Oracle will receive journal transaction details from various modules:

• Purchasing
• Payables
• Assets
• Receivables
• Work In Progress
• Inventory
• Payroll
• Projects

Using the functionalities provided in EBS we can perform a number of actions on journals

• Creating journal entries
• uploading journals
• import journals
• Reverse journals
• Post journals
• Journal inquiry
• drill down to subledgers
• Run Reports

Types of Journal Entires:

1. Basic Journal Entries: This type of journal entry is used for most journal transactions to record revenues,expenses,accruals , adjustsments and re-classifications. 
2. Reversal Entries: These journals are created for reversing an error, revaluation or encumberance journals. The reverse journals are created either by switching debits and credits or by changing the signs. The reverse entires can be posted in the same or a future acccouting period
3. Recurring Entries : There might be scenarios where some transaction journals will be created on a recurring basis. Recurring journals can be defined for automatic consolidation and elimination of such journals
4. Mass Allocation: Journal entries that utlize a single journal entry to allocate revenues,expenses across a set of centers,departments etc.

Journal Creation Methods :

Journal Import: This is one of the commonest method of Journal creation in which the data is populated into the GL Interface by the different modules or third part systems and then journal is created by running the journal import process.

Web ADI : Another method of journal creation is to upload the data via Web ADI through spreadsheets which will create journals.

Manual: As the name suggests is the journal creation method in which Journals are manually created by the users using the oracle screen

Journal parts:

When Journals are created in the system it will be affecting 3 tables: gl_batches , gl_je_headers and gl_je_lines

When ever a journal is created the system will create a journal batch in which this journal will be included..

Each journal will have 1 journal header and 2 or more journal lines.

The journal header will have details of the journal header and the lines will have details of the journal line ie which accounts have been affected by the journal by which amounts and the debit  or credit amounts.