Split Revenue Lines Not Showing Correct Values In Reporting (Doc ID 2231237.1)

Last updated on FEBRUARY 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.

Symptoms

On :  11.1.11.1.0 version, Sales, Sales Catalog

ACTUAL BEHAVIOR  
---------------
Revenue Lines not representing correct values in reporting when split lines are used 
Opportunity has a custom field in the revenue line which is showing incorrect settings for the field in BI reports.

For example: One revenue line has the custom field set to 'Hardware' while another line in the same opportunity has it set to 'Services'.
The BI report shows both lines set to Services.

Custom field has a default value set (Services).




EXPECTED BEHAVIOR
-----------------------
BI report should show the custom field in both revenue line correctly. The report should show one line as 'Hardware' and the other as 'Services'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Application Composer > Sales > Opportunity > Opportunity Revenue > Fields
2. Create a custom fixed choice list field (set a default value)
3. Add the field to the revenue line
4. Create an opportunity with two revenue lines. Set the custom field to a value on both (Hardware and Services).
5. Run a BI report to see the revenue lines for the opportunity. Report shows both lines set to Services


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