Get Started with Redwood for Oracle Cloud HCM Begin Now
HCM Extract(Changes Only) returns record even when there is no change in data
Summary
HCM Extract(ATTRIB_OLD) returns record even when there is no change in attribute that is 'marked as change'Content
Requirement is to pull element entries only when there is salary change for the employee.
Parent DG: PER_EXT_PAY_EMPLOYEES_UE
Attributes: Person ID, Assignment ID, Salary Amount(Mark as Changed), Person Number
Child DG: ELEMENT ENTRIES RANGE
Attributes: Element Entry ID, Element Entry Value ID, Element Input Value, Adjusted value(Extract rule)
- 1st run --> All attributes --> all employees are coming in xml (Expected result)
- 2nd run --> made salary change for 1 emp(E1) --> ran for 'Changed and Marked Attributes with Previous Values' --> that 1 emp(E1) alone is appearing
Tagged:
0