Integration

Get Involved. Join the Conversation.

Topic

    Pooja I
    HCM CLOUD adapter in ICSAnswered
    Topic posted July 1, 2019 by Pooja IBronze Medal: 1,250+ Points, tagged Adapters, Integration, Mapping, Orchestration, SOAP 
    75 Views, 3 Comments
    Title:
    HCM CLOUD adapter in ICS
    Summary:
    Upload to HCM cloud is failing while LOADING the data set
    Content:

    Hi All,

         I am trying to upload a Worker.zip file to HCM Cloud by following the below steps:

    1. read the file from SFTP

    2. upload to UCM

    3. Upload to HCM Cloud

    i am able to upload to UCM, view the ContentID in Fusion. But the data is not visible in UI. So i called, getDataSetStatus method to check on the error.

    Below is the XML trace:

    <nstrgmpr:getDataSetStatusResponse xmlns:ns0="http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/hcm/HCMUpload_REQUEST/types">   <nstrgmpr:result xmlns="http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/">&lt;?xml version="1.0" encoding="UTF-8"?>&lt;DATA_SET_STATUS>  &lt;RESULT_COUNT>0&lt;/RESULT_COUNT>  &lt;ERROR_CODE>DATA_SET_NOT_FOUND&lt;/ERROR_CODE>  &lt;ERROR_MESSAGE>The data set with content ID UCMFA00044184 cannot be found. The data set may have been purged.&lt;/ERROR_MESSAGE>&lt;/DATA_SET_STATUS></nstrgmpr:result></nstrgmpr:getDataSetStatusResponse>

     

    The import status is success but the load status is getting failed.

    In the HCM adapter i have configured as per the attached image. But the issue is not getting resolved.

    I tried with various other configurations but nol luck.

     

    Do let me know if i have missed any configurations

    Document:
    Document:

    Best Comment

    Mani

    ok, let me see if I understand your issue correctly.

    The import status is success but the load status is getting failed.

    are you saying the dataset is visible under Data Exchange > Import and Load Data? if yes, haven't you got the error message as to why the load failed?

    i am able to upload to UCM, view the ContentID in Fusion. But the data is not visible in UI. So i called, getDataSetStatus method to check on the error.

    what parameters have you passed to GetDataSetStatus method? 

    I had to use a while loop to wait until HDL load is complete (by checking STATUS element from response of GetDataSetStatus method). but, it was done using SOAP services and not HCM adapter. not sure how different is HCM adapter for invoking the load process. if its same as SOAP service, then you have to use similar logic to induce wait or use a callback.

    Comment

     

    • Mani

      were you able to see the zip file in content server with content id UCMFA00044184 ?

      • Pooja I

        Yes.

        • Mani

          ok, let me see if I understand your issue correctly.

          The import status is success but the load status is getting failed.

          are you saying the dataset is visible under Data Exchange > Import and Load Data? if yes, haven't you got the error message as to why the load failed?

          i am able to upload to UCM, view the ContentID in Fusion. But the data is not visible in UI. So i called, getDataSetStatus method to check on the error.

          what parameters have you passed to GetDataSetStatus method? 

          I had to use a while loop to wait until HDL load is complete (by checking STATUS element from response of GetDataSetStatus method). but, it was done using SOAP services and not HCM adapter. not sure how different is HCM adapter for invoking the load process. if its same as SOAP service, then you have to use similar logic to induce wait or use a callback.