Oracle HCM Cloud V1 Connector > Introduction to Oracle HCM Cloud V1 Connector > Administration of Oracle HCM Cloud V1 Connector
  

Administration of Oracle HCM Cloud V1 Connector

Before you use an Oracle HCM Cloud V1 Connector to read or write data to Oracle HCM Cloud, you must perform certain prerequisite tasks.

Prerequisite Tasks for Read Operation

Before you use an Oracle HCM Cloud V1 Connector to read data from an Oracle HCM Cloud V1 source, perform the following prerequisite tasks:
  1. 1. Create an HCM extract definitions for the data that you want to extract from the Oracle HCM Cloud application.
  2. 2. On the Oracle HCM Cloud application, configure the following properties when you create the HCM extract definitions:
    1. a. In the Extract Deliver Options page under the Manage Extract Definitions tab, set the value of the Output Type field as Data and Delivery Type field as WebCenter Content.
    2. b. Specify the values of the Integration Name and Encryption Mode fields
  3. The following image shows the Extract Deliver Options page where you can set the value of the Output Type, Delivery Type, Integration Name, and Encryption Mode fields:
  4. You can set up the Output Type, Delivery Type, Integration Name, and Encryption Mode fields under the Extract Deliver Options page in the Oracle HCM Cloud application.
  5. 3. Ensure that you submit the HCM extract definitions to the Oracle WebCenter Content Server from the Oracle HCM Cloud application. You can also use the Submit Extract connection property to submit the HCM extract definitions to the Oracle WebCenter Content Server.
  6. 4. Generate the XML schema in the XSD file format for all the HCM extract definitions and store the XSD files on the machine where the Secure Agent is installed.
  7. You must store all the XSD files in the following directory that you specify in the Schema Directory connection property: Schema Directory\Reader
  8. Oracle HCM Cloud V1 Connector supports the XSD files with a DATA_DS single root element.
  9. Note: You must use a third party tool to generate the XML schema from the output XML data. Provide the XSD files that are compatible with the output XML data. Informatica recommends that you name the XSD file in the <TemplateName>.xsd format.

Obtain the WebCenter Content URL

Before you create an Oracle HCM Cloud V1 connection to read data from an Oracle HCM Cloud V1 source, you must obtain the WebCenter Content URL where Oracle HCM Cloud uploads the output XML data.
Perform the following steps to obtain the WebCenter Content URL:
  1. 1. Obtain the URL for Oracle HCM Cloud Setup and Maintenance from the Service Details section in the cloud environments provisioning email from Oracle.
  2. The following example shows a sample URL: https://fs-<domain_name>.oracleoutsourcing.com/setup/faces/TaskListManagerTop
  3. 2. Edit the URL by removing the following path: /setup/faces/TaskListManagerTop
  4. The following URL is a sample of the WebCenter Content URL: https://fs-<domain_name>.oracleoutsourcing.com

Prerequisite Tasks for Write Operation

Before you use an Oracle HCM Cloud V1 Connector to write data to an Oracle HCM Cloud V1 target, ensure that the following roles are assigned to you:
Role
Role Code
Application Administrator
ORA_FND_APPLICATION_ADMINISTRATOR_JOB
Application Developer
ORA_FND_APPLICATION_DEVELOPER_JOB
Application Diagnostics Administrator
ORA_FND_DIAG_ADMINISTRATOR_JOB
Application Implementation Administrator
ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT
Application Implementation Consultant
ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB
Application Implementation Manager
ORA_ASM_APPLICATION_IMPLEMENTATION_MANAGER_JOB
Human Capital Management Application Administrator
ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB
Human Capital Management Integration Specialist
ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_INTEGRATION_SPECIALIST_JOB
IT Security Manager
ORA_FND_IT_SECURITY_MANAGER_JOB
Integration Specialist
ORA_FND_INTEGRATION_SPECIALIST_JOB
Note: When you write data to an Oracle HCM Cloud application, the Secure Agent does not write special characters as expected to the target.

Download and Install ADF Desktop Integration Tool

Perform the following steps to download and install the ADF Desktop Integration Tool:
    1. Login to the Oracle HCM Cloud Application.
    2. Click Navigator > Tools > Download Desktop Integration Installer.
    The application is downloaded to the desktop.
    3. Run the installer, adfdi-excel-addin-installer.exe.
    Note: For the Excel configuration to work with the ADF Desktop Integration, see the following Oracle documentation:
    https://docs.oracle.com/middleware/11119/adf/develop-desktop-integration/adf-desktop-config-env.htm

Downloading Excel Templates

Perform the following steps to download Excel templates:
    1. Login to the Oracle HCM Cloud Application.
    2. Click Navigator > Data Exchange.
    The Data Exchange page is displayed.
    3. Click View Business Objectsin the HCM Data Loader section.
    4. Click Refresh All Objects.
    5. You can filter a particular business object and refresh that specific object. Click the download icon on the View Business Objects page, under the Overview column.
    The GenericBusObjDetails.xlsx template is downloaded.
    Note: All Excel templates are downloaded with the same name, GenericBusObjDetails.xlsx. Rename the Excel templates as required.

Setting up Excel Templates

Perform the following steps to set up the Excel templates to enable the write operation:
    1. Open the downloaded Excel templates.
    2. In the Connect pop-up window, click Yes to generate the metadata for that particular object.
    3. If you have not already logged in to the Oracle HCM Cloud V1 Application, you are prompted to log in.
    4. Navigate to the Hierarchy Details, Attributes, and Flexfield Attribute sheets to ensure the complete metadata is populated for the template. Save the Excel template.
    Note: In case the data is not populated within the Excel template, verify if you have followed the steps accurately or contact Oracle Support.
    5. Place all the Excel templates in the Writer directory under the schema directory, specified in the connection properties.
    Note: Informatica recommends that you use excel templates corresponding to the latest release version of Oracle Cloud.

Prerequisite Tasks for Person Number Auto Generation

After you perform the pre-requisite tasks for the Write operation, copy the standard Excel templates and perform the modifications mentioned below.
Perform the following steps to automatically generate the Person Number for Worker objects:
  1. 1. Change the AttributeName to AttributeName(HintAtrributeName) as required. For example,
  2. 2. Change the Attribute data type to HINT Attribute data type. For example, change the data type of the PersonId(SourceSystemId) attribute from Number to String as the Hint Attribute SourceSystemId data type is String.
  3. 3. Save the Excel template with the modifications and copy it to the Writer folder within the Schema Directory.
  4. Note: After you modify the standard Excel template, you should not connect to the respective Oracle HCM Cloud instance, to avoid the loss of all modifications.
    In the Field Mapping tab, the following image shows the Hint attribute as __HINT__ AtributeName __ HintAttributeName. For Example: __HINT__PersonId__SourceSystemId.