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 Oracle B2C Service all versions Resolution: Inline aggregate reporting lets you insert columns in custom reports to show aggregate information that could not normally be displayed due to restraints on database query size. To use this functionality please follow those steps below exactly:
1. Create a column in a report to collect the aggregate data.
2. Create a new report or edit a report that will link to the column created in the previous step.
3. Click Inline Aggregate on the ribbon’s Insert tab. The Inline Aggregate Wizard opens.
Table describing the available variable and filter value types. Type Description Parent Column Value Select this option to use the values in a column in the parent report to populate the linked aggregate report’s variable or filter. This option is available only when the parent report includes a column with the same data type, such as text, integer, or menu, as the linked aggregate report’s variable or filter. Parent Filter Value Select this option to populate the aggregate report’s variable or filter with the current value from one of the parent report’s filters. This option is available only when the parent report has filters with the same data type and operator as the linked aggregate report’s variable or filter. Parent Variable Value Select this option to populate the linked aggregate report’s filter with the current value from one of the parent report’s variables. This option is available only when the parent report has variables with the same data type and operator as the linked aggregate report’s variable or filter. Default Value Select this option to use the default variable or filter value specified in the linked aggregate report for the variable or filter value. Custom Value Select this option to specify a custom value for the variable or filter. The values you can enter depend on the data type and available options. For instance, if a filter uses a text field, you can type the text you want to use for the filter’s value. If a filter uses a menu field containing staff accounts, you select the staff accounts you want from a menu.
Type
Description
Parent Column Value
Select this option to use the values in a column in the parent report to populate the linked aggregate report’s variable or filter. This option is available only when the parent report includes a column with the same data type, such as text, integer, or menu, as the linked aggregate report’s variable or filter.
Parent Filter Value
Select this option to populate the aggregate report’s variable or filter with the current value from one of the parent report’s filters. This option is available only when the parent report has filters with the same data type and operator as the linked aggregate report’s variable or filter.
Parent Variable Value
Select this option to populate the linked aggregate report’s filter with the current value from one of the parent report’s variables. This option is available only when the parent report has variables with the same data type and operator as the linked aggregate report’s variable or filter.
Default Value
Select this option to use the default variable or filter value specified in the linked aggregate report for the variable or filter value.
Custom Value
Select this option to specify a custom value for the variable or filter. The values you can enter depend on the data type and available options. For instance, if a filter uses a text field, you can type the text you want to use for the filter’s value. If a filter uses a menu field containing staff accounts, you select the staff accounts you want from a menu.
4. Click Finish to save the changes and close the wizard.
5. Click Save to save the report and close the editor.
For additional information on this topic, refer to the 'Configure inline aggregate reporting' section of online documentation for the version your site is currently on. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.