Friday, September 25, 2020

How to load profile picture for Employees/User which has been created in Oracle Fusion

 We can achieve this by HDL Process.

Roles Required: Human Capital Management Integration Specialist

We can follow the below steps to achieve the same:


Step1 . We need to create Worker.dat file by using this metadata.

 

METADATA|PersonImage|PersonNumber|ImageType|ImageName|Image|PrimaryFlag

MERGE|PersonImage|227|PROFILE|SG|SG.png|Y

 

Step 2. We need to create one directory ( eg.  BlobFiles in our case)  and keep all profile picture in this folder. Here , We have given person number as File Name of image file for identifying the person while importing.




Here , 227 is person number and his profile picture is placed in BlobFiles directory in our local system.

 Step 3.  Once we  have created Worker.dat file. Place this file in same folder structure as shown below.



Step 4. Now zip both (BlobFIles and Worker.dat) by selecting both at a time.



  Step 5. Now upload this zip file to hcm account: hcm/dataloader/import

NOTE: Have hcm data integration specialist role assigned to your user

Navigator->File Import and Export



 Step 6. Run Import Load Data program from Data Exchange.













Click on import File option-> select your data file  from UCM content files option and submit. We get an option to load the file directly from our local system








After successful run, we will be able to see the profile picture of user as shown in below screenshot.





Note :

1).  In the same way we can load employee’s bills, LIC Premium, Salary Slips etc.
2).  .jpg and .JPG are different
        It will fail if the Worker.dat has .jpg and image properties has .JPG 
        Both should match.




---------------------------------------------------------------------------------------------------------------------------

We can achieve the above using Webservice and SOAP UI.

1). Upload file to UCM



---------------
    WSDL
---------------

https://xxxx-test.fa.us2.oraclecloud.com/idcws/GenericSoapPort?wsdl

-----------------------------
  SAMPLE PAYLOAD
-----------------------------


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM">

<soapenv:Header/>

<soapenv:Body>

<ucm:GenericRequest webKey="cs">

<ucm:Service IdcService="CHECKIN_UNIVERSAL">

<ucm:Document>

<!--Zero or more repetitions:-->

<ucm:Field name="dDocTitle">Worker.zip</ucm:Field>

<ucm:Field name="dDocType">Document</ucm:Field>

<ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>

<ucm:Field name="dDocAccount">hcm$/dataloader$/import$</ucm:Field>

<ucm:File name="primaryFile" href="HDL_LOADER_Automation_Jobv1.zip">

<ucm:Contents>UEsDBBQAAAAIADZXJkpf1diH0VctAAAALgAQAAAAQmxvYkZpbGVzLzMxLkpQR+y9B1gTXbc2PClU6QYMGHoNCFKCdAi9t0RREZUmEASlCygYREEjhN4iJUJCFRUFARUFlaY0AVERfJAqIipVQYRvYjmPj+/znvO+/3Wuc/7v+rwvVtba96zZs2bvPXv23kMmG882Xunzm4YTvADA0lIeYAUAgB3ghkC/Wpmg8IA2G6jzQeGDwAAIqJlBEYIwfbXjQNn63SaDIvfdBwqKCrgvF6hLQVEFbQSob4CyGfrNhyGEePhX/RAUZxgAWHznf+hgN//g0CPeAN5W0UpDRdkMAL6qPXt2qRg6WKoCqsoqO7RVVLSVNcSUNbSVVbXVVAARgHLqW0SaYBh5320saEuc/TM62e+2HChAMgsAB5WyqqoyLPlbpBagE/y77QLakFT2r/4BoA1N/ZZnOGjDvvNEhv93+yxoM333AbMAWFL/PC7bd5sB9u8+2eCGE6ksgDtoD4J2HGhzgvY10E5OhQJMoE0F7ZTvdjFop363LzEypX6PX0VZGUL9s3Sh1G+lK8YDxvndRnKAsX23dcESh9L+jAf2k8303UaBwvwTL0aDAoKgboR+SzN4cVA2A4y2A/xtjfwdtwru6An61wPf9I7vaeB7Pj/4oO+4VcfyrppfCZzRsui3NlJcOw+0s42j+v6VUu2mnibbKMkZKLwxx7/XmtW9DkSuzn4WvzM58wyDcPnPO/jPPuK05LiGJWE5RZCM7s9vXH+elJ7HRAdBNbvOBFIz/KcAL1P+e1dPZWyDnzo4rnB6/wAI9SKxZVzstJ3tsk8xhHt4Xpj/M7gDiumk9DGrsdHZ6pZwKslzGJYgRhVPbvx25616XpsngPU7S2uPJktbmUfM+7gHPsM//AKq3VnucVRtG6vg7w2lot9p+vFIu0LxhlDdCMjkc9jXnni7T7KxcpctZTT4Jyh4X09ufSiqiqFRvQ4XTUk3hoJFhj25LJ0C11UV2VK7o2dcjbjg575rCDvudTPQbCdFiyvmeaPmwfT8a62yvovPhYfZlP8abflYj0rvic1Rak7XE0pcRxQxDn8qpSJ5u4JErdMjP5/rUSuRFGfc4Du52nsD3U9/8+1RrGrqoRmjfGTkdf89a5mbJEDWUwlaKTMh+9nHakmaVlkCMsj8bVHU1jfUtIsFQwc7WbplB0yPQ9j71JC13Kf3UYW1P8I4Of896ykjRMfmO2jZAFjuG+ZvlyCqNMZXOMuoPHvUUoKguThhjg/wAqQFV1w7u52qe3vSjPyJ8759c4X/8AVU3LFiSRBsUFnBz6VdjiDuw2kN6DvQwGLh5UAdlJ5GetXBsKsu/cen096SAgmKR42h2cnlqqhBy7n/A/59amTGkKXMgRVQLJ6+vv9O1OSCQNuzn8elUmIvREsHD4+bpn+dSkNsMO5cGmpCsVY0BDbFVcZz700oVPmooZiOR6UwGhGBOeW56etQ+UqsVIJbHI9KBi4kVFO/cw49valCSvu+cxn+dUyGSfCrJIwXnp/nirigjEazNIQIw+f4s8E1VknkXbG+wDrjv/wDqNPlNYxK7SOeVwo6/T61ZgUlyMkE/MpFSbWNVHddrPsKMeP72KtF3XeUUsg/M0WMGio11PJw+4A8j3qRLhgQcYX2PGaBco4OCQxUoDUDxRhfnccngelKxAB9WC0AAAA=</ucm:Contents>

</ucm:File>

</ucm:Document>

</ucm:Service>

</ucm:GenericRequest>

</soapenv:Body>

</soapenv:Envelope>










2). Call HCM Dataloader usingthe Content ID which we got in response of 
    previous step.

-------------
   WSDL
-------------


https://xxxx-test.fa.us2.oraclecloud.com/hcmCommonDataLoader/HCMDataLoader?wsdl



---------------------

   Sample Payload
---------------------


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:importAndLoadData>
         <typ:ContentId>UCMFA03675067</typ:ContentId>
        
      </typ:importAndLoadData>
   </soapenv:Body>
</soapenv:Envelope>	
	


No comments:

Post a Comment