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:
Agent Desktop, Incidents Oracle B2C Service
Issue:
I exported report results to Excel and enabled the "Convert all dates into Excel-formatted dates" option. However, in the resulting spreadsheet, all dates are set to 1/0/1900 12:00:00 AM or "########" in my Excel file.
Resolution:
Microsoft Excel 2007, 2010 or 2013 should be installed to the workstation in order to export report data to Excel. And if "Convert all dates into Excel-formatted dates" option is checked, then System date/time format should be the same as the console date/time format because Excel uses system defaults. This checkbox is not compatible on a client machine with a localization that does not match the interface's DTF_SHORT_DATE configuration.
For example: An interface has the English - European language pack applied. This means the UK date time format will be applied to all dates within the console which is DD/MM/YYYY HH:MM AM. The workstation's system date time format is US which is MM/DD/YYYY HH:MM AM. Excel compiler receives DD/MM format and believes that day is month and vise versa. That creates an exception in the compiler's engine which invalidates all the dates.
Steps to resolve:
There are few options:
1. Change system date/time format to be the same as in a console (please note the DTF_SHORT_DATE interface configuration needs reflect this localization setting). This setting can be found in Control Panel > "Region and Language" option > Select appropriate country Format > restart/start the console.
2. Modify your report and change the date fields format to the one that is used as default System date/time format. For example (For US System date/time format):
date_format(incidents.created, 'MM/DD/YYYY HH:MI AM')
Or:
to_date(date_format(incidents.created, 'DD/MM/YYYY HH:MI AM'), 'DD/MM/YYYY')
For more information please see the following answers:
Answer ID 1884: Functions used in reports
Answer ID 2545: Exporting report data to Excel