Oracle Fusion Multiple attachment for an Employee for a Single Document type HDL - HCM Data Loader

-

 

Multiple attachment for an Employee for a Single Document type Oracle Fusion 

HDL - HCM Data Loader for Loading Document of Records

 In our example we are going to use “Return to Work” as the document type.

 Preparation of the Attachment Folder

Create a Folder “BlobFiles”.

Place four attachment file 109_RTW .pdf , 110_CRT.pdf, Check.txt, First.docx inside “BlobFiles” folder.

The attachment files can be .pdf, .txt, .docx etc…

Folder name should be only “BlobFiles”. If you provide some other name then it will complete with error.

 

Preparation of the dat File

The dat file should have the name “DocumentsOfRecords.dat” with the below information.

 

METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DocumentCode|DocumentName

MERGE|DocumentsOfRecord|5791|Return to Work||5791 RTW|RTW Certificate from Dr

METADATA|DocumentAttachment|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|URLorTextorFileName|Title|File

MERGE|DocumentAttachment|5791|Return to Work||5791 RTW|FILE|RTW.pdf|Return to Work_1|109_RTW.pdf

MERGE|DocumentAttachment|5791|Return to Work||5791 RTW|FILE|CRT.pdf|Return to Work_2|110_CRT.pdf

MERGE|DocumentAttachment|5791|Return to Work||5791 RTW|FILE|Mara.txt|Return to Work_3|Check.txt

MERGE|DocumentAttachment|5791|Return to Work||5791 RTW|FILE|King.docx|Return to Work_4|First.docx

 

Preparation of the Zip file

Compress the “BlobFiles” and “DocumentsOfRecords.dat” to a Zip file “XXMultipleAttachments.zip”

You can provide Zip file name as you wish.

 

XXMultipleAttachments.zip will have the BlobFiles Folder and DocumentsOfRecords.dat file

 

BlobFiles Folder will have the below files

 


 

Before uploading lets see the Attachment of the employee using below navigation

 

My Client Groups à Person Management



 

As below the Employee doesn’t have any documents attached.

 

Document Records

 


 


 

Upload the zip file as below Navigation

Navigation à  My Client Groups à Data Exchange

 


 

HCM Data Loader à Import and Load Data

 


 

Import File

 


 

 

Once loaded Successfully the Employee attachment Document of Records will appear as below.

 

My Client Groups à Person Management

 


 



Please leave your comment and also watch on YouTube for more information about this post.




Comments

  1. Guyan14 September 2020 at 01:20

    Can you please add the attachment

    ReplyDelete
  2. prakashraaj14 September 2020 at 02:18

    I don't have option to add attachment in this blog

    ReplyDelete
    Replies
    1. Oracle Apps KT1 February 2021 at 20:56

      Hi Prakash, Thanks for the good article. You can upload the attachment as google drive Shared link.

      Delete
    2. Prakash Raaj12 June 2021 at 02:57

      This comment has been removed by the author.

      Delete
    3. prakashraaj12 June 2021 at 03:05

      Ya, That's Good Idea, Okay I will do that. Thank you.

      Delete

Post a Comment

Popular posts from this blog

Run BI Report Web Service Multiple Parameter date format Oracle Fusion BI Report xmlpserver/services/v2/ReportService WSDL

-
Image
  Run BI Publisher Report WSDL Web Service with Multiple Parameter which includes date format in oracle fusion We will use the below WSDL web service for Running the BI Publisher Report to extract the output in PDF. https://e.oraclecloud.com/xmlpserver/services/v2/ReportService?wsdl Create Data Model Sql Query select username,user_id,start_date,active_flag  from PER_USERS where user_id = nvl(:p_user_id,user_id) and trunc(start_date) = nvl(:p_start_date,trunc(start_date))   Parameter p_user_id p_start_date Output from the Data Model     Save the Data model /Custom/Human Capital Management/FusionReports/XXHRReportWEbSrv.xdm Create the Report   Select the existing data model Select the View List and Make sure the Output Formats as PDF selected as option.   Incase of updating the template delete the existing template and upload the new template.   Report Stored Path: /Custom/Human Capital Management/FusionReports/XXHRReportWEbSrvReport.xdo https://e.o...
Read more

Programmatically Create/Update User and assign roles in oracle Fusion using the REST Web Services Part 1

-
Image
Programmatically Create/Update User and assign roles in oracle Fusion using the REST Web Services  Part 1 Below are the steps that will be covered in this Post to Manage the User information using  REST Web Service using the Postman Tool 1) POST method to create a user along with Password and email using below REST Web service      / hcmRestApi/scim/Users 2) GET method to query the user  using below REST Web service      /hcmRestApi/scim/Users/{id} 3) PATCH method to update and assign the Roles to the user using below REST Web service      /hcmCoreSetupApi/scim/Roles/ {id}  4) PATCH method to update the user information  using below REST Web service      /hcmRestApi/scim/Users/{id}        Three Operations  will be Performed in Postman Tool 1) POST Operation used for CREATION 2)  GET Operation used for QUERY 3)  PATCH Operation used for UPDATE   REST Web ...
Read more