Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

'Analytics Currency' improvements

Needs Votes
78
Views
1
Comments
Andrew at MKL
Andrew at MKL Rank 6 - Analytics Lead

Request to add additional detail to Analytics Currency as follows:

1.) Nuance to apply of Period End and Period Average rates for Balance Sheet and Income Statement accounts, respectively. At present, we can only select on or the other, so we wind up with variances to our ERP and FCCS GAAP USD valuations on one of the Balance Sheet or Income Statement depending on which rate type is selected in our setup.

2.) Ability to have more than one Analytics Currency available (e.g. In addition to USD, we would like to have translated GBP, EUR, and CAD valuations made available)

3.) Ability to use for Remeasurement in addition to Translation. Currently, Analytics Currency only supports translation of Functional Currency balance values to a Translated valuation and we would like to be able to Remeasure from Entered Currency valuations to different Functional Currency valuations. This may require an additional Fact (e.g. 'Analytics Currency - Translation' vs 'Analytics Currency - Remeasured', or some other naming convention), as the offsets need to be represented as part of the Realized G/L due to FX acct on the Income Statement instead of CTA on the Balance Sheet.

13
13 votes

Needs Votes · Last Updated

Comments