HCM Data Loader Data Sets
dataLoadDataSets Based on latest (2026.09)
Look up HCM Data Loader Data Sets, with business objects, messages and processes. Actions include create file data set and create spreadsheet data set. Changes only through its actions.
- Operations
- GET (list)GET (one)12 actions
- Record key
RequestId- Required on create
- no create on this resource
- At a glance
- 43 fields1 finders4 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /hcmRestApi/resources/11.13.18.05/dataLoadDataSets?fields=ContentId,CreatedBy,CreationDate,DataSetId,DataSetName&limit=25&onlyData=true
{
"items": [
{
"ContentId": "<string, max 30>",
"CreatedBy": "<string, max 64>",
"CreationDate": "2026-01-31T09:00:00+00:00",
"DataSetId": 0,
"DataSetName": "<string, max 200>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's latest (2026.09) REST specification.
Fields 43
| Attribute | Type | Use |
|---|---|---|
ContentId | text · max 30 | Read-onlySearchable |
CreatedBy | text · max 64 | Read-only |
CreationDate | date-time | Read-only |
DataSetId | number | Read-onlySearchable |
DataSetName | text · max 200 | Read-onlySearchable |
DataSetStatusCode | text · max 30 | Read-onlySearchable |
DataSetStatusMeaning | text · max 80 | Read-onlySearchable |
FailedLinesFileContentId | text · max 30 | Read-only |
FailedLinesFileEncryptionKey | text · max 255 | Read-only |
FailedLinesFileEncryptionType | text · max 30 | Read-only |
FileLineImportErrorCount | number · default 0 | Read-only |
FileLineImportSuccessCount | number · default 0 | Read-only |
FileLineTotalCount | number · default 0 | Read-only |
FileSize | number | Read-only |
ImportPercentageComplete | number | Read-only |
ImportStatusCode | text · max 30 | Read-onlySearchable |
ImportStatusMeaning | text · max 80 | Read-onlySearchable |
ImportSuccessPercentage | number | Read-only |
IntegrationTypeCode | text · max 30 | Read-onlySearchable |
IntegrationTypeMeaning | text · max 80 | Read-onlySearchable |
LastUpdateDate | date-time | Read-only |
LastUpdatedBy | text · max 64 | Read-only |
LoadPercentageComplete | number | Read-only |
LoadStatusCode | text · max 30 | Read-onlySearchable |
LoadStatusMeaning | text · max 80 | Read-onlySearchable |
LoadSuccessPercentage | number | Read-only |
ObjectLoadErrorCount | number · default 0 | Read-only |
ObjectRollbackErrorCount | number | Read-only |
ObjectSuccessCount | number · default 0 | Read-only |
ObjectTotalCount | number · default 0 | Read-only |
ObjectUnprocessedCount | number · default 0 | Read-only |
ProtectedFlag | yes/no · max 255 | Read-only |
RequestId | number | Read-onlySearchable |
Review | text · max 255 | Read-only |
SourceTypeCode | text · max 30 | Read-onlySearchable |
SourceTypeMeaning | text · max 80 | Read-onlySearchable |
SpreadsheetMessage | text · max 500 | Read-only |
SpreadsheetTemplateCode | text · max 80 | Read-onlySearchable |
SpreadsheetTemplateName | text · max 120 | Read-onlySearchable |
SpreadsheetTemplateUserTypeCode | text · max 50 | Read-only |
SpreadsheetTemplateUserTypeMeaning | text · max 80 | Read-only |
TransferStatusCode | text · max 30 | Read-onlySearchable |
TransferStatusMeaning | text · max 80 | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByRequestId·RequestId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 4
Child resources sit under one record: /hcmRestApi/resources/11.13.18.05/dataLoadDataSets/{RequestId}/child/<name>. Add them to a GET with expand.
businessObjectsGET Data Set Business Objects · 34 fieldsBusinessObjectDiscriminatorBusinessObjectIdBusinessObjectNameCreatedByCreationDateDatFileNameDataSetBusObjIdDataSetIdFailedLinesFileContentIdFailedLinesFileEncryptionKeyFailedLinesFileEncryptionTypeFileLineImportErrorCountFileLineImportSuccessCountFileLineTotalCountImportPercentageCompleteImportStatusCodeImportStatusMeaningImportSuccessPercentageLastUpdateDateLastUpdatedByLoadOrderLoadPercentageCompleteLoadStatusCodeLoadStatusMeaningLoadSuccessPercentageObjectLoadErrorCountObjectRollbackErrorCountObjectSuccessCountObjectTotalCountObjectUnprocessedCountRequestIdRollbackEnabledFlagTransferStatusCodeTransferStatusMeaningmessagesGET Messages · 46 fieldsBusinessObjectDiscriminatorConcatenatedUserKeyDatFileNameDataSetBusObjIdDataSetIdEffectiveEndDateEffectiveLatestChangeEffectiveSequenceEffectiveStartDateFileLineFusionGUIDGeneratedByCodeGeneratedByMeaningLineOperationMessageLineIdMessageTextMessageTypeCodeMessageTypeMeaningMessageUserDetailsOriginatingProcessCodeOriginatingProcessNameReportedAgainstCodeReportedAgainstMeaningSourceReference001SourceReference002SourceReference003SourceReference004SourceReference005SourceReference006SourceReference007SourceReference008SourceReference009SourceReference010SourceReferenceName001SourceReferenceName002SourceReferenceName003SourceReferenceName004SourceReferenceName005SourceReferenceName006SourceReferenceName007SourceReferenceName008SourceReferenceName009SourceReferenceName010SourceSystemIdSourceSystemOwnerSurrogateIdprocessesGET Submitted Processes · 24 fieldsBusinessObjectNameCreatedByCreationDateDatFileNameDataSetBusObjIdDataSetIdElapsedTimeEndTimeErrorCountFileActionCodeFileActionMeaningLastUpdateDateLastUpdatedByParentRequestIdProcessCodeProcessIdProcessNameRequestIdStartTimeSuccessCountThreadsAllocatedThreadsUsedTotalCountUnprocessedCountsubprocessesGET Submitted Subprocesses · 14 fieldsCreatedByCreationDateElapsedtimeEndTimeLastUpdateDateLastUpdatedByParentrequestidProcessCodeProcessIdProcessNameProcessStatusCodeProcessStatusMeaningRequestIdStartTime
Actions 12
POST …/action/createFileDataSet·deleteSourceFileFlagdataSetNamecontentIdloadConcurrentThreadsimportMaxErrorPercentageverificationKeyloadMaxErrorPercentagefileEncryptionfileActionimportConcurrentThreadsPOST …/action/createSpreadsheetDataSet·newLineIndicatordeleteSourceFileFlagdateFormatdataSetNamecontentIdtemplateCodeverificationKeyfileEncryptionfileActionheaderIncludedFlagattributeDelimiterescapeIndicatorloadConcurrentThreadsimportMaxErrorPercentageloadMaxErrorPercentageimportConcurrentThreadsPOST …/action/findByAdvancedSearchQuery·offsetquerylimitsearchFieldsfilterssortdisplayFieldsautocompleteQueryPOST …/action/uploadFile·fileNamecontentIdcontentfileEncryptionPOST …/{RequestId}/action/deleteDataSet·deleteSourceFileFlagdeleteOracleSearchRecordsFlagPOST …/{RequestId}/action/deleteSpreadsheetDataSetPOST …/{RequestId}/action/generateFailedLinesFile·messageLanguageencryptionKeyfileEncryptionincludeMessagesFlagPOST …/{RequestId}/action/stopPOST …/{RequestId}/action/submit·loadConcurrentThreadsfileActionPOST …/{RequestId}/child/businessObjects/{DataSetBusObjId}/action/generateFailedLinesFile·messageLanguageencryptionKeyfileEncryptionincludeMessagesFlagPOST …/{RequestId}/child/businessObjects/{DataSetBusObjId}/action/stopPOST …/{RequestId}/child/businessObjects/{DataSetBusObjId}/action/submit·loadConcurrentThreadsfileAction
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/hcmRestApi/resources/11.13.18.05/dataLoadDataSetsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByRequestIdfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:ContentId, notcontentid. - Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.