You must generate recurring journals to create unposted journal entries from the recurring journal formulas you defined. After generating the formulas, you can review or edit the recurring journal batches before posting them.
You must have read-only or read and write access to the ledger and the balancing segment value or management segment value used in the recurring journal formula to generate recurring journals. Even though, you defined a recurring journal formula, recurring journals can only be generated for ledgers, balancing, or management segment values you have access to through your current responsibility's data access set. If you have insufficient access to the ledger or segment value, the recurring journal formula will not generate journals. See Data Access Sets.
When you generate recurring journals from the recurring journal definition or from the Generate Recurring Journals window for average daily balance ledgers, you can set the profile option, GL: Number of Formulas to Validate for each Recurring Journal Batch, to validate your recurring journal batch before running the generation program for any average balancing processing violations with the calculation effective date or average balance usage. The window checks the number of formulas in the batch based on your profile option setting and displays an error message if any violations are found. The default value for the profile option is 5. Any other violations are detected during the generation program. For additional information, see Setting General Ledger Profile Options.
Prerequisite
Define your recurring journal entry formulas.
Set the profile option, GL: Number of formulas, to validate for each Recurring Journal batch if you are using average daily balance ledgers. See Setting General Ledger Profile Options.
Navigate to the Generate Recurring Journals window.
(Optional) If you have average balance processing enabled and your ledger is a consolidation ledger, select a Usage. Select Standard Balances to create recurring journals that update standard balances only. Select Average Balances to create recurring journals that update average balances only.
Choose the Submission Details tab to enter values for the recurring journals you want to generate. Choose the Last Run Details tab to see the values that you used the last time you generated the recurring journals.
Select the recurring batches you want to generate. You can only choose to generate recurring batches if you have use privileges to the batch through your definition access sets.
For recurring batch type Single Ledger, the recurring batches will only appear if you have access to the ledger (read, read and write) based on your data access set privileges.
For recurring batch type Multiple Ledgers, the recurring batches will only appear if you have access to at least one ledger (read, read and write), based on your data access set privileges.
Enter the accounting Period for which you want to create an unposted journal batch.
Enter a Journal Effective Date. General Ledger automatically enters the nearest day of the period. You could enter any date within the specified period for a standard ledger. If you have average balance processing enabled for your ledger, you can enter any valid business day, unless your ledger is a consolidation ledger. In this case, General Ledger automatically enters the first day of the period if and you cannot change the value.
Note: You can also enter non-business days if you have set the profile option Journals: Allow Non-Business Day Transactions to Yes.
Enter a Calculation Effective Date. General Ledger automatically enters the nearest day of the period. You can change this to any day in any open, closed, future enterable, or permanently closed period. If you don't have average balance processing enabled, the calculation effective date is ignored for a standard ledger.
(Optional) Choose the Recurring Journal button to review the batch definition. You can generate your recurring journal batch from this window.
If you have a recurring journal entry formula that uses budget balances to calculate journal amounts, enter the Budget name.
(Optional) Schedule your Recurring Journal batch. See: Scheduling your Recurring Journal batch.
Choose Generate. General Ledger submits a concurrent process to create unposted journal batches based on the selected recurring journal formula batches. Note the Request ID assigned to the concurrent process.
Review the Recurring Journals Execution Report. General Ledger names the resulting journal batch as follows: <Recurring Batch Name>: <Date> <Time>. For example, Project Expense: 15-JAN-95 16:36.
You can only generate recurring journals for recurring journals formulas that you have read only or read and write access to through your current responsibility's data access set. For the recurring journal line formulas, you must have at least read-only access to the ledger value or balancing and management segment values specified to retrieve its balances. For the ledger value specified at the batch-level or journal line-level or the balancing or management segment value specified at the journal line-level, you must have read and write access to generate recurring journals for the ledgers.
If you generated skeleton journal entries, use the Enter Journals window to complete the journal information.
Review your generated journals.
The Conversion region of the Enter Journals window displays the conversion information your generated recurring journal. The table below details how your generated journals are displayed.
Currency Recurring Journals
| Currency | Type | Rate | Description |
|---|---|---|---|
| Ledger currency | User | 1 | Journals are based on the ledger currency balances. No conversion is necessary. |
| STAT | User | 1 | No conversion necessary. |
| Entered currency | Conversion rate specified | The daily rate between the entered transaction currency and the ledger currency for the journal effective date and the conversion rate type | The conversion rate used to calculate the accounted amount is the daily rate between the entered transaction currency and the ledger currency. |
Post the generated recurring journal batches to update account balances.
You can generate your Recurring Journal Batch according to schedules in Oracle Applications, schedules you define in Oracle Applications, or schedules you define in General Ledger.
Navigate to the Recurring Journal Parameters window.
Complete the following fields:
Name: Enter or choose a name for the Recurring Journal you want to schedule from the list of values.
Period: Enter an accounting period or choose from the list of values.
Budget: Enter a budget or choose from the list of values.
Note: The Budget field is enabled only if a Recurring Journal batch that uses a budget.
Journal Effective Date: Enter a journal effective date.
Note: General Ledger automatically enters the nearest day of the period. You can enter any date within the specified period for a standard ledger. If you have average balance processing enabled for your ledger, you can enter any valid business day unless your ledger is a consolidation ledger. In this case, General Ledger automatically enters the first day of the period and you cannot change the value.
Calculation Effective Date: Enter a calculation effective date.
Note: General Ledger automatically enters the nearest day of the period. You can change this to any day in any open, closed, future enterable, or permanently closed period. If you don't have average balance processing enabled, the calculation effective date is ignored for a standard ledger.
(Optional) Usage: Select a usage if you have average balance processing enabled and the ledger is a consolidation ledger.
The Ledger and Balancing Segment Value fields are disabled for the recurring journals feature. These fields are only applicable to the MassAllocations feature.
Choose the Schedule button.
The Oracle Applications Submit Request window opens.
Choose the Schedule button.
The Schedule window opens.
You can create your own schedule by completing the regions in this window. For more information, see: Oracle E-Business Suite User's Guide.
Or, choose the Apply a Saved Schedule button to select from a set of Oracle Applications or General Ledger pre-defined schedules.
Return to the Submit Request window and submit your request.
Note: You must post the Recurring Journal batch after it is generated.