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.
Is there a standard report that I can use to search for incidents containing Social Security Numbers that use dashes?
Environment
Analytics
Resolution
By design, the standard 'Incidents' report (ID 120) incident search does not narrow search results to only incidents containing Social Security Numbers (SSN's) with dashes. As designed, this report uses stemming and will break apart your alphanumeric Serial Number into pieces. Because standard reports employ stemming, no standard report will deliver a list of exact matches of dashed Social Security Number search results. Many of the incidents that return as results in this report do not contain the submitted string, and only include similar (stemmed search) strings.
In order to create a custom report that will isolate only the results that exactly match the entire SSN search string including the two dashes, you will need to:
Incidents.search_and_or IN LIST Select AND (match ALL terms)
Incidents.search_and_or
IN LIST
Select AND (match ALL terms)
Please see the attached screen capture document for an illustration. The Incidents.search_and_or filter will require that all of the pieces are exact matches, and should reduce your search results to only the exact SSN match in most cases.
The following answers describe the stemming factor in greater detail:
Answer ID 2252: Using the incidents.search_thread column in reports
Answer ID 1974: Difference between searching on Subject or SummaryThread
Notes
The Oracle Cloud Customer Connect is a great resource for finding the answers to your custom reporting questions. In the community, you can read what others have posted regarding the capabilities of custom reporting. If you can't find your answer, you can post a question. The Reporting and Analytics Forum can be accessed HERE. Also, you can find further information regarding the database tables and fields available within Analytics, in the Data Dictionary for the version of the application that you are currently using. Please see Answer ID 1350: Accessing Oracle B2C Service manuals, release notes, online help and update documentation, for more information regarding accessing RightNow manuals, release notes, and update documentation. If you need further, more in-depth assistance, skilled consultants from Oracle Consulting can assist you with your custom reporting questions, or can build custom reports for you. For additional information, refer to Oracle Consulting options.