inqicon

START A CONVERSATION

Share your requirements and we'll get back to you with how we can help.

Thank you for submitting your request.
We will get back to you shortly.

DoQ—One-Click Tool to Bulk-Load Docs in Oracle HCM Cloud

No more DAT file (metadata) preparation, manual data validation, and other painstaking processing to bulk-upload documents in Oracle HCM Cloud. Move documents en masse with a single click using DoQ.

DoQ logo

Challenges in Bulk-Loading Employee Documents

Every new Oracle HCM Cloud deployment necessitates migration of large numbers of employee-related documents from legacy systems. Similarly, during mass recruitment, a large number of employee records are created and relevant documents have to be attached to them. This process of uploading employee documents is fraught with pain for business users.

While HCM Data Loader (HDL) developed by Oracle for bulk-uploads addresses many of the limitations that its predecessor File Based Loader (FDL) had, the tool requires technically skilled personnel to process the documents. Due to missing pre-validation, the risk of human errors is ever present and the hard-to-understand error messages make rectification difficult. All of these make the bulk document uploading process highly cumbersome.

How DoQ Integrator Makes Bulk Document Uploads Simple

DoQ links third-party application data with Oracle HCM Cloud and leverages Oracle’s web services to bulk transfer employee documents to the Cloud. At the core of the bulk-loading processes are DAT files that contain all the metadata required to process and attach employee documents.

DoQ Integrator adopts an approach that is different from other data loader tools, whereby users can prepare the documents to be attached using a simple Excel sheet—a tool that all business users are familiar with. DoQ’s Auto-Cloud Upload option takes care of the rest.

User Prepare User prepares the source folder
Arrow
User Enter User enters environment address and login credentials
Arrow
User Select User selects the source folder and starts the process
Arrow
Auto Colud Auto-cloud upload
User Prepare
User prepares
the source folder
Arrow
User Enter
User enters
environment address
and login credentials
Arrow
User Select
User selects the
source folder and
starts the process
Arrow
Auto Colud
Auto-cloud
upload

To initiate upload, business users have to create only two things: a source folder with all the documents to be attached and a simple Excel sheet containing all the corresponding information. After logging into DoQ, they select the folder to be processed. DoQ generates the necessary DAT files, executes the required validation, and automatically uploads the documents in Fusion HCM Cloud—all at a single click.

Auto-Cloud Upload Processes Triggered By DoQ

01
File Processing
File
Processing

The attachments and Excel data sheet in source folder are processed

02
DAT file generation
DAT File
Generation

A DAT file is created and zipped along with the attachement files

03
Upload UCM Server
Upload
to UCM Server

The ZIP files are uploaded into the intermediate UCM server

04
Transfer HCM Server
Transfer
to HCM Server

The data in the ZIP files are loaded into the HCM server

05
Update Person Records
Person Record
Update
to Person Record

The data after verification is updated in Person Records in Fusion HCM

1. File Processing

The attachments and Excel data sheet in source folder are processed

2.DAT File Generation

A DAT file is created and zipped along with the attachement files

3.Upload to UCM Server

The ZIP files are uploaded into the intermediate UCM server

4.Transfer to HCM Server

The data in the ZIP files are loaded into the HCM server

5.Update to Person Record

The data after verification is updated in Person Records in Fusion HCM

Simple Setup: Setting up DoQ is quite easy. Refer to our Quick Setup Guide for brief instructions on how to download, configure, and run DoQ. For detailed instructions on how to navigate the features, our DoQ User Guide will come in handy.

DoQ Features

  • Built-in algorithm to automatically batch upload documents
  • Simple, automated operations for business users
  • Manual upload option for advanced technical users
  • User-friendly interface to track upload stages
  • Access control to ensure system security
  • Integration with platform-specific data extraction tools

DoQ supports all formats supported by HDL

.DOCX .DOC .PDF
.TXT .JPEG .PNG

Benefits of DoQ Integrator

  • Removes the complexity of uploading documents in Oracle HCM Cloud
  • Empowers business users to undertake document uploading by themselves
  • Overcomes the single-upload limitation of HDL through batch processing
  • Reduces errors caused by manual creation of DAT files
  • Reduces data migration failure through automated prevalidation

Eliminate the burden in HCM document uploads

Write to Us