Mass Allocations For Entered Foreign Currency Balances (Doc ID 1145305.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.
The allocation journal is not creating CAD currency in the CAD ledger, after conversion of the USD balances into CAD using the Corporate Rate.

Reviewed for currency on 10th June 2013.

Symptoms

You want to use USD balances in Line A for allocation. The results of A*B/C which is in USD should then be converted into CAD using the Currecny Conversion type and rate for the JE date to generate the final Mass Allocation JE in CAD (NOT USD). CAD is the functional currency of the Ledger.

The Mass Allocation is calculating the USD amount (A*B/C) but is NOT applying the Currency conversion and hence, the JE is created in CAD ledger but with the wrong value of for the CAD amount. This is because the corporate rate is not being used. Instead, the currency is converted as 1:1 between USD and CAD.
Please note that USD and CAD are currencies taken for the example. It can be any two currencies.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms