How do I run extracts to view results?

Title and music.

Hello, my name is Ken. In this video I’ll explain where to review extract run results.

I’ll view the run results for a completed extract definition that extracts person details.

First, we must submit the extract. There are two ways to submit the extract.

You can submit directly from your extract definitions task.

Or from the Data Exchange work area in the HCM Extracts section you’ll select the Submit Extracts task.

We’ll submit from the latter.

Let’s navigate to the Submit Extracts task.

In the Data Exchange section, I’ll choose Submit Extracts.

Here I can search for the extract that I want to submit: Extract Person Details

I’ll name the extract instance: Run Extract Person Details

I’ll select an Effective Date: today's date

And then submit it.

I’m then taken to the View Extract Results page.

Click Refresh until the extract completes, showing a check mark next to it.

Then click on the extract name.

When I go to view the results, I can expand the Extract Delivery Options section.

The extract output will be displayed in the required format based on the delivery option configurations.

For this example, we have XML output.

Click the icon.

I’ll choose to open the file with the default option and click OK.

Within the output file you can see the attribute names appearing in the record I created within the data group.

Notice how the hierarchy was created showing the extract data group, the record, and the attributes.

If I want to view the results later, I can go to the View Extract Results task in the Data Exchange work area.

Search for the instance name to view the results.

Expand the Extract Delivery Options section and open the file.

Select how you want to view it.

And the same results that we just viewed are displayed here.

For more information on this topic, you can view the courses on Oracle University or reference the available guides on Oracle Help Center.

Thanks for watching.