Browser version scriptSkip Headers

Oracle® Fusion Accounting Hub Implementation Guide
11g Release 1 (11.1.2)
Part Number E20374-02
Go to contents  page
Go to Previous  page
Go to previous page

5 Define Period Close Components

This chapter contains the following:

Period Close Components: Explained

Manage Allocations and Periodic Entries

Manage Revaluations

Manage Period Close

Period Close Components: Explained

While implementing your accounting configuration, optionally define and maintain the period close components to customize your accounting configurations setup.

Period close components include allocations, period entries, revaluation, and historical rates.

If you use allocations, revaluation, or translation, configure the following tasks under the Define Period Close Components parent task in your implementation project:

Manage Allocations and Period Entries

Manage Allocations and Period Entries is a manual task in the implementation project. Use the Allocation Manager to create allocations and other formulaic journal templates for generating periodic journal entries automatically. Base formulas on multiple criteria.

You must perform an external procedure outside the Setup and Maintenance work area to complete this task. In order to setup your allocations rules, navigate to the Journals work area and click the Create Allocations Rules task from the Tasks pane. This task navigates you to Allocation Manager, a framework that enables you define your allocation rules and formulas using a graphical interface and intuitive step-by-step wizards.

Manage Revaluations

Defines currency revaluation options, such as the range of accounts to revalue and the gain or loss accounts. Revaluation is done to adjust foreign entered amounts due to currency fluctuations. Navigate to the Manage Revaluations page, and define and generate your revaluation definitions.

Manage Historical Rates

Historical rates are the weighted average rate for transactions that occur at different points in time. Used by the system to calculate the conversion rate on equity account balances during foreign currency translation of the balance sheet.

Navigate to the Currency Rates Manager page to define and maintain your historical rates that are used in the translation process. In Oracle Fusion General Ledger, you can currently define historical rates using an ADF Desktop Integrator spreadsheet.

To create new historical rates, specify the required Ledger and the other optional fields, as needed. Click the Create in Spreadsheet button to open the spreadsheet for uploading.

To update the existing historical rates for your ledgers, click the Edit in Spreadsheet button, the spreadsheet is prepopulated with the existing historical rates.


Before using the historical rates spreadsheet, install the ADF Desktop Integrator client as an add on to Microsoft Excel.

Manage Allocations and Periodic Entries

Allocation and Periodic Entries: Overview

In Oracle Fusion General Ledger, use the Allocation Manager to create allocations and other formulaic journal templates for generating periodic journal entries automatically. Base formulas on multiple criteria. For example, use account balances or statistical amounts to allocate shared revenue or costs across multiple organizational units and ledgers. Define complex computations based on variables from different charts of accounts. Group journal formulas together and execute sequentially to update account balances in a step-by-step process.

The Allocation Manager provides flexibility, automation, intelligence, and control in distributing costs and revenues across the enterprise. In addition, the Allocation Manager:

Access the Allocation Manager from the Tasks pane of the General Accounting dashboard or Journals work area by clicking on the:


For more information, see:

Generating Allocations and Periodic Entries Manually: Worked Example

This example demonstrates how to generate an allocation or periodic entry manually from the Oracle Fusion General Ledger.

You are the General Accountant for Infusion America Inc. You have created allocation and periodic journal entry definitions for several monthly entries. You now generate these entries.


Schedule allocations and periodic entries in the Journals work area for automatic generation.

Prior to generating the allocation and periodic entries, the following tasks must be completed:

Generating Allocations and Periodic Entries Manually

  1. From the Navigator, click the Journals link to open the Journals work area.
  2. In the task pane of the Journals page, click the Generate Allocations link to open the Submission page.
  3. Optionally select one or all of the following options:
  4. Select a rule or rule set from the list of values.
  5. Enter the submission parameters, including Ledger, Balancing Segment Value, and Period. The application automatically sets the last day of the submission period as the Accounting Date and Calculation Effective Date.
  6. Accept the selected check box for the Post Allocations option to enable the process to post the journal entries.

    If you deselect the check box for the Post Allocations option, you must post the entry manually or define an AutoPost Criteria Set to automatically post the journal entries.

  7. Click Submit.

    After the generation process is complete, the journal entries created by the process are available for inquiry on the Journals page.

Manage Revaluations

Revaluation Process: Explained

The revaluation process is used to adjust account balances denominated in a foreign currency. Revaluation adjustments represent the difference in the value of the balance due to changes in conversion rates between the date of the original journal entry and the revaluation date. These adjustments are posted through journal entries to the underlying account with the offset posted to an unrealized gain or loss account. All debit adjustments are offset against the unrealized gain account and all credit adjustments are offset against the unrealized loss account. If the same account is specified in the Unrealized Gain Account and Unrealized Loss Account fields, the net of the adjustments is derived and posted.

For balance sheet accounts, the revaluation journal entries are reversed in the next period. AutoReverse can be used to automate the reversals. For income statement accounts that use the PTD method of revaluation, the revaluation journal entries aren't reversed since each period's revaluation adjustment is just for that period.

In Oracle Fusion General Ledger, the revaluation functionality provides the following advantages:


When defining your revaluations, perform the following:


Income statement accounts can also be revalued using YTD method.

Hierarchies and flexible account selection criteria, such as usage of parent values from your account hierarchy, streamlines maintenance of revaluation definitions. Leveraging hierarchy versions extends your revaluation definitions during organizational changes. Adjust account selection criteria monthly to retrieve the accounts that need to be revalued for the current accounting period.

Share revaluation definitions across ledgers that have the same chart of accounts to reduce maintenance.


Generating revaluations include:

Always run revaluation to bring monetary balances to current rates before performing currency translation or remeasurement.

Revaluation Execution Report

The Revalue Balances program automatically generates the Revaluation Execution report when you run revaluation. This report shows the details of your account balance revaluation and the journal batches created after running revaluation. The report includes the currencies and revaluation rates used to revalue your accounts, the unrealized gain or loss account in which you recorded net gains and losses, and the range of accounts revalued. The report also prints the names of your batch and journals that the revaluation program creates for each foreign currency, as well as the total debits and credits of the created entries.

If the Revaluation process cannot locate rates for one or more currencies, balances are not revalued for those currencies. In this case, the Revaluation process completes with a warning and the execution report lists which currencies are missing rates.

Accounting for Unrealized Gain or Loss on Revaluation: Explained

Revaluation launches a process that revalues the ledger currency equivalent balances for the accounts and currencies you select, using the appropriate current rate for each currency. Resulting unrealized gain or loss amounts are posted to the unrealized gain or loss accounts or to the cumulative translation adjustment (CTA) account you specify, and are balanced by balancing segment values. This process creates a revaluation journal which can be posted automatically.

Oracle Fusion General Ledger creates journal entries to adjust the ledger currency balances for conversion rate fluctuations, in accordance with Statement of Financial Accounting Standards (SFAS) No. 52, Foreign Currency Translation and International Accounting Standard (IAS) 21, The Effects of Changes in Foreign Exchange Rates.

The revaluation journal entries generated and posted in the primary ledger are automatically generated, converted, and posted to each of their reporting currencies. Define the CTA account for unrealized gains or losses in the reporting currency prior to running revaluation.

Income Statement Accounts Revaluation Rule: Explained

Revaluation is the process which adjusts asset or liability accounts that may be materially understated or overstated due to a fluctuation in the conversion rate between the time the transaction was entered and the time revaluation takes place. You may want to revalue income statement accounts as well. The Income Statement Accounts Rule indicates whether period-to-date (PTD) or year-to-date (YTD) method is to be used when revaluing income statement accounts.

Click the Income Statement radio buttons on the Create Revaluation page to specify whether you want to revalue income statement accounts using PTD or YTD balances. There are two radio buttons, one for PTD and one for YTD.

If you select to revalue PTD balances for income statement accounts, the program continues to appropriately revalue YTD balances for balance sheet accounts. In the revaluation definition if the range of accounts consists of both income statement and balance sheet accounts and you select PTD as an option for income statement account revaluation rule, a separate revaluation journal is created for the income statement accounts. Revaluing the PTD balance of your income statement accounts creates weighted average YTD balances using period rates from each corresponding period against the PTD account balance in compliance with the Statement of Financial Accounting Standards (SFAS) No. 52, Foreign Currency Translation.

To summarize, when you run revaluation on your income statement accounts, the program produces two separate journal entries; one that revalues your balance sheet accounts and another for your income statement accounts. You do not need to reverse the PTD revaluation journal entry for your income statement accounts in the subsequent period since that revaluation only applies to last period's activity.


This functionality only applies when the range of accounts to be revalued in the revaluation definition consist of income statement accounts in addition to balance sheet accounts. Normally only balance sheets accounts are revalued.

Revaluing Across Multiple Balancing Segments: Worked Example

This example demonstrates how to revalue foreign currency balances across multiple balancing segments. Your company, InFusion America, Inc. has three lines of business. You revalue your foreign currency account balances for two of your divisions, Air Components and Repair Parts. Your Installation Services line of business does not have foreign currency transactions. Your company is your primary balancing segment and your lines of business are represented in your secondary balancing segment.


Enable up to three balancing segments to use the multiple balancing segment feature.

The following are points to consider in running the revaluation process.

Defining Revaluations

  1. From the Manage Revaluations page, click the Create icon.
  2. Enter the values in the following table in the correct fields.




    InFusion America Revaluation


    Revaluation for all foreign currency balances.

    Chart of Accounts

    InFusion America Chart of Accounts


    Leave blank


    If left blank, all currencies are revalued and after saving, the field automatically displays: All currencies.

    Conversion Rate Type


    Days to Roll Forward


    Unrealized Gain Account


    Unrealized Loss Account


    Income Statement Account Basis


    Post Automatically


  3. In the Revaluation Accounts region, click the Add Row icon.
  4. Click the Change filter conditions icon to enter the filter used to select the accounts to revalue.
  5. Click the Add Field drop down arrow and select your company, InFusion America Inc. from the list.





  6. Click the Add Field drop down arrow and select your two Lines of Business: 30 for Air Components and 40 for Repair Parts.

    Note: Your Installation Services line of business, 50, is not included because it does not have foreign currency transactions.






  7. Click the Add Field drop down arrow and select Account from the list.






  8. Click OK to accept your filters.
  9. Click the Save and Close button to save your revaluation.

    Optionally, select the Save and Generate buttons to run the revaluation immediately.

Manage Period Close

Opening First Period: Overview

For all ledgers, primary, secondary, and journal and subledger level reporting currencies, open the first period of the ledger when you are ready to transact in that period.

To open the first period of your ledgers, navigate to the Open First Period task in the primary ledger task list and click the Go to Task icon. On the submission page, select the ledger and the period to open. Click the Submit button to launch the open period process.

There are other ways to open the first period or subsequent periods without going into the Setup and Maintenance work area. You can maintain the ledgers' period statuses from the: