Before You Install the Recipe
You must perform the following configuration tasks on your Salesforce and Oracle ERP Cloud instances in order to successfully connect to these external systems using Oracle Integration and create sales orders for opportunities won.
Configure Salesforce
To access Salesforce using Oracle Integration and retrieve information about the status of Salesforce opportunities, you must perform certain configurations on your Salesforce instance.
You must create a user account on Salesforce for Oracle Integration. You’ll use the credentials of this user account while configuring the Salesforce connection in Oracle Integration. Also, identify your Salesforce instance type and your current Salesforce API version. In addition, create an outbound message to trigger the integration flow of the recipe, and create a workflow rule to send the outbound message when a Salesforce opportunity is closed with the status Closed Won in Salesforce. Finally, create a custom field for Salesforce opportunity and product records to store Oracle ERP Cloud IDs.
Log in to your Salesforce instance as an Administrator and execute the following tasks.
Note:
The steps provided here apply to the Salesforce Classic UI. If you’re using the Lightning Experience UI on your Salesforce instance, switch to the Classic UI.- Create an API-enabled custom role. You’ll assign this role to the user account you’ll subsequently create for Oracle Integration.
- On the Salesforce Setup page:
- Expand Manage Users under the Administer section in the left navigation pane.
- Click Profiles.
- On the Profiles page, click New Profile.
- On the resulting page:
- Select Standard User in the Existing Profile field.
- Enter a name for the new profile, for example,
API Enabled
, and click Save.
The new profile is now saved, and the Profile Detail page of the new profile is displayed.
- Click Edit on the Profile Detail page.
- On the Profile Edit page:
- Scroll to the Administrative Permissions section and ensure that the API Enabled check box is selected.
- Scroll to the Standard Object Permissions section and perform the following actions.
- In the Accounts row, leave the Read, Create, Edit, and Delete boxes checked. Additionally, select the ViewAll check box.
- In the Contacts row, leave the Read, Create, Edit, and Delete boxes checked. Additionally, select the ViewAll check box.
- In the Price Books row, leave the Read box checked. Additionally, select the Create, Edit, and Delete check boxes.
- In the Products row, leave the Read box checked. Additionally, select the Create, Edit, and Delete check boxes.
- Scroll to the end of the page and click Save.
- On the Salesforce Setup page:
- Create a user account for Oracle Integration and assign the custom role created previously to this account.
Note:
If you have already created a user account for Oracle Integration, you can assign the API-enabled custom role to the existing account.- On the Profile Detail page of the API Enabled profile, click View Users.
- Click New User in the resulting page.
- On the New User page:
- Enter a first name and last name for the user, for example,
Integration User05
. -
In the Email field, enter a valid email address.
The email address you enter is automatically populated in the Username field. Note this username.
- In the User License field, select Salesforce.
- In the Profile field, select the profile you created previously, that is, API Enabled.
-
Scroll to the end of the page, ensure that the Generate new password and notify user immediately check box is selected, and click Save.
The user account is now created, and a verification email is sent to the email address you provided for the account.
- Enter a first name and last name for the user, for example,
- Log in to the corresponding email account and click the Verify Account button in the email message from Salesforce.You’re redirected to the Salesforce instance to set a password for the new user account.
- Set a password and note the same.
Subsequently, you’re signed in to the Salesforce instance with the new account.
Note:
If you’re shown the Lighting Experience UI, switch to the Salesforce Classic UI. - Generate a security token for the new user account. You’ll need this security token along with the password to access Salesforce using Oracle Integration.
- Stay signed in as the new user and click the user name at the top of the page to open a menu.
- Click My Settings in the menu.
- On the My Settings page, in the Quick Links section, click Edit my personal information.
- On the resulting page, click Reset My Security Token in the left navigation pane.
-
Click the Reset Security Token button.
A new security token is sent to the email address associated with the account. Note the security token.
- On the Salesforce instance, click the user name again and select Logout from the menu. Log back in as the Administrator.
- Identify your current Salesforce API version. See Find Your Current Salesforce API Version in Using the Salesforce Adapter with Oracle Integration 3.
- Identify your Salesforce instance type. See Identify the Instance Type of Your Salesforce Organization in Using the Salesforce Adapter with Oracle Integration 3.
- Create an outbound message. The outbound message triggers the integration flow of the recipe.
- On the Salesforce Setup page:
- Scroll to the Build section in the left navigation pane.
- Expand Create, then Workflow & Approvals, and then click Outbound Messages. If you’re shown the Understanding Workflow page, click Continue.
- Click New Outbound Message in the resulting page.
- On the New Outbound Message page:
- In the Object field, select Opportunity and click Next.
- Enter the following details for the new outbound message:
-
Enter a name for the outbound message.
Note that the Unique Name field is automatically populated based on the name you enter.
- Optionally, enter a description for the outbound message.
-
In the Endpoint URL field, enter the following URL:
https://<OIC_FQDN:OIC_SSL_PORT>/ic/ws/integration/v1/flows/salesforce/ORCL-R-SFDC_ERP_OPPOR_TO_ORDER/1.0/
Where OIC_FQDN and OIC_SSL_PORT are the fully-qualified domain name and port of your Oracle Integration instance. For example:
oicinstance.example.com:443
- In the User to send as field, select the user account using which you want to send the message.
- Under Opportunity fields to send, select all the fields and click Add.
-
Click Save.
The new outbound message is created and displayed on your browser.
-
- On the Salesforce Setup page:
- Now, create a workflow rule to send the outbound message (created previously) when a Salesforce opportunity record closes with the status Closed Won.
- On the Salesforce Setup page:
- Scroll to the Build section in the left navigation pane.
- Expand Create, then Workflow & Approvals, and then click Workflow Rules.
If you’re shown the Understanding Workflow page, click Continue.
- Click New Rule in the resulting page.
- On the New Workflow Rule page:
- Select Opportunity in the Object field, and click Next.
- Enter the following details for the new workflow rule:
- Enter the rule’s name.
- Optionally, enter a description for the rule.
- In the Evaluation Criteria section, select the created, and every time it’s edited radio button.
-
In the Rule Criteria section, select the formula evaluates to true option, and define the following rule criteria:
Opportunity: Stage EQUALS Closed Won
- Click Save & Next.
- On the next page, click the Add Workflow Action button and choose Select Existing Action.
- On the Select Existing Actions page:
- Select Outbound Message in the Search field.
- In the Available Actions box, select the outbound message you created previously, for example,
Outbound Message: <name of your outbound message>
. - Click Add to move your selection to the Selected Actions box.
- Click Save.
-
Click Done.
The new workflow rule is created and displayed on your browser.
- Click Activate to activate the rule.
- On the Salesforce Setup page:
- Create a custom field for opportunity records.
- On the Salesforce Setup page:
- Scroll to the Build section in the left navigation pane.
- Expand Customize, then Opportunities, and then click Fields.
- On the Opportunity Fields page, scroll to the Opportunity Custom Fields & Relationships section and click New.
- On the New Custom Field page:
- Find and select the Text radio button, and click Next.
- Enter the following details for the new custom field:
- Enter
ERPCustomerId
as the field label. Note that the field name is automatically populated based on the label you enter. - Enter
255
as the length. - Optionally, enter a description for the new field.
- Click Next.
- Enter
- On the Establish field-level security page, select the Visible check box in the header row to grant edit access to the new field for all profiles. Click Next.
- Leave all the layout check boxes selected and click Save.
- Create another custom field for Opportunity records by repeating Steps b and c, but enter a different label name, for example
ERPOrderId
.
On the Opportunity Fields page, you can see the new fields added under the Opportunity Custom Fields & Relationships section. - On the Salesforce Setup page:
- Create a custom field for product records.
- On the Salesforce Setup page:
- Scroll to the Build section in the left navigation pane.
- Expand Customize, then Products, and then click Fields.
- On the Product Fields page, scroll to the Product Custom Fields & Relationships section and click New.
- On the New Custom Field page:
- Find and select the Text radio button, and click Next.
- Enter the following details for the new custom field:
- Enter
ERPID
as the field label. Note that the field name is automatically populated based on the label you enter. - Enter
255
as the length. - Optionally, enter a description for the new field.
- Click Next.
- Enter
- On the Establish field-level security page, select the Visible check box in the header row to grant edit access to the new field for all profiles. Click Next.
- Leave all the layout check boxes selected and click Save.
On the Product Fields page, you can see the new field added under the Product Custom Fields & Relationships section.
- On the Salesforce Setup page:
Configure Oracle ERP Cloud
To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.
- Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
- Assign the following roles to the user account. For more information on these roles, see Assign Required Roles to an Integration User in Using the Oracle ERP
Cloud Adapter with Oracle Integration 3.
Integration Specialist
Oracle ERP Cloud-specific data access to the integration user