"Fund Request Amount" Fact is returning a negative value for random rows. (Doc ID 2245467.1)

Last updated on MARCH 31, 2017

Applies to:

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

Symptoms

On : NA version, Analytics


ACTUAL BEHAVIOR
-----------------------------
Issue seems like data corruption.

Customer is using a Fact column in an OTBI report, but the Fact column is showing a negative value for certain transaction records.

"Sales - CRM MDF Request"."MDF Request Fact"."Fund Requested Amount" is the Fact column in question.

They tried to query the BI tables as well for the same column, but it seems to have the correct value saved.

The customer's BI currency preference is "Default - ", which is equivalent to "User Preferred Currency using Simple Currency Management". The customer's Fund Requests having negative Fund Request transaction (Fact column) amounts have 'CAD' as their currency of these transactions.
Customer's global, or CRM currency (ZCA_COMMON_CURRENCY) is USD.



EXPECTED BEHAVIOR
---------------------------------
Fact column in BI Subject Area should show the correct values.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run an analysis using Logical SQL similar to the following:
===============================================
SELECT
  "Sales - CRM MDF Request"."MDF Request Fact"."Fund Requested Amount" s_1,
FROM
  "Sales - CRM MDF Request"


BUSINESS IMPACT
----------------------------
Issue appears to be data corruption.
Issue seems to affect only users who

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