Search for existing answers to your product and support questions.
Familiarize yourself with our support site and learn best practices in working with our team.
Manage Service Requests, View and update service requests submitted by you and others in your organization.
Submit a new issue to our technical support team.
Oracle B2C Service insights from our Technical Support team subject matter experts
Browse resources to assist you in launching your implementation and ensure a successful go-live.
Access your OCI account.
Find product documentation for supported versions of B2C and documentation libraries for related service solutions.
You will have the tools to improve your customers' experience when you learn about all the things our products can do.
Find links for API documentation, Custom Processes, Customer Portal, and Agent Browser UI Extensibility Framework.
Explore how accelerators are designed to demonstrate how an integration scenario could be built using the public integration and extension capabilities of the Oracle B2C Service.
Prepare for a successful transition by reviewing upcoming release changes and enhancements.
Explore webinars, events, and feature kits to learn about B2C Service features, functionality, and best practices from the technical experts.
Oracle MyLearn offers a portfolio of free and paid subscription-based learning resources to help you gain valuable skills, accelerate cloud adoption, increase productivity, and transform your business.
Empower your team with the skills to implement, configure, manage, and use your applications with Customer Experience Cloud Training.
Our goal is to facilitate a friendly, supportive environment where members can easily collaborate with each other on solutions and best practices.
Ask and answer questions specific to B2C.
This is an exciting resource intended to help with your Oracle Service Cloud Analytics.
Share product improvement ideas and enhancement requests with Oracle Development, while collaborating with other Oracle customers and partners.
Update your phone number, email notification preferences, and severity 1 and severity 2 contact preferences.
View the contact managers within your organization.
Find contact information of the Technical Account Manager (TAM) and Client Success Manager (CSM) for your organization.
Environment:
Analytics Oracle B2C Service, All Versions
Resolution:
There are various reasons why a record (or records) might not appear in a report. Please check the following aspects to make sure that this behavior is indeed not intended:
1. Check the filters and make sure that the record fulfills all of them. In most cases the record will be excluded from the results by basic filters such as created date, queue, status, etc.
2. Open the report in edit mode and go to the Home tab > Options > More Options, and make sure that the report is set to run on the Operational Database. As mentioned in Answer ID 2817: Reporting data seems incorrect or behind, a report running on the Reporting Database can show stale results. If the record was recently created and the report is running on the Reporting Database, it will not appear in the results if the replication server has fallen behind the operational one. For real-time data make sure the report is running on the Operational Database.
3. Open the report in edit mode and go to the Home tab > Tables. Take note of the used inner joins between the tables, and make sure the record has corresponding values in all the tables used with inner joins. As described in Answer ID 1839: Types of table joins used with reports, an inner join returns data only if the value in the field in the first table also appears as a value in the field of the second table. This means that data must exist in both fields in both tables in order for the data to be returned in the query.
Example: If a report uses the incidents table with an inner join to the contacts table, it will not show incidents that don't have an associated contact because the record exists in one of the tables (incidents), but it doesn't have a correspondent in the other table (contacts).
These are not the only reasons why a record may not be appearing in a report, but they constitute the largest majority of situations. If the record fulfills all the conditions described above and it still doesn't appear in the report, open a service request with Technical Support and provide the ID of the report and the steps to reproduce the behavior.