The scope of the assignment was syncing up Employee Profile Pictures to ePerform (SuccessFactors PMGM) and eLearn (SuccessFactors LMS) from Oracle Fusion (existing Core HR system) in an ongoing process. So whenever an employee is hired in Oracle Fusion, the system will automatically sync the profile pictures from source (Oracle Fusion) to destination (SAP SuccessFactors)
Steps for Ongoing Photos Upload Process:
Login to Provisioning/Backend->Go to Company/Instance->Create a Batch Upload Job giving scheduled frequency of job and details of SFTP server and mapping file->Schedule Batch Upload Job->Job runs based on the scheduled timings and process the mapping file and upload photos in the file to the SF system->Emails will be triggered giving details of count of successful records and details of failed records
SFTP incoming folder where mapping file and photos are placed through Oracle Fusion Job for uploading:
Once the SF job is completed, photos are uploaded in SF portal as below:
Home Page:
Goals Page:
Performance Page:
Learning Page:
Company Info->Org Chart:
Company Info->Directory Search:
My Employee File Page:
Different scenarios that could be encountered in photo uploading process along with sample emails triggered are as follows:
Case 1: All records in mapping file are successfully processed and there are no failed records.
Email will trigger at start of job to Job Owner (it will be for ePerform user)-
Note: Start of Job email format will be same for all cases.
Email will trigger after completion of job to Job Owner (it will be for ePerform user)
In Scheduled Jobs page job status will be
Completed which cannot be re-run manually-
Case 2: All records in mapping file are not successfully processed and there are few failed records.
Email will trigger after completion of job to Job Owner (it will be for ePerform user)-
In Scheduled Jobs page job status will be
Completed which cannot be re-run manually-
Error Handling: Here user should manually rectify the errors and update the mapping file in SFTP folder-
Login to SFTP and go to the folder where files and photos are placed-
Download the mapping file offline (here otsukatest_photos_171229.csv)-
Mark the file for downloading and click download button-
Open the file, make the correction (here error is due to username mismatch so change the username Adams to adams same as in SF system), save the file and upload back to SFTP folder-
Now this rectified file will be processed by 2
nd SF job in the evening. If there are still few error records left even after the 2
nd SF job run then those records should be corrected and placed in the next day mapping file before the SF job runs in morning.
Finally there can be several other used-cases such as Job has failed as Job owner becomes inactive in the system, Job has failed as no file is placed by fusion job in SFTP server, etc., which too this integration can suffice. Hopefully we can cover all this cases as required while integrating with Oracle Fusion or Workday or any other tool for photo uploading with SAP SuccessFactors.