OTBI Contracts Report Returns Incorrect "Contract Amount" And "Contract Invoice Amount" (Doc ID 2241300.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Fusion Enterprise Contracts - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Analytics

ACTUAL BEHAVIOR
----------------------------
OTBI Report to show contract amount and contract invoice amount shows incorrect amount.

Customer wants to create an OTBI report to show the following information

1. Contract Number
2. Contract Header Name
3. Contract Amount
4. Contract Invoice Amount

These columns were taken from dimensions from Contract Header and Contract Header Details.
Both Contract Amount and Contract Invoice Amount get doubled.
The doubling happens when we add Contract Invoice Amount.


EXPECTED BEHAVIOR
---------------------------------
Contract Amount and Contract Invoice Amount show the correct values after including Contract Invoice Amount.


STEPS
-----------------------
Create an OTBI report to show the following information

1. Contract Number
2. Contract Header Name
3. Contract Amount
4. Contract Invoice Amount

These columns are taken from dimensions from Contract Header and Contract Header Details.


BUSINESS IMPACT
---------------------------
Incorrect Contract Amounts reported could mean that customer is unable to use BI to show Contract Amount information.

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