Symptom
When using the Opportunity Activity Report (CODOACTB_Q0001), you notice that some opportunities are missing.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Open the system and go to the Business Analytics work center.
- Search and open the Opportunity Activity Report (CODOACTB_Q0001).
- Select the relevant fields that should bring you the opportunity e.g. Close Date.
- Even if the date and other selection variables are correct the opportunity is not showing in the report.
Cause
The opportunity does not contain any follow-up activities, however the data source All Activities with Predecessor Opportunities (CODOACTB) and the Opportunity Activity Report (CODOACTB_Q0001) only show those opportunities with follow-up activities.
This is the currently Designed behavior of this Data Source and report.
Resolution
In order to have this opportunity appearing in this specific report, you must add an activity. Alternatively, you may check other data sources such as Opportunity Header and Item.
Keywords
Report Opportunity Activity, Opportunity not shown, CODOACTB_Q0001, CODOACTB, Copy of Opportunity , KBA , LOD-CRM-OPP , Opportunity Management , Problem