Currency Conversion For All Revenue Fields In OTBI (Doc ID 2240203.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

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
 

Solution

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