User Sync
Overview
Integrated users will have two user accounts—one in Salesforce and one in Oracle CPQ. The User Sync features allow users to manage their preferences and credentials in one system. It also saves administrator time by automating the provisioning and pairing of new users. Once users are provisioned and paired, users are able to Single Sign On (SSO) from Salesforce to Oracle CPQ.
Once the Oracle Connector for Salesforce is installed and set up, you can synchronize user records between the applications. This topic provides relevant user type and permission information and instructions for maintaining user details between the two applications.
User Types and Permissions
There are two general user roles: administrators who are typically responsible for setting up and maintaining the systems and sales users who typically create quotes, approve quotes and use the applications to sell. Because these roles are conceptual and not explicitly defined as discrete user types in either system we feel it's helpful to describe what access and permissions a given user would need to perform these roles.
Administrator
The following table provides required user type and permission settings for an Administrator who can manage CPQ Users.
Salesforce System Administrator | Oracle CPQ User Administrator |
---|---|
|
When Administrator Groups are enabled, administrators need to be assigned to the following:
|
Sales User
The following table provides required user type and permission settings for a Sales User who can access CPQ.
Salesforce User | Oracle CPQ User |
---|---|
For Community Users:
|
|
Synchronized User Data
The following table lista the fields which are transmitted from Salesforce to CPQ, shows the access rights by role, and how they are mapped.
Source Record | Source Field | Destination | Admin | Sales | Notes |
---|---|---|---|---|---|
User | Active | Main Information > Status |
![]() |
![]() |
Value retrieved from the Salesforce User directly |
User | Main Information > Email |
![]() |
![]() |
||
User | Fax | Personal Information > Fax |
![]() |
![]() |
|
User | First Name | Personal Information > First Name |
![]() |
![]() |
Warning: Optional in Salesforce, but required by CPQ |
User | Last Name | Personal Information > Last Name |
![]() |
![]() |
|
User | Phone | Personal Information > Phone |
![]() |
![]() |
|
User | Title | Personal Information > Job Title |
![]() |
![]() |
|
User | First Name | Bill To > First Name |
![]() |
![]() |
Will always be the same as the CPQ User's Personal Information > First Name |
User | Last Name | Bill To > Last Name |
![]() |
![]() |
Will always be the same as the CPQ User's Personal Information > Last Name |
User | Company | Bill To > Company Name |
![]() |
![]() |
Company Name 2 is not populated during User Sync |
User | Street | Bill To > Address |
![]() |
![]() |
Newlines from Salesforce will be removed and the second street line is unused |
User | City | Bill To > City |
![]() |
![]() |
|
User | State/Province | Bill To > State / Province |
![]() |
![]() |
Warning: This is verified by CPQ |
User | Zip/Postal Code | Bill To > Zip / Postal Code |
![]() |
![]() |
|
User | Country | Bill To > County |
![]() |
![]() |
Warning: This is verified by CPQ |
User | Phone | Bill To > Phone |
![]() |
![]() |
Will always be the same as the CPQ User's Personal Information > Phone |
User | Fax | Bill To > Fax |
![]() |
![]() |
Will always be the same as the CPQ User's Personal Information > Fax |
User | Bill To > Email |
![]() |
![]() |
Will always be the same as the CPQ User's Personal Information > Email | |
User | Username | User Integrations > Login |
![]() |
![]() |
The Partner Login must be unique within an entire CPQ Site |
Oracle User | Oracle CPQ Cloud Login | Main Information > Login |
![]() |
![]() |
The Partner Login must be unique within a give Partner Organization or Host Organization |
Oracle User | User Type | Main Information > Type |
![]() |
![]() |
|
Oracle User | Partner User | n/a |
![]() |
![]() |
This checkbox will determine if the "Partner Origination" is synced to CPQ or not |
Oracle User | Partner Organization | Personal Information > Company Name |
![]() |
![]() |
If "Partner User" is checked, then will automatically retrieve the User's Account's Partner Organization's value as the company name |
Oracle User | Delegated Approver | Preferences > Delegated Approver |
![]() |
![]() |
The select user must already have a matching user in CPQ |
Oracle User | Groups | Groups Tab |
![]() |
![]() |
This can contain both Admin or Sales groups |
Oracle User | Language Preference | Preferences > Language Preference |
![]() |
![]() |
The displayed value is the English label of a language local code, but local code is sent to CPQ. Example "English = en_US" |
Oracle User | Currency Preference | Preferences > Currency Preference |
![]() |
![]() |
If left blank during user creation, will default to the value found on your Host Company Info page in CPQ Setup |
Oracle User | Number Format | Preferences > Number Format |
![]() |
![]() |
If left blank during user creation, will default to the value found on your Host Company Info page in CPQ Setup |
Oracle User | Units | Preferences > Units |
![]() |
![]() |
If left blank during user creation, will default to the value found on your Host Company Info page in CPQ Setup |
Oracle User | Date/Time Format | Preferences > Date/Time Format |
![]() |
![]() |
If left blank during user creation, will default to the value found on your Host Company Info page in CPQ Setup |
Oracle User | Time Zone | Preferences > Time Zone |
![]() |
![]() |
If left blank during user creation, will default to the value found on your Host Company Info page in CPQ Setup |
System | false (hardcoded) | Main Information > Email Password |
![]() |
![]() |
This means a newly created user (in CPQ) will not receive an email about account creation. |
System | UserInfo.getOrganizationId() | User Integrations > Organization Id |
![]() |
![]() |
Not visible to CPQ users unless the CPQ site has been configured to connect to multiple Salesforce instances |
= System Generated
= Editable in Salesforce
= Not editable in Salesforce
Administration
The following procedures assume that the Oracle CPQ and Salesforce Integration has been installed and setup. For more Oracle CPQ and Salesforce integration information, refer to the Oracle CPQ Connector for Salesforce Installation and Setup Guide.
Add or Remove a User Group in Salesforce
Updating CPQ User Details from My Settings