What can I do with Custom Objects?
Custom Objects, November 2010 and newer
Oracle B2C Service
Custom Objects can be used to integrate organization-specific data with Oracle Service Cloud's standard objects. You can add custom objects to workspaces, workflows, custom reports, navigation sets, customer portal pages, and other areas of Oracle B2C Service.
Note: To create custom objects from a customer portal page, you must have Connect PHP installed. For more information regarding Connect PHP, refer to Connect for PHP.
Creating custom objects
When creating a custom object using the Object Designer, you can associate it with other custom objects or with existing tables in the Oracle B2C Service database. For example, if you created a product registration custom object, it could be associated with the Contacts table. You could also create another custom object to track where the product was purchased and then link the custom objects together. Using this scenario, you could track who registered the product and where they purchased it, managing information in a single workspace and displaying it in custom reports.
Custom objects are stored in “packages”. Packages are containers where you can place related objects. You can add multiple packages and custom objects in the Object Designer before you deploy them.
To create a custom object
- Click the Configuration button on the navigation pane.
- Double-click Object Designer under Database. The Object Designer opens on the content pane.
Note The Custom Object Designer permission must be enabled on your profile to
access the Object Designer.
- To create a package for custom objects, follow these steps.
a) Click the New button on the ribbon.
b) Select Package.
c) Type the name you want for the package.
- Select the package you want to add the custom object to.
- Click the New button on the ribbon and select Object. The Summary page displays.
- Type a name for the object in the Name field.
For additional information, refer to the 'Custom Objects Overview' section in the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products..
See also the 'Ask the Experts session: Extending Data Into Your Site' dated January 25, 2018, available from the Oracle B2C Service Webinars page. This webinar focuses on options for adding data points into a site with custom fields and custom objects. This session helps attendees understand the different data types available in the system. Different concepts are reviewed such as indexing, relationships, masking and others. It also explores the impact of data and how different data types can impact table sizes as well as best practices to consider.
If you would like to engage our Oracle Consulting team for customization with your site, please contact your Sales Account Manager.
A vital consideration to keep in mind when deploying a Custom Object is that it is not possible to predict the exact amount of time a deployment will take. A completely normal deployment can take 24 hours or more. If replication is behind (See Answers 5609 & 2817), a deployment cannot complete. As it is possible for replication to be days behind, you should make any necessary changes to Custom Objects at least several days before they will be needed. Even back-to-back deployments can take very different amounts of time to complete, and this is rarely a cause for concern.
Additionally, there are certain stages of the deployment where your entire Custom Object table will be locked. While the table is locked, you will be unable to access any Custom Objects; this includes in reports, workspaces, the Customer Portal, and anywhere else that they are in use.
For more information on deploying custom objects, refer to Answer ID 8923: Custom Objects & Custom Field Deployment Basics.