Issue
In any version of Riva Cloud or Riva On-Premise, one or more errors similar to the following may occur when a supported email system is synced with Oracle Sales Cloud:
Exception: JBO-27023: Failed to validate all rows in a transaction.
JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000003341680 ] in ActivityEO
JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000003341680 300000001292247 ] in ActivityAssigneeEO
JBO-27004: Attribute set for ReminderPeriod in entity ActivityAssigneeEO failed
JBO-27004: Attribute set for ShowTimeAsCode in entity ActivityAssigneeEO failed
[Appointment] Error - Error occurred updating item: [Unknown]
Exception: JBO-27023: Failed to validate all rows in a transaction.
JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000351785350 ] in OpportunityEO: Attribute Name in Opportunity EO is required.
Error - Error occurred creating item: [Unknown]
Exception: JBO-27023: Failed to validate all rows in a transaction.
JBO-HZ:::HZ_FIRST_OR_LAST_NAME_REQUIRED: You must enter either the first name or last name or both for a person.
Cause
There was a defect in Oracle Sales Cloud.
Solution
Part of Oracle's solution consisted in introducing a new functional privilege, ZMM_MANAGE_ACTIVITY_ALL_ADMIN_PRIV ("Manage Activity All Access Admin").
To implement the solution completely, action is required on your part.
The action required on your part depends on which version of Oracle Sales Cloud you are using: R12 or R11.
R12: Action required on your part
Add the functional privilege ZMM_MANAGE_ACTIVITY_ALL_ADMIN_PRIV ("Manage Activity All Access Admin") to the integration user job role:
To add the functional privilege:
-
Log in to Sales Cloud as a user with the IT_SECURITY_MANAGER role.
-
Navigate to Tools > Security Console, and do as follows:
- On the Roles tab, search for Sales Administrator.
This is a copy of this out-of-the-box duty role. - From the drop-down, select Edit Role.
- Select Next to proceed to Functional Security Policies.
- In the Privilege Name search box, search for Manage Activity All Access Admin.
- Select Add Functional Security Policy.
- Search All for Manage Activity All Access Admin.
- Select Add Selected Privileges, and select Cancel.
- Select Next four times, select Save, and select Close.
- On the Roles tab, search for Sales Administrator.
-
Navigate to Navigator > Tools > Scheduled Processes, and do as follows:
- Select Schedule New Process.
- From the bottom of the drop-down menu, select Search. In the Name field, enter Send Pending LDAP Requests, and search.
- Select the process from the list, and select OK. Select OK again, and select Submit.
- Select Schedule New Process.
- From the bottom of the drop-down menu, select Search. In the Name field, enter Retrieve Latest LDAP Changes, and search.
- Select the process from the list, and select OK. Select OK again, and select Submit.
R11: Action required on your part
Add the functional privilege ZMM_MANAGE_ACTIVITY_ALL_ADMIN_PRIV ("Manage Activity All Access Admin") to the integration user job role:
To add the functional privilege:
-
Log in to Sales Cloud as a user with the IT_SECURITY_MANAGER role.
-
Navigate to Setup and Maintenance > Task: Manage Duties > Go to Task, and do as follows:
- Search for the Application role named Sales Admin or a custom role for the integration user.
- Open, and navigate to the Application Role Hierarchy tab.
- Select Find Policies, and navigate to Default Domain.
- Under Functional Policies, select Targets to navigate to the details.
- Select Add Target.
- In the Entitlements tab, search for the name ZMM_MANAGE_ACTIVITY_ALL_ADMIN_PRIV.
- When you see the result, select it, and add it to the bottom table. Select Add Target, and select Apply.
-
In Sales Cloud, navigate to Tools > Scheduled Processes, and do as follows:
- Select Schedule New Process.
- From the bottom of the drop-down menu, select Search.
- In the Name field, enter Retrieve Latest LDAP Changes, and search.
- Select the process from the list, and select OK. Select OK again, and select Submit.