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, Automatic Caching All versions
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. This is the feature discussed in this answer.
The alternate option is caching you can schedule. Refer to Answer 8997: Cache reports and dashboards at scheduled times for more information on that option.
When using the reports feature in your Oracle B2C Service application, you should understand caching and how it affects your report data. To have access to accurate report data quickly, the agedatabase utility should be scheduled to run every night. When agedatabase runs, it will cache much of the report data to prepare for the following day’s reporting needs. This enables reports to be generated more quickly -- especially those reports that display a large amount of data.
Many of the reports are generated solely on cached data. Some reports, however, produce real-time results when the report is generated. Cached data will remain constant throughout the day and will not be updated until the next day. For this reason, reports using cached data will not have data for the current date. Real-time data may change as incidents are added, updated, or deleted from your database. Understanding which reports use cached or real-time data is essential to accurately interpret your reports.
Some database tables that have cached data are:
Therefore, if you are using fields from these tables in a custom report, the data in your report is cached and the agedatabase utility must run in order for the data to be updated.
Purging report statistics: The default settings are configured so that reporting statistics are not purged from the database. In previous versions, the default was to purge report data older than 187 days. The PURGE_DELETE_STATS configuration setting specifies the number of days after which reporting statistics are removed from the database.
Reports using cached data: To determine which standard reports in your application used cached data, run the report and view the report definition by clicking the Report tab and selecting View Definition. Check the tables listed to determine if any are the cached tables listed above.
For more information regarding standard reports in your application, refer to the Report Management, or Agedatabase Caching for more information on cached data. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.