iRecruitment Talemetry Apply Integrator Integration Guide

Applies To:
iRecuritment
Talemetry Apply/RMX Enterprise
Talemetry Integrator

Integrator Integration:
With iRecruitment there are two ways for applications to get into iRecruitment, one if the Career Page.
The other uses the following method involving the Integrator:


1.       Resumes are Posted to Talemetry

a.       Resume is posted to hosted service at https://rmx.resumemirror.com.  Resume can post here from using one of the following methods:

                                                               i.      Submission from Apply Workflow

                                                             ii.      Office Add-in (Outlook, Word or IE)

                                                            iii.      Email forwarding (sent to a @resumemirror.net address)

                                                           iv.      FTP site post (at Talemetry)

                                                             v.      Back End Import (sent to Talemetry staff to import system migration data)

2.       Data is never deleted until pickup

a.       All data posted to the Talemetry hosted service at https://rmx.resumemirror.com will wait on the hosted service at Talemetry and will not be deleted unless the data is picked up

3.       Data is retrieved using the Talemetry Java Integrator at regular intervals

a.       Data is picked up from the Talemetry hosted service using the Java Integrator.  You can configure the Java Integrator to poll at regular intervals.  This is configurable on the Java Integrator web site configuration screen. 

b.      If no data is being retrieved on the Java integrator then this is likely due to one of the following reasons

                                                               i.      Network access to rmx.resumemirror.com at port 443 is either being blocked or needs to be configured to use a proxy.  Proxy configuration settings are in the Java Integrator interface under Configuration/Network.   If it is blocked entirely and it is not due to proxy server configuration – please contact your network team.

                                                             ii.      Your credentials are not correct – please check your credentials in the Java Integrator to confirm that the values are correct for the account.  To see if there is a credentials error, you can review the daily log at C:\TalemetryIntegratorStorage\logs

                                                            iii.      You don’t have any data to pick up on that account – you need to send through a resume through one of the Posting methods listed in step 1 for any data to be picked up.

c.       You can tell if data is being retrieved by the Java integrator if XML files (one per resume) are posting into either one of the following directories below:

                                                               i.      C:\TalemetryIntegratorStorage\APPLY_EBS11I\Archive – for transactions that successfully post to the iRecruitment database

                                                             ii.      C:\TalemetryIntegratorStorage\APPLY_EBS11I\Error  - for transactions that fail to post to the iRecruitment database

4.       You can set a maximum number of resumes to retrieve per batch run of the Java integrator

a.       For additional control on data pick up – you can set a maximum retrieve amount per poll directly in the C:\TalemetryIntegratorStorage\TalemetryIntegratorSettings.xml file on the Java integrator server.  If you set this maximum amount then if there is a larger amount of resumes to pick up then is shown in the MaxRetrieve tag, the oldest resumes will be picked up, until the maximum value has been reached.  When the next poll happens, it will pick up the next batch of oldest data to the maximum value shown here.  No data is lost or deleted.

<FeatureSettings>
        <TalemetryApply>
            <MaxRetrieve>50</MaxRetrieve>
            <Sources>
                <Source>
                    <Name>TestSource</Name>
5.       A stylesheet is applied to the resume data that is being picked up

a.         As the resume is being picked up from the Talemetry hosted service, a stylesheet is applied to transform the data.  This stylesheet is located in the directory at C:\TalemetryIntegratorStorage\settings\XSL\Apply

b.      The stylesheet is set based on the Java Integrator interface value shown under Configuration/Apply for Oracle EBS and the value XSL file name.  The XSL file name is a relative path that starts assumes a directory of C:\TalemetryIntegratorStorage and the path after this must be specified (i.e. a valid value would be: settings\XSL\Apply\XSLSample_For_Apply_iRecruitment11i.xsl)

c.       After the stylesheet is applied, the XML data is posted in the Error or Archive folder.  If the data has problems based on a stylesheet transformation then you can see the data in these folders following the transformation.

6.       The XML data for the resume is posted to the Oracle database

a.       The Java Integrator’s final step is to post the entire XML after the transformation into the rmx_interface table.  If the data has posted to this table then the Java Integrator is working successfully.

b.      The data posts to the rmx_interface table using the database credentials configured in the Java Talemetry Integrator.  Please ensure that the database connection information is accurate and that the username/password being used have access to post to the rmx_interface table.  You will also need to ensure that there is no network blockage from the windows server hosting the talemetry integrator to your database.

c.       Database communication requires the ojdbc6.jar file to be downloaded from Oracle and copied to the folder at C:\TalemetryIntegratorStorage\settings\JDBC.  If this file is missing you will not be able to post data to Oracle.

d.      When data is posted to the rmx_interface table initially, it will have a status of NEW

e.      If the connection fails and you need to repost resume files after the communication issue has been resolved, copy the XML files for the failed resumes from the C:\TalemetryIntegratorStorage\APPLY_EBS11I\ Error folder to the C:\TalemetryIntegratorStorage\APPLY_EBS11I\Repost folder.  These will get picked up on the next run of the Java Integrator for Apply.

f.        The entry in the rmx_interface table will provide an ID value that is used throughout the processing of that resume.  You can use this ID value as a filter when looking at the staging tables or looking at the rmx_diagnostics table (it is the reference_id value in the rmx_diagnostics table)

7.       The overseer job runs as a concurrent batch job on your Oracle database

a.       All configuration settings for the running of the overseer job are set in the rmx_configuration table.

b.      The rmx_configuration table setting for Overseer Interval determines how many seconds between run intervals.  The default setting is 300 seconds (5 minutes)

c.       If you need to repost a resume to Oracle – do not change the status of the failed transaction to NEW.  Instead you will need to get the XML file from the Windows server with the Java Integrator and copy it from the C:\TalemetryIntegratorStorage\APPLY_EBS11I\ Archive folder to the C:\TalemetryIntegratorStorage\APPLY_EBS11I\Repost folder.

8.       The overseer job extracts the data from the XML and places it into staging tables

a.       If you query any of the rmx staging tables and filter them by ID (the ID from the rmx_interface table) then you can view the data extracted from the XML

9.       The overseer job then uses the data from the staging tables to create or update an application using the delivered Oracle API

a.       If the applicant is a duplicate of an existing applicant as identified by the email address then an update will be made to the existing applicant rather than creating a duplicate

b.      The settings used to determine whether to update an existing applicant are in the rmx_configuration table and are Replace Existing Work History, Replace Existing Education.

10.   The overseer job writes log data to the rmx_diagnostics table

a.       To look at the details of a transaction and if there were any issues, query the rmx_diagnostics table where reference_id = (the value from the rmx_interface table)

b.      Any lines with a status of WARNING will indicate a problem with a specific piece of data posting that does not prevent the applicant data from being created

c.       Any lines with a status of ERROR indicate a problem that stopped the entire application from posting

11.   If email Autoreplies are turned on then an email will be sent to the applicant with their login credentials

a.       The setting to send email are in the rmx_configuration table

                                                               i.      Postman Enabled must be set to Yes

                                                             ii.      Applicant Email Desired must be set to Yes

b.      The SMTP server must be setup within your Oracle environment

c.       The subject line for the email is pulled from the rmx_configuration table - Autoreply Subject Text

d.      The text of the email is pulled from the rmx_documents table – CANDIDATE_NOTIFICATION.html.  This field is an HTML blob and can be updated with any standard HTML tags.

12.   The applicant appears in the Oracle iRecruitment interface

 

Apply

  1. What is Talemetry Apply?
  2. What is Talemetry Apply Workflow?
  3. Can Apply Workflow support different workflows?
  4. What are the configurable steps available in Apply Workflow?
  5. What are Candidate Questions in Apply Workflow?
  6. Tutorial: Apply Workflow - Configure Settings
  7. Tutorial: Apply Workflow - Create a basic workflow
  8. Tutorial: Apply Workflow - Configure Welcome Page Options
  9. Tutorial: Apply Workflow - Configure Apply Social Media Options
  10. Tutorial: Apply Workflow - Configure Review Page Options
  11. Tutorial: Apply Workflow - Configure Candidate Question Page Options
  12. Tutorial: Apply Workflow - Configure Final Page Options
  13. Configuration: iRec Connector: Import only Degree Awarded Year for Education
  14. Support: iRec: ORA-06550: line 21, column 39: PLS-00103: Encountered the symbol "..." when expecting one of the following: ...
  15. Support: iRec: When deploying Website integration to Prod iRec 12, deployment fails.
  16. Support: PeopleSoft: "Document Too Small" but document parses fine using Apply Parsing Testing Tools.
  17. Support: PeopleSoft: Intermittent Error - Gateway General Connection Failed (158, 10836)
  18. Talemetry Apply: Virus Scanning
  19. Support: iRecruitment: Social Apply Widget shows Error. Cannot attempt to upload resume.
  20. Why Candidate Questions & Answers (Q & A's) may not appear on candidate profiles in Talemetry
  21. How to reset your Customer Account Manager (CAM) password
  22. Difference between Company Accounts, Company Users, and Resume Processing Accounts in Customer Account Manager (CAM)
  23. Resume Extraction Guidelines for Talemetry Apply
  24. PeopleSoft/Listener: Duplicate Applicant Records Appear in PeopleSoft
  25. A Quick Guide to Troubleshooting the Apply Add-ins with PeopleSoft.
  26. iRecruitment Talemetry Apply Integrator Integration Guide
  27. PeopleSoft: Talemetry Candidate Issues - General Troubleshooting Tips
  28. Apply Workflow How-To Guide - How do I hide the link "Skip this step and apply manually" ?
  29. PeopleSoft Oracle Bug - "Data being added conflicts with existing data (18,2)" error on Career Portal.
  30. PeopleSoft - Application Data not saving correctly- LOSS of data (PS 8.9, 9.0, 9.1)
  31. PeopleSoft - Error "Highlighted fields are required. (15,30)"
  32. What is RMX Enterprise? (Resume Mirror Parsing Web Service)
  33. Talemetry Add-ins, Turning on Logging for Troubleshooting Purposes
  34. Talemetry Integrator - How to Repost an Apply Transaction
  35. Talemetry Apply URL Does Not Work for Oracle EBS

Feedback and Knowledge Base