Unable To Filter Using Revenue Recur Start Date in Report (Doc ID 3007746.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

On : 11.13.23.10.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Custom OTBI report for Opportunities using Sales CRM Pipeline subject area, customer wants to filter using Recur Start Date filter using Year. But No results appear
But when they filter using either Revenue Creation Date - Year or Opportunity Creation Date - Year, they are seeing the results.

EXPECTED BEHAVIOR
-----------------------
Expected to see results filtering by Recur Start Date

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a custom report using Sales CRM Pipeline
2. Add Filter
3. No Results display
4. Change the filter either Revenue Creation Date - Year or Opportunity Creation Date - Year
5. results appear

Example of query:

SELECT
"Sales - CRM Pipeline"."Opportunity"."Sales Method" s_1,
"Sales - CRM Pipeline"."Opportunity"."Sales Stage Name" s_2,
"Sales - CRM Pipeline"."Revenue"."Revenue Recur Start Date" s_3,
"Sales - CRM Pipeline"."Pipeline Detail Facts"."# of Opportunity Revenue Lines" s_7,
"Sales - CRM Pipeline"."Pipeline Facts"."# of Closed Opportunities" s_8,
"Sales - CRM Pipeline"."Pipeline Facts"."# of Opportunities" s_9,
"Sales - CRM Pipeline"."Pipeline Facts"."Opportunity Revenue" s_10,
"Sales - CRM Pipeline"."Sales Cycle Facts"."Average Days at Stage" s_11,
"Sales - CRM Pipeline"."Sales Cycle Facts"."Average Sales Cycle" s_12,
"Sales - CRM Pipeline"."Win Loss Facts"."Win Rate" s_13
FROM "Sales - CRM Pipeline"
WHERE
(((DESCRIPTOR_IDOF("Sales - CRM Pipeline"."Opportunity"."Sales Method") = '300000000215302')) AND (YEAR("Sales - CRM Pipeline"."Revenue"."Revenue Recur Start Date") > 2019))

Changes

Cause

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