My Oracle Support Banner

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

Last updated on MARCH 22, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.