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.
Why am I seeing a "query size limitation" warning when filtering on one particular hour in my report?
Environment:
Analytics, Sites which utilize Daylight Savings Time (DST) Oracle B2C Service, All versions
Issue:
A report is unable to pull data from a very small timeframe beginning or ending between 02:00 & 02:59:59, even though it works for other times. The filter will then fall back to the oldest date it can: 12-31-1969 06:59 PM.
Resolution:
Daylight Savings Time (DST) is the practice of setting the clock forward by one hour during the warmer part of the year so that evenings have more daylight and mornings have less. DST starts at 2:00 am local time and DST will move the clocks forward one hour. Local time between 02:00 - 02:59:59 does not exist during the transition from standard time to DST. This hour is skipped, therefore this day only consists of 23 hours.
Therefore, any report filter explicitly using any time from 02:00 - 02:59:59 on a DST start date may fail. SQL determines an "incorrect datetime value" was used. This filter is then ignored, which may cause a max_join error on the database level. This will present itself as a warning:
This report could not be processed because it exceeds the query size limitation. Please reduce the amount of data processed by the report.
To resolve this issue, change the filter to a time that actually happened. I.E., 01:59 or 03:00.
The End of DST - The opposite happens in the autumn, and there will be a 25 hour day with the 01:00 hour repeating itself thus: 01:59:58, 01:59:59, 01:00:00, 01:00:01...