Set Up a CRM Configuration for Oracle

This is the first step of integrating Oracle with CXone Agent.

This page explains how to set up a CRM configuration for Oracle. This is done in CXone. The configuration connects Oracle to CXone Agent. It allows the two to share data through data memorialization and dynamic data mapping.

Complete each of these tasks in the order given.

Create a New CRM Configuration in CXone

Required permissions: Configurations Create

Provide CXone with the information it needs to connect to Oracle.

If the Oracle user account that created the CRM configuration is deleted or disabled, the CRM configuration will also be deleted. Prevent this by creating a user account in Oracle specifically for CXone configuration. This is the system user. It is recommended to give the system user administrator privileges. If you do not want to give the system user administrator privileges, you must give it:

  • Read access to all Oracle entity records and entity fields.

  • Read/Write access to all Oracle entity records that will be accessed or updated in the workflows you've configured, including Search workflows, Create workflows, and data memorialization.

  1. In CXone, click the app selector and select Agent Integrations icon: an orange gear with three arrows inside..
  2. Click New CRM Configuration.
  3. Select Oracle Service Cloud from the Integration Type drop-down.

    The Create Configuration page in Agent Integrations, with fields for Integration Type, Configuration Name, and Description.

  4. Enter a name for the integration in Configuration Name. You can write a Description.
  5. Click Authenticate.
  6. In the Authentication pop-up window, select one of the authenticated accounts listed, if you have them. If you need to create a new authentication, click New authentication and configure the fields that appear:
    1. To change the name of the authentication, edit Your authentication name.
    2. Enter the Username for an Oracle account that has admin permissions. It is recommended this account also be an API user.
    3. Enter the Password for that Oracle account.
    4. Enter the Domain of your Oracle instance. To find it, open your instance of Oracle and copy and paste the URL from the address bar in your browser. You only need the URL up until .com. For example: https://company.oracle.com.
    5. Click Create.
  7. Click Next.
  8. In the external_screenpop_domain_OSC field, enter your Oracle instance domain. To find it, open your instance of Oracle and copy and paste the URL from the address bar in your browser. You only need the URL up until .com. For example: https://company.oracle.com.
  9. Click Finish. A message telling you the authentication is active appears in the bottom right corner.
  10. Click Save in the top right corner of Agent Integrations.

Create Data Memorialization Mappings

Required permissions: Configurations Edit; Data Memorialization Create

Data memorialization mappings allow for data from CXone Agent to be popped into Oracle records. In these mappings, you select the CXone data field to map to each Oracle record field. For example, if you map the Customer Name CXone data field to the Name Oracle record field, Name displays the value from Customer Name. Only text is mapped; attachments, images, and notes cannot be mapped. Currently, you can set up data mappings for standard CRM entity types.

For voice interactions, data memorialization happens when the call ends and the agent completes ACWClosed State that allows an agent to complete work requirements after finishing an interaction time, if configured. For digitalClosed Any channel, contact, or skill associated with Digital Experience. interactions, it happens when the agent transfers the interaction or unassigns it from themselves.

  1. If you haven't already, open a CRM configuration for Oracle. In CXone, click the app selector and select Agent Integrations icon: an orange gear with three arrows inside.. Select a CRM configuration from the list.
  2. Click the Data Memorialization tab.
  3. Click New Data Mapping.
  4. Enter a Name for the mapping. You can optionally enter a Description.

  5. In the Select Entity Type drop-down, select the Oracle record type you want to create field mappings for.

    The Data Mapping tab on the Configurations page in CXone, with fields for Name, Description, and Select Entity Type, as well as a + Add Entity button.
  6. Click Add Entity.

  7. In the External CRM Field drop-down that appears, select the Oracle record field you want to receive data from CXone Agent.

    If you want to map the full transcript of an interaction, select a record field with proper formatting and a large enough character limit. If the field doesn't meet these requirements, only part or none of the transcript is displayed, depending on the CRM.

    The Data Mapping tab, showing a box for a Case entity type and an Account entity type. Each has fields for External CRM, Select Channel, and CXone data field.

  8. In the Select Channel drop-down, select the type of CXone data you want to map to the Oracle record field you selected.

    Field Value

    Details
    Digital Contact Enables you to select a Digital Experience data field to map.
    Script Variable

    Enables you to input a script variable for a data field. Select this option if you want to map a data field other than the preset Digital Experience and ACD data fields. The script variable should be in lowercase to match the ASSIGN action in the Studio script for the skill.

    If you select this option to use for voice interactions, you must enable screen popsClosed A configurable pop-up window with information about the contact. It appears on an agent's screen after a certain event, usually when the agent connects to a contact. for the skillClosed Used to automate delivery of interactions based on agent skills, abilities, and knowledge and the ASSIGN action in the Studio script:

    • Go to ACD > Contact Settings > ACD Skills and select the voice skill. In the Details tab, click Edit. Then select the checkbox for Use Screen Pops.

    • Open the Studio script for the voice skill. In the ASSIGN action's input properties, set the ScreenPop property to True.
    Voice Call Contact Enables you to select an ACD data field to map.

  9. In the CXone Data drop-down, select the CXone data field you want to map to the Oracle record field you selected.

    If you selected Script Variable in the Select Channel drop-down, enter the script variable in the CXone Data field. You must enter it in lowercase, even if you used camel case in the script to define the variable.

    Mapping to any other CXone data field requires using a script variable.

    Digital Contact (Digital Experience) Data Fields

    Agent ID

    The user's CXone employee ID.
    Agent Name The agent's name in CXone.
    Channel Name The type of digital channel, such as chat, email, or Facebook Messenger.
    Channel Type The type of digital channel, such as chat, email, or Facebook Messenger.
    Contact ID The contact's unique ID number from CXone.
    Customer Name The contact's name from the customer card.
    Direction The interaction's direction: inbound, outbound, or internal.
    Disposition Name The dispositionClosed Result assigned by the agent or system at the end of a voice (disposition) or digital (status) interaction. the agent selected in the Outcomes window.
    Disposition Notes The notes the agent added in the Outcomes window.
    End Time The date and time the interaction was closed.
    Event Type The type of interaction: voice, digital, voicemail, or work item.
    Final State If the interaction has ended: true or false.
    From The contact's name from the customer card.
    Interaction ID The interaction's unique ID number from CXone.
    Media Type The type of media: voice, digital, voicemail, or work item.
    Skill ID The skill's unique ID number from CXone.
    Skill Name The skill's name in CXone.
    Start Time The date and time the interaction began.
    Status The statusClosed Result assigned by the agent or system at the end of a voice (disposition) or digital (status) interaction. the agent selected in the Outcomes window.
    To The agent who handled the interaction.
    Transcription Text The transcript of the digital interaction.
    Transcript URL The URL where the digital transcription is located.

    Voice call Contact (ACD) Data Fields

    Agent ID

    The user's CXone employee ID.
    Agent Name The agent's name in CXone.
    ANI The contact's phone number.
    Contact ID The contact's unique ID number from CXone.
    Contact Type The type of interaction: voice or digital.
    Direction The interaction's direction: inbound, outbound, or internal.
    Disposition Name The dispositionClosed Result assigned by the agent or system at the end of a voice (disposition) or digital (status) interaction. the agent selected in the Outcomes window.
    Disposition Notes The notes the agent added in the Outcomes window.
    DNIS The agent's phone number.
    End Time The date and time the interaction was closed.
    Final State If the interaction has ended: true or false.
    Interaction ID The interaction's unique ID number from CXone.
    Master Contact ID The master or parent ID number for the contact.
    Media Type The type of media: voice, digital, voicemail, or work item.
    Recording URL The URL where the recording is located.
    Skill ID The skill's unique ID number from CXone.
    Skill Name The skill's name in CXone.
    Start Time The date and time the interaction began.
    Status The statusClosed Result assigned by the agent or system at the end of a voice (disposition) or digital (status) interaction. the agent selected in the Outcomes window.
    To The agent who handled the interaction.
    Tags The tags applied to the interaction.

  10. To add more data fields, click Add Field.
  11. To configure mappings for another Oracle record type, select a different record type from the Select Entity Type drop-down and click Add Entity.
  12. Click Save at the top of the page. The active data mapping appears in the Data Memorialization tab.

Create Dynamic Data Mapping Mappings

Required permissions: Configurations Edit; Dynamic Data Create

Dynamic data mappings allow you to choose which Oracle record fields appear in CXone Agent. You can set up dynamic data mappings for standard Oracle record types retrieved by search workflows. You can also set them up for custom records created by custom create workflows. You can add up to five fields per record type.

In the Current Interaction and Related Interactions sections, records with four fields are displayed.
  1. If you haven't already, open a CRM configuration for Oracle. In CXone, click the app selector and select Agent Integrations icon: an orange gear with three arrows inside.. Select a CRM configuration from the list.
  2. Click the Dynamic Data tab.
  3. Click New Data Mapping.
  4. Enter a Name for the mapping. You can optionally enter a Description.

  5. In the Select Entity Type drop-down, select the Oracle record type with the fields you want to display in CXone Agent.

    The Dynamic Data tab in CXone. Shows fields for Name, Description, and Select Entity Type.
  6. Click Add Entity.

  7. In the External CRM Field drop-down that appears, select the Oracle record field you want to display to agents.

    Under each entity you selected, there are drop-downs for External CRM Field, where you select the CRM record field you want to display to agents.
  8. To add more Oracle record fields, click Add Field. You can add up to five fields per record type.
  9. Click Save at the top of the page. The active dynamic data mapping appears in the Dynamic Data tab.

The next step of integrating Oracle with CXone Agent is to modify your Studio script.