Assigning Reporting Currencies to Ledgers

If reporting currencies are assigned to ledgers when creating an accounting setup structure, the status for the Reporting Currencies step is In Process. To complete the accounting setup, update the reporting currency and complete the conversion options for all reporting currencies that are assigned.

If no reporting currencies are assigned to the ledgers when creating the accounting setup structure, the Reporting Currencies step is not required and the status is Not Started.

Add reporting currencies to accounting setups at any time.

Additional Information: Adding Reporting Currencies

To complete reporting currencies:

  1. In the Accounting Options page, click the Update icon for a reporting currency.

  2. Update each reporting currency.

  3. Enter all relevant fields for the reporting currency.

    The following table describes selected options for balance level reporting currencies.

    Selected Options for Balance Level Reporting Currency

    Field Description
    Currency Conversion Level Balance defaults to indicate that this is a balance level reporting currency; cannot be changed
    Period End Rate Type Translates actual account balances; defaults from the source ledger; can be changed
    Period Average Rate Type Translates actual account balances; defaults from the source ledger; can be changed

    The following table describes selected options for journal and subledger level reporting currencies.

    Selected Options for Journal and Subledger Level Reporting Currencies

    Field Description
    Currency Conversion Level Indicates that this is a journal level or subledger level reporting currency
    Status If disabled, data is no longer automatically converted to the reporting currency.
    First Ever Opened Period The first period that can be opened for this reporting currency; defaults from the source ledger
    Rounding Differences Tracking Account In General Ledger, this account tracks rounding differences that occur during currency conversions. If you do not enter an account, General Ledger will post rounding differences to the journal line with the largest amount.
    If your foreign currency transactions include different balancing segment values to represent multiple companies, General Ledger will automatically create a rounding differences account for each balancing segment value.

    Warning: Any changes you make to the Rounding Differences Account in the source ledger will automatically be applied to all of its journal and subledger level reporting currencies. If you have a different rounding differences account assigned to your reporting currencies and you change the rounding differences account for the source ledger, such as removing one, changing one, or adding one, be sure to also update the rounding differences account for each of the reporting currencies.

    Enable Journal Approval Use General Ledger's Journal Approval feature for this reporting currency.
    When enabled, Journal Approval only applies to journals that are entered directly to the reporting currency, such as manually entered journals or journals loaded directly to the reporting currency. Journal Approval will not apply to journals that were automatically converted from the source ledger by General Ledger Posting.

    Note: When you enable Journal Approval, only journal entries that use actual amounts and the Manual journal source will automatically have Journal Approval enabled. To require journal approval for budget or encumbrance journals or for journals using a source other than Manual, you must mark the Require Journal Approval check box for the appropriate journal source in the Journal Sources window in Oracle General Ledger.

    Additional Information: Setting Up Journal Approval

    Rounding Differences Tracking Account In General Ledger, this account tracks rounding differences that occur during currency conversions. If you do not enter an account, General Ledger will post rounding differences to the journal line with the largest amount.
    If your foreign currency transactions include different balancing segment values to represent multiple companies, General Ledger will automatically create a rounding differences account for each balancing segment value.

    Warning: Any changes you make to the Rounding Differences Account in the source ledger will automatically be applied to all of its journal and subledger level reporting currencies. If you have a different rounding differences account assigned to your reporting currencies and you change the rounding differences account for the source ledger, such as removing one, changing one, or adding one, be sure to also update the rounding differences account for each of the reporting currencies.

    Default Rate Type The conversion rate type used to retrieve exchange rates for converting transactions from the source ledger to this reporting currency
    This differs from the conversion rate type specified when entering a transaction. Oracle Applications use the transaction conversion rate type to retrieve exchange rates for converting entered amounts from the transaction currency to the ledger currency. Alternatively, users can specify their own rate type.
    The Default Rate Type works with the Retain Transaction Rate Type field. If you choose not to retain the same rate type used to convert the original transaction, the Default Rate Type is used instead.

    Additional Information: Defining Conversion Rate Types

    Retain Transaction Rate Type Controls the conversion rate type that should be used to convert transaction currency amounts from the source ledger to this reporting currency.
    • If Yes is selected, then the conversion rate type used to enter the transaction in the source ledger will be retained when converting the same transaction from the transaction currency amount to this reporting currency.

      Note: If the original transaction rate type is User or EMU Fixed, the default rate type assigned to the reporting currency will always be used.

    • If No is selected, then the default rate type specified in the Default Rate Type field will be used to convert transactions to this reporting currency.

      The Retain Transaction Rate Type option is ignored for the following reasons:

      • An EMU fixed rate relationship exists between the transaction currency and the currency of the reporting currency. In this case, the EMU Fixed conversion rate type is used.

      • The transaction currency is the same as the currency of the source ledger, such as the primary or secondary ledger. In this case, a conversion rate type does not exist for the transaction and the default rate type is used.

      • The transaction currency is the same as the currency of the reporting currency. In this case, the User conversion rate type is used with a default rate of 1.

      • A User rate is used for the transaction. In this case, the User conversion rate type is used. The reporting currency conversion is completed in two steps via the default rate type assigned to the reporting currency.

        Note: If the Account Type Specific Conversion is enabled, you can determine whether Accounting Setup Manager should inherit the conversion type used in the source ledger.

    Missing Conversion Rate Controls what the system should do if it cannot find a conversion rate as of the conversion date
    • If Report an Error is selected, the system will report an error and prevent a transaction or journal from being posted in the source ledger; a conversion rate will need to be specified to successfully convert data entered in the source ledger to this reporting currency.

    • If Use Last Rate is selected, the system will use the last rate defined for a particular rate type if it cannot find a currency conversion rate; if enabled, specify a number for the Number of Days to Find the Last Rate.

    Number of Days to Find Last Rate Indicates how many days back in time the system should look to find a rate; enter a number from 1 to 999.
    Retain Journal Creator from Source Ledger Controls the Created By user information that can be viewed for each journal using Help > Record History
    • Select Yes to retain the person who entered the journal in the source ledger as the Created By user.

    • Select No to indicate the person who posted the journal as the Created By user.

  4. Click Apply.

Related Topics