Currency Conversion For All Revenue Fields In OTBI
Last updated on MARCH 07, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
In OTBI we need to have the possibility to use Auto Currency conversion for all Revenue fields (standard as well as custom).
Current functionality is insufficient as it allows only currency conversion for Revenue fields which are mentioned in the facts.
There is a workaround available to use formulas like "Opportunity Extension"."Extension Attribute Number 002" * "CRM Currency Conversion rate" * VALUEOF(NQ_SESSION.USER_PREFERRED_CURR_Conversion_Rate).
A. Negative impact on performance - we have 10 custom revenue fields on opportunities
B. Issues due to rounding - using this formulas, we get rounding differences (if opportunity currency = reporting currency - value should be taken over as it's displayed in UI)
C. Very complex to use these formula for every report / field + high risk to overlook it and produce
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