How to prioritize "Active" account record over "Inactive" when multiple records exist for one Person Number in ORACLE HCM CLOUD

Identity Security Cloud (ISC) ISC Discussion and Questions
,
2

Hey @Tulasi ,

I would suggest to go with ISC filterstring pull in all active accounts from Oracle HCM

(active=true) at source level IdentityNow Account Filtering during Account Aggregation - Compass

Or try with below transform at IP, which filters accounts with hire date and

  "type": "accountAttribute",
  "name": "Identity Attribute Transform",
  "attributes": {
    "attributeName": "abc",
    "sourceName": "xyz",
    "accountPropertyFilter": "(WORKER_STATUS == \"active\")",
    "accountSortAttribute": "hireDate",
    "accountSortDescending": true,
    "accountReturnFirstLink": true
  }
}

and then checks active status as per krishna s suggestion IDN Multiple Authoritative Source in Single Identity

Thanks in advance
Avinash Mulpuru