# Oracle HCM Cloud Connector Aggregation issue

**URL:** <https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud, aggregation\
**Created:** [December 10, 2024, 5:00pm UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967 "2024-12-10T17:00:45Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashish\_kumar3284](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@ashish\_kumar3284](https://developer.sailpoint.com/discuss/u/ashish_kumar3284)\
**Post date:** [December 10, 2024, 5:00pm UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/1 "2024-12-10T17:00:45Z")

</div>

Hello Experts,

We are using Oracle HCM Cloud connector as the Source of Truth in our implementation. We were to set up the required files in the SFTP location. Test connection and aggregation are working however, no accounts are being aggregated. There are no errors while aggregation, it shows success with 0 accounts.

All three files contain the data. Checked the documentation thoroughly and everything looks good. Enabled the logs as well, didn’t see anything unusual.

Any pointers would be helpful.

---

<div class="post-metadata">

**Author:** ![suraj\_gorle](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/suraj_gorle/32/35158_2.png) [@suraj\_gorle](https://developer.sailpoint.com/discuss/u/suraj_gorle)\
**Post date:** [December 11, 2024, 4:18am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/2 "2024-12-11T04:18:01Z")

</div>

Hi @ashish_kumar3284  
Greetings for the day!

Have you check on below resolution mentioned in the screenshot

 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/4/d/4da59f4768a5a3db5755c582b81ee61008a82d07.png)

Thank you.

---

<div class="post-metadata">

**Author:** ![ashish\_kumar3284](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@ashish\_kumar3284](https://developer.sailpoint.com/discuss/u/ashish_kumar3284)\
**Post date:** [December 11, 2024, 8:23am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/3 "2024-12-11T08:23:26Z")

</div>

@suraj_gorle

Thank you Suraj for redirecting me. The troubleshooting guide says we can see the error in the ccg.log. Unfortunately, I didn’t see any error in the log file.

Still, I will cross-check with the application for the same. Will keep posting the updates.

---

<div class="post-metadata">

**Author:** ![suraj\_gorle](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/suraj_gorle/32/35158_2.png) [@suraj\_gorle](https://developer.sailpoint.com/discuss/u/suraj_gorle)\
**Post date:** [December 11, 2024, 8:57am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/4 "2024-12-11T08:57:04Z")

</div>

Hi @ashish_kumar3284

Can you please add the appropriate loggers in log4j2.properties file in VA so that there might be chances that it will show logs in ccg.log file.

> **[CCG Enable Debug Log by Connector](https://community.sailpoint.com/t5/Connector-Directory/CCG-Enable-Debug-Log-by-Connector/ta-p/169807)**
>
> IMPORTANT:  The method of configuring logging levels per connector that is described in this document has been been updated. Logging functionality is now configurable by API. For more information, refer to the Enabling Connector Logging in...

Thank you.

---

<div class="post-metadata">

**Author:** ![ashish\_kumar3284](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@ashish\_kumar3284](https://developer.sailpoint.com/discuss/u/ashish_kumar3284)\
**Post date:** [December 11, 2024, 9:57am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/5 "2024-12-11T09:57:22Z")

</div>

Hi @suraj_gorle,

Thank you again for sharing the link. However, while troubleshooting, and found no leads from the connector-specific loggers, landed up here to get expert advice/suggestions.

---

<div class="post-metadata">

**Author:** ![ashish\_kumar3284](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@ashish\_kumar3284](https://developer.sailpoint.com/discuss/u/ashish_kumar3284)\
**Post date:** [December 12, 2024, 6:11pm UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/6 "2024-12-12T18:11:34Z")

</div>

Hello Experts,

We were able to aggregate the users successfully after investigating the WORKER\_TYPE value format.

Thanks

---

<div class="post-metadata">

**Author:** ![Louise22](https://avatars.discourse-cdn.com/v4/letter/l/53a042/32.png) [@Louise22](https://developer.sailpoint.com/discuss/u/Louise22)\
**Post date:** [January 14, 2025, 6:57am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/7 "2025-01-14T06:57:46Z")

</div>

Hi Ashish,

Are you able to give more details on how to resolved this issue? We are having the same issue, and from what I can tell the WORKER\_TYPE has the correct values, ie E, P, C, N.

However the error coming through is:

_“Discarding invalid worker type : "E" for PersonNumber : "123456". Ensure that the workerType value is according to expected standard”_

Where you experiencing the same thing? What did you end up changing?

Thanks helps for any extra info 🙂

---

<div class="post-metadata">

**Author:** ![ashish\_kumar3284](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@ashish\_kumar3284](https://developer.sailpoint.com/discuss/u/ashish_kumar3284)\
**Post date:** [January 14, 2025, 7:29am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/8 "2025-01-14T07:29:03Z")

</div>

@Louise22

Could you please share your csv file entry for more understanding?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 15, 2025, 7:29am UTC](https://developer.sailpoint.com/discuss/t/oracle-hcm-cloud-connector-aggregation-issue/92967/9 "2025-03-15T07:29:59Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
