My Oracle Support Banner

R12: No Data For Query From SA "Marketing - CRM Leads And Opportunities Real Time" (Doc ID 2375562.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
When attempting to report on Leads and Opportunities converted from Leads, report shows no results

EXPECTED BEHAVIOR
-----------------------
Expected to see the list of opportunities converted through Leads

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create new analysis
2. set SELECT
  0 s_0,
  "Marketing - CRM Leads AND Opportunities Real Time"."Lead"."Lead Id" s_1,
  "Marketing - CRM Leads AND Opportunities Real Time"."Opportunity"."Opportunity ID" s_2,
  "Marketing - CRM Leads AND Opportunities Real Time"."Dummy Fact"."Dummy Fact" s_3
FROM "Marketing - CRM Leads AND Opportunities Real Time"
WHERE ("Lead"."Lead Id" IN ('300000093447919',
'300000094970999',
'300000094321374',
'300000094819017',
'300000094006029'))
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

 

Those Leads were converted and can be seen in UI
3. Click Results
4. No records found

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see Opportunities converted from Leads

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.