Format Value Is Not Working For Total Columns And Measures (Doc ID 2118125.1)

Last updated on MARCH 23, 2016

Applies to:

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

Goal

On : 11.1.9.2.0 version, Technology Management - Reports/Analytics


While running an analysis and in the output when displaying the sum (Grand total and numeric values), he is editing the compound layout, (Columns and Measures section), Format values are not working on the column "Billable Contract Price" Dimension, which customer is using from Opportunity Extension dimension folder and is not a fact.

SQL issued: SELECT

0 s_0,
"Sales - CRM Pipeline"."Opportunity Extension"."Extension Attribute Number 009" s_1,
"Sales - CRM Pipeline"."Opportunity"."Corp Currency Code" s_2,
"Sales - CRM Pipeline"."Pipeline Facts"."Opportunity Revenue" s_3,
REPORT_SUM("Sales - CRM Pipeline"."Opportunity Extension"."Extension Attribute Number 009" BY ) s_4,
REPORT_SUM("Sales - CRM Pipeline"."Pipeline Facts"."Opportunity Revenue" BY ) s_5
FROM "Sales - CRM Pipeline"
WHERE
(((CAST("Opportunity"."Owner Resource ID" AS CHAR) = VALUEOF(NQ_SESSION.USER_PARTY_ID)) OR ("Employee"."Employee Name" = 'Gilles DE OLIVEIRA')) AND ("Opportunity"."Sales Stage Name" = 'Closed/Won') AND (YEAR("Opportunity"."Effective Date")=YEAR(CURRENT_DATE)) AND ((WEEK("Opportunity"."Effective Date")=WEEK(CURRENT_DATE)) OR (WEEK("Opportunity"."Effective Date")<=WEEK(CURRENT_DATE))))
ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

Please help in this regard.

 

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