Sunday, 9 May 2021
Top 50 Fusion HCM Technical Questions - Part 2
Sunday, 2 May 2021
Changes Only Mode in HCM Extracts
Changes Only Mode in HCM Extracts
You can create HCM Extract to extract the results. In HCM extract there are several modes, you can use these modes to extract the data which got changed since earlier extract run which we call it as Baseline.
To Enable these modes you have to enable Changes_Only parameter while you are defining HCM Extract.
At the time of running the Extract you can use Changes Only parameter to fetch the filtered data as per the parameter.
Below are the different parameters in changes only mode :
- All Attribute
- Changed Attributes
- Changed and Marked Attributes
- Changed and Marked Attributes with previous value
- Changed, Marked Attributes under threading group
- Changed, Marked Attributes, previous data under threading group
Name |
PersonData_Change |
Start Date |
Date as you wish |
Type |
Full Profile |
Changes Only |
Enable this option |
Name |
Person_Details |
Tag Name |
Person_Details |
User Entity |
PER_EXT_SEC_PERSON_UE |
Threading Database Item |
Extract Person ID |
Threading Action Type |
Object actions |
Root Data Group |
Enable this option to make this Root Data Group |
Threading Database Item - If we are implementing Changes Only HCM Extract then its required to define threading database item. It is the Unique Id for the selected User Entity
Sequence |
10 |
Name |
Person_Details |
Tag Name |
Person_Details |
Type |
Detail Record |
Process Type |
Fast Formula |
Name |
Person_ID |
Tag Name |
Person_ID |
Shor Code |
Person_ID |
Data Type |
Number |
Type |
Database Item Group |
Database Item Group |
Extract Person ID |
Output Label |
Person_ID |
Output Column |
1 |
Key Attribute |
Enable this option |
Name |
Person_FullName |
Tag Name |
Person_FullName |
Shor Code |
Person_FullName |
Data Type |
Text |
Type |
Database Item Group |
Database Item Group |
Person Full Name |
Output Label |
Person_FullName |
Output Column |
2 |
Name |
Person_Gender |
Tag Name |
Person_Gender |
Shor Code |
Person_Gender |
Data Type |
Text |
Type |
Database Item Group |
Database Item Group |
Person Gender |
Output Label |
Person_Gender |
Output Column |
3 |
4. Person Date of Birth - Attribute
Name |
Person_DOB |
Tag Name |
Person_DOB |
Shor Code |
Person_DOB |
Data Type |
Date |
Type |
Database Item Group |
Database Item Group |
Person Date Of Birth |
Output Label |
Person_DOB |
Output Column |
4 |
Define the Delivery Option
Delivery Option Name |
Data |
Output Type |
Data |
Output Name |
Data |
Delivery Type |
None |
Navigate to Extract Execution Tree to compile all the formula and validate Extract.
Name | Person_FullName |
Tag Name | Person_FullName |
Shor Code | Person_FullName |
Data Type | Text |
Type | Database Item Group |
Database Item Group | Person Full Name |
Output Label | Person_FullName |
Output Column | 2 |
Marked as Change | Enable this option |
Name | Person_DOB |
Tag Name | Person_DOB |
Shor Code | Person_DOB |
Data Type | Date |
Type | Database Item Group |
Database Item Group | Person Date Of Birth |
Output Label | Person_DOB |
Output Column | 4 |
Marked as Change | Enable this option |
How to sort data in rtf template
How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...