HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-party systems. If you are integrating Oracle HCM with any external system, you will almost certainly use an extract.
The Three Components of an HCM Extract
- Data Groups — define which database objects (tables/views) to query
- Extract Attributes — the specific columns/fields to extract from each data group
- Extract Definitions — the output format and delivery method (flat file, XML, CSV)
Step-by-Step: Create a Basic Employee Extract
- Navigate to Data Exchange → Manage HCM Extract Definitions
- Click Create → Name it (e.g. "Employee Master Extract")
- Add a Data Group linked to the
PER_ALL_PEOPLE_Fview - Add attributes: Person Number, Name, Hire Date, Department, Grade, Email
- Add a filter:
Effective Date = Effective Date Parameter - Set output format to CSV, delivery to UCM (Universal Content Management)
- Submit a test run in Sandbox with a small population
✦ Always filter your extract by
effective date rather than pulling all history. Full-history extracts can take hours to process for large employee populations and will overwhelm downstream systems.Payroll Interface Extracts — Special Considerations
- Use the delivered Payroll Interface extract templates as your starting point — do not build from scratch
- The payroll interface extract must run before each payroll processing run
- Include a checksum or record count in your output file so the downstream system can validate completeness
- Schedule the extract using HCM Extracts → Schedule Processes, not manually
