Configure the Oracle HCM Cloud Environment Extract

To configure the HCM Environment Extract, you can either create an extract for Oracle HCM OFS Employee Extract and Oracle HCM OFS WorkSchedule Extract or upload the existing extract in the Oracle HCM Cloud environment and configure the required changes.

  1. Create an HCM Extract: Follow the HCM Extract document to create a new extract.
  2. Upload the Pre-built extract to the Oracle HCM Cloud Environment, update it (if required) and configure it. This is a recommended step. Follow these steps to upload and configure extract:
    1. Log in to the Oracle HCM Cloud Environment and navigate to Manage HCM Extract Definitions. Follow this path: My Client Groups > Data Exchange > Extract Definitions (Under HCM Extracts) or Setup and Maintenance > Manage HCM Extract Definitions.
    2. On the Extract Definitions page, click Import.
      This screenshot shows the Extract Definitions page where Import is highlighted:
      Extract Definitions page where Import is highlighted
    3. Enter the extract name, select the Changes Only check box and upload the extract file. The following sample files are available for download here.
      • HCM_EmployeeExtract.xml
      • HCM_WorkScheduleExtract.xml
    4. Click OK.
    5. Click OK.
    6. Click Edit next to the newly created extract.
      This screenshot shows the Edit button for the newly created extract:
      Edit button for the newly created Extract
    7. Select Extract Execution Tree and click Compile All Formula.
    8. Refresh the screen and make sure all the fast formula status show passed status.
      This screenshot shows the Extract Execution Tree where Fast Formula shows the passed status:
      Extract Execution Tree where all the fast formula show the passed status
    9. Click Export XML Schema to download the .xsd file.
      This screenshot shows the Extract Execution Tree, where Export XML Schema is highlighted:
      Extract Execution Tree where Export XML Schema is highlighted
    10. Click Save and Close.