We have configured delta aggregation for Oracle HCM source. The initial aggregation si done successfully via the input files. The delta aggregation scans 0 records.
Looking at the VA logs, it seems that the aggregation process fires multiple queries to get delta records. However all the queries fail with the error
“message”:“Paging logic processing ended for endpoint ‘Account Aggregation’. Data hash is different. Paging terminated: false”
The query fired is
/hcmRestApi/atomservlet/user/userRequests?published-min=2025-07-11T11:07:35.000Z&published-max=2025-07-15T16:05:07.136Z&updated-min=2025-07-11T00:00:00.000Z&updated-max=2025-07-15T23:59:59.000Z&page-size=499&page=1
I have attached the postman response for the above query. delta response.xml (2.1 KB)
Here is my experience with delta aggregation not scanning any objects.
We have faced this with Entra ID SaaS connector(not a VA connector).
Its a bug on the Entra ID SaaS connector that SP had to fix.
In your case, since you see the response by hitting the same end point via postman and with SailPoint it fails, my take on this is to reach out to SP support.
@nileshnikalje can you confirm few things
1- can you authenticate via API
2-do you have the required crdentials to get the data using api which uses atom feed
3-the attribute mapping has all the default and custom fields
