Create the Oracle E-Business Suite Integration

Create an integration that can be triggered by another integration, then use the Oracle E-Business Suite adapter to import data.

This integration is triggered by the main integration, once for each record in the Oracle Taleo Enterprise Cloud Service export file. Each time the integration is triggered it imports information about a candidate into Oracle E-Business Suite, and returns an employee number. Later, this number is added to the candidate’s record in Oracle Taleo Enterprise Cloud Service.

Create an Integration Triggered by an Application Event

Create an integration that’s triggered by another integration.

1. In the navigation pane, click Integrations.
2. Click Create.
3. On the Orchestration tile, click Select.
4. Next to What triggers this integration?, ensure that the Application event or business object option is selected.
5. Enter a name for your integration, and click Create.

   An empty integration canvas is displayed.

6. From the Triggers panel, expand REST, and drag the ebs-rest-endpoint REST adapter to the large + section in the circle on the integration canvas.
7. Name your endpoint EBS_CANDIDATE_CREATE, and give it a relative resource URL: /ebs/candidate
8. Change the endpoint action to POST. Select Configure a request payload for this endpoint and Configure this endpoint to receive the response options, and then click Next.
9. Select the JSON Sample request payload format, and click <<< inline >>>. Paste the JSON code, and click OK.

   {  "CandidateData" : {   "FirstName"   : "John",   "LastName"   : "Myers",   "EmailAddress"  : "[e-mail]",   "Address"   : "Berliner Strasse 30",   "City"   : "Potsdam",   "ZipCode"   : "01976"  } } 

10. Click Next.
11. Select the JSON Sample response payload format, and click <<< inline >>>. Paste the JSON code, and click OK.

    {  "OutputParameters" :   {       "P_EFFECTIVE_START_DATE" : "2016-12-01",       "P_EFFECTIVE_END_DATE" : "2047-12-31",       "P_PERSON_ID" : "489191"   } } 

12. Click Next, and click Done.

Use the Oracle E-Business Suite Adapter to Import Data

Use the adapter to send information from each record that’s read from the export file to Oracle E-Business Suite.

1. From the Invokes panel, click Oracle E-Business Suite, and drag the EBSImport adapter to the + after the EBS_CANDIDATE_CREATE endpoint on the integration canvas.
2. Name your endpoint EBS-Import, and click Next.
3. From the Product Family list, select Human Resources Suite, and from the Product list, select iRecruitment.
4. From the API list, select Party, and click Next.
5. From the Methods list, select Create Candidate Internal, and click Next. On the next screen, click Done.
6. Configure the mapping for the EBS-Import endpoint:
   1. Drag the FirstName element from the Source panel to the P_FIRST_NAME element in the Target panel.
   2. Drag the LastName element from the Source panel, to the P_LAST_NAME element in the Target panel.
   3. Drag the EmailAddress element from the Source panel to the P_EMAIL_ADDRESS element in the Target panel.
   4. Provide a value for the P_BUSINESS_GROUP_ID element in the Target panel.
   5. Provide values for the elements in the RestHeader node in the Target panel:

      Element	Description	Sample Value
      Responsibility	An existing Oracle E-Business Suite responsibility with required permissions to access the organization and related data objects.	US_SHRMS_MANAGER
      RespApplication	An abbreviation of the Oracle E-Business Suite module that provides this REST API. Use the abbreviation for this module: PER.	PER
      SecurityGroup	Unless configured differently, use the default value: STANDARD.	STANDARD
      NLSLanguage	Unless configured differently, use the default value: AMERICAN.	AMERICAN
      Language	Unless configured differently, use the default value: American.	American
      Org_Id	The numeric value of the Oracle E-Business Suite organization related to this API invocation.	204

7. Configure the mapping for the Return action:
   1. Drag the P_EFFECTIVE_START_DATE element from the Source panel to the P_EFFECTIVE_START_DATE element in the Target panel.
   2. Drag the P_EFFECTIVE_END_DATE element from the Source panel, to the P_EFFECTIVE_END_DATE element in the Target panel.
   3. Drag the P_PERSON_ID element from the Source panel to the P_PERSON_ID element in the Target panel.
8. Save your changes.

Assign a Business Identifier for the Oracle E-Business Suite Integration

Assign a business identifier to track message payload fields sent through the Oracle E-Business Suite integration.

At runtime, the status of business identifiers is visible on the Tracking page and (if integration errors have occurred) the Errors page.

1. From the menu, select Tracking.
2. From the Source section, expand execute, request-wrapper, and CandidateData, and drag the EmailAddress field to the Drag a trigger field here section.
3. Drag FirstName and LastName to the Drag a trigger field here section. Ensure that EmailAddress is marked as the primary identifier.
4. Click Done, and click Save.

Activate the Oracle E-Business Suite Integration

Activate the integration to enable it.

When you activate an integration, you receive a URL you can use to invoke it. You need to supply this URL when you create a connection to trigger this integration from the main integration flow.

1. In the Integrations list, find the integration that you want to activate, and go to the far right.
2. Click the switch.
3. Select the options that are appropriate for your integration.

   Element	Description
   Contribute integration mappings to Oracle Recommendations Engine	Click to enable the Oracle Recommendations Engine. Uses collective intelligence to recommend which fields should be mapped while developing an integration. These recommendations are built based on the mappings contributed to Oracle Recommendations Engine anonymously. You can change this option on the Recommendations page. Select Settings, and click Recommendations.
   Enable tracing	Click to enable detailed tracing information in the activity stream. When this checkbox is selected, detailed logging information is collected about messages processed by this integration flow at runtime. This option can help you troubleshoot issues. However, detailed tracing can affect performance. To disable tracing, you must deactivate the integration, and then reactivate it without selecting the Enable tracing checkbox.

4. Click Activate. Click the endpoint URL, for example https://example.com/ic/api/integration/v1/flows/rest/TALEO_EBS_CANDIDATE/1.0/metadata, that’s displayed in the banner.
5. Copy the endpoint listed under the Endpoint URL heading, for example https://example.com:443/ic/api/integration/v1/flows/rest/TALEO_EBS_CANDIDATE/1.0/ebs/candidate, and paste the URL in a text editor file to save it.

   You must provide this URL when you create a connection to invoke this endpoint.