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, Report Caching Scheduling feature Oracle B2C Service, All supported versioned
Issue:
How do I cache the results of a frequently run report to reduce server load, and reduce the processing and loading time for a report?
Resolution:
There are two different types of report caching. The first is automatic and has to do with the underlying data of which your database is constructed. That's not what this is. See Answer 1917: Cached data used in reports for details on that.
Report Caching is a feature available on sites November 2016 and newer.
A report typically gathers the data it will display at the time it is opened, run, or refreshed. A Cached report does not collate and process at these times. Rather, cached reports only update their information at the interval specified in the caching schedule.
To set a Cache Schedule, while editing the report, in the Home tab, in the properties section, click the Caching icon:
Ensure the "Enable report caching" box is selected:
Set the caching schedule as desired.
Please note when a report is configured for caching, run-time selectable filters will no longer be present for users. Cached reports or dashboards are run on the server on the specified caching schedule. When a user needs to access the report or dashboard, they will see the data as it existed during the time it was cached. At the next scheduled caching time, the report or dashboard is run on the server again replacing the previous version.
Note, calls via the REST API (specifically the analyticsReportResults endpoint) will not reference cached data either. It will return data using the normal run-time filters set on the report and not the data storage in the cache.
For additional information, refer to the 'Cache reports and dashboards at scheduled times' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.