Data Loader
Service to operate HCM Data Loader. This service provides access to HCM Data Loader to automate the bulk loading of data.
Life Cycle Status: Active
QName: {http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/}HCMDataLoader
Service WSDL URL: https://servername/hcmService/HCMDataLoader?WSDL
Operations
importAndLoadData
Initiates bulk loading of file-based data to Oracle Fusion HCM using HCM Data Loader.
Life Cycle Status: Active
Request Payload
| Element Name | Type | Description |
|---|---|---|
|
ContentId |
string |
Unique identifier of the Web Center content file to be imported and loaded using HCM Data Loader. |
|
Parameters |
string |
Parameters passed as name and value pairs. |
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
string |
Return parameter containing information about the request identifier to initiate import of data and load job submission. |
getDataSetStatus
The operation will provide the information required for monitoring systems to understand the status of, and error messages raised for the Data Set.
Life Cycle Status: Active
Request Payload
| Element Name | Type | Description |
|---|---|---|
|
Parameters |
string |
Parameters passed as name and value pairs |
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
string |
Response xml returned for the input passed |
getDfltObjAttrHints
Method to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.
Life Cycle Status: Active
Request Payload
| Element Name | Type | Description |
|---|---|---|
|
viewName |
string |
Service view usage name, an internal name for the service data object. Specify the value of the <name> element from the getEntityList operation response payload. |
|
localeName |
string |
Locale to use when evaluating locale-based user interface hints. The localeName is in ISO 639-1 format. |
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
{http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints |
Return parameter containing information about the label and user interface hints for the specified service data object and its attributes in a name-value pair format. |
getServiceLastUpdateTime
Method that returns the date and time when the schema files referenced in the service definition last changed.
Life Cycle Status: Active
Request Payload
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Return parameter containing information about the date and time when the service definition last changed in ISO 8601 format. |
getEntityList
Method to get the list of service data objects defined on this service.
Life Cycle Status: Active
Request Payload
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
{http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo |
Return parameter containing information about the list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and Boolean values indicating whether create, update, merge, and delete operations can be performed on the object. |
Security
The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.
Service Operations to Privileges Mapping
| Operation Name | Privilege Code | Privilege Name | Privilege Description |
|---|---|---|---|
|
All Operations |
HRC_LOAD_HCM_DATA_PRIV |
Load HCM Data |
Allows load of HCM business object data. |
|
All Operations |
HRC_LOAD_DATA_USING_HSDL_PRIV |
Load Data using HCM Spreadsheet Data Loader |
Allows access to generate spreadsheets for bulk data loading using HCM Spreadsheet Data Loader. |
Privileges to Duty Roles Mapping
| Privilege Code | Granted to Duty Role Code | Granted to Duty Role Name | Granted To Duty Role Description |
|---|---|---|---|
|
HRC_LOAD_DATA_USING_HSDL_PRIV |
ORA_HRC_LOAD_ALL_DATA_SETS_USING_REST |
Load All Data Sets using Data Load Data Sets REST Service |
Allows the user to load all data sets using the Data Load Data Sets REST service.. |
|
HRC_LOAD_DATA_USING_HSDL_PRIV |
ORA_HRC_HSDL_DATA_SET_ADMINISTRATION |
HCM Spreadsheet Data Loader Data Set Administration |
Allows access to all active HCM Spreadsheet Data Loader templates, allowing the user to generate spreadsheets for bulk data loading. Also allows access to all data sets. |
|
HRC_LOAD_DATA_USING_HSDL_PRIV |
ORA_HRC_REST_SERVICE_ACCESS_DATA_LOAD_DATA_SETS |
Use REST Service - Data Load Data Sets |
Allows the user to load their own data sets and data sets for templates that have been granted to their roles with view all data sets access using the Data Load Data Sets REST Service. |
|
HRC_LOAD_DATA_USING_HSDL_PRIV |
ORA_HRC_LOAD_DATA_USING_HSDL |
Load Data using HCM Spreadsheet Data Loader |
Allows access to generate spreadsheets for bulk data loading using HCM Spreadsheet Data Loader. |
|
HRC_LOAD_HCM_DATA_PRIV |
ORA_HRC_LOAD_ALL_DATA_SETS_USING_REST |
Load All Data Sets using Data Load Data Sets REST Service |
Allows the user to load all data sets using the Data Load Data Sets REST service.. |
|
HRC_LOAD_HCM_DATA_PRIV |
ORA_HRC_REST_SERVICE_ACCESS_DATA_LOAD_DATA_SETS |
Use REST Service - Data Load Data Sets |
Allows the user to load their own data sets and data sets for templates that have been granted to their roles with view all data sets access using the Data Load Data Sets REST Service. |
|
HRC_LOAD_HCM_DATA_PRIV |
ORA_HRC_LOAD_DATA_USING_HDL |
Load Data using HCM Data Loader |
Allows load of HCM business object data. |
|
HRC_LOAD_HCM_DATA_PRIV |
ORA_HRC_LOAD_ALL_BO_USING_HDL |
Load All Business Objects using HCM Data Loader |
Allows load of all unrestricted HCM business objects. |