HSDL vs HDL

-

 What are the differences between HDL and HSLD in Oracle HCM Cloud?

HSDL

Vs

 HDL

HCM Spread Data Loader

 

HCM Data Loader

We need to install the ADFdi Plug-on Excel

 

No need to install ADFdi Plug-in

User Friendly

 

It is not user-friendly

A normal consultant can fill in the data in Excel

<50,000 records

 

Technical expertise is required to prepare the DAT file

>50,000 records

If we load more than  50,000 records

then we may encounter problems like:

Excel stopped working

Session Time-out

 

We can load unlimited records. We will prepare .DAT file

We will just fill the data in the Excel sheet

If any errors occur, we can fix it in the same

Excel sheet.

 

We have to check the error logs and then we need to identify the error, correct it and then redo process.

Day-to-Day transactions.(500-1000 records per day)

 

It is used in the data migration process.

Bulk Data or Large Volume of data.

It will be simple while filling the data in Excel

No integration option.

 

If we skip or give the wrong spelling of one word or skip one letter, then the entire process fails.

It will import Row-by-Row

 

HDL can be used for integration or automation

all rows in a single shot.

Comments

Post a Comment

Popular posts from this blog

Importance of Incremental Data in Oracle Fusion

-
 What is incremental data? Incremental Data Loads ----------------------- If you are sending employee data to a third-party payroll provider on every Friday, we don’t want to send all employees instead we only want the ones who changed current week. In this scenario, "LAST_UPDATE_DATE" column in the table plays vital role. LAST_UPDATE_DATE tells us when the record was physically saved. */ --Examples: ------------------------------- select count(1) from ( Select  papf.person_number, ppnf.FULL_NAME from  per_all_people_f papf, per_person_names_f ppnf WHERE 1=1 and papf.person_id=ppnf.person_id  and papf.LAST_UPDATE_DATE >=sysdate-7 --(Incremental) and ppnf.NAME_TYPE='GLOBAL' and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE and sysdate between ppnf.EFFECTIVE_START_DATE and ppnf.EFFECTIVE_END_DATE ) Result:  55 Records(Only Changed Records in current week) --------------------------------- select count(1) from ( Select  papf.person_n...
Read more

REST Web Service in Oracle Fusion to manage Banks

-
 REST Web Service  ================= Rest Resources Resources would have 5 end-points(methods) usually.  Ex: Create a Bank Read-Get a/all Banks Update Bank Delete a Bank Fusion Navigation for managing Banks  Setup and Maintenance Tasks Global Tasks Manage Banks Get All Banks  /fscmRestApi/resources/11.13.18.05/cashBanks https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks Get a specific Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Create a Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks patch  Update  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Put https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Delete  https://fa-eubg-saas...
Read more