Simple Steps to Create an HCM Extract.

Steps to Create an HCM  Extract :

1. Login to HCM
2. Go to data exchange. 
3. In Tasks (Right menu), select Manage Extract Definition. 
4. Select create ( + )
5. Give a name to Extract.
6. Give Start Date value. 01-Jan-2000  
7. The Start date is an effective start date that applies to all date-effective interactions in the current session.
8. Select extract type
• HR Archive is for getting assignment and person details. 
• Payroll interface is for getting payroll related details.
9. Create Data Group
• Give Group Name. 
• Give Display  Name. 
• Select User Entity based on the data you want to extract.  
•  Example :
•  PER_EXT_SEC_ASSIGNMENT_UE     PER_EXT_EMAIL_ADDRESSES_UE
• set Threading Action Type = Object Action
• Select Threading Database Item - It will be the unique value of the Main table that will be used to join or get the values.
•   Example : Extract Assignment ID
10. Create a Record
• Give a Record Name.
• Give a Tag name - This value will be a XML tag (Parent Tag) value under which the attribute values will be coming.
• Select Type as Detail Record.
• Process Type as Fast Formula .
11. Create Attributes - Individual data elements. 
• Give a Name Value
• Give a XML tag value. 
• Short code 
• Output label value -- All these four values can be same. 
• Select type as DBI group. 
• Select the value 
•   Example :  Extract Assignment ID , Person Number , Person Name , etc. 
• Set KEy attribute for primary unique value. 
• Save. 
12. We can add the conditions at DG level to filter the data. 
13. Create Data group relationship under Data Groups.
•   Select the child DG.
•   select create option under connect DG.
•   Select the parent DG.
•   Select the Parent DBI Item  - Parent joining value.
•     Example - Extract Assignment Person ID
•   Select chile DBI - Child Joining element value
•     Example - Extract E-Mail Person ID
• We can add the filter at the group level or attribute level. 
14. Go to extract delivery
• Select add
• Provide a name for delivery option.
• Select an output type 
•   Ex : Text for a CSV and we need to attach a template. 
•    Data for XML out put and we dont need to attach a template. 
• Give an output file name. 
• Select delivery type as None.
• Save the changes. 
15. Go to extract execution tree Compile all formulas.
• Refreh and make sure all formulas are compiled. 
16. Submit Extract to run the extract.