You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Using chunk size and threading to improve the Historical Assignment hcm extract performance issue

edited Apr 24, 2024 6:18PM in HCM Extract 1 comment

Summary:

I have created an HCM Extract for assignment that retrieves historical data for employees. There is no date filter, it picks up past, future and present.There are 144567 employees that it retrieves in the baseline file and it is taking 1 hour 30 min to run even when we run for incremental loads using the changes only parameter.

To improve the performance I used the process configuration group and made the following changes -

Now it is completing in 60 min. What should be the most optimal value that i pass in chunk size and thread so that this process runs undr 30 min.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!