Error in "Workday Accounts" Aggregation

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

Hello Everyone

We were performing an integration using “Workday Accounts” connector, But when the aggregation is performed, It is returning an error as shown in the image below. Could you please provide some insight on how to solve this issue. Thank you in Advance.

WD error
WD error748×298 9.83 KB

Poojitha

2

Check the schema attributes in Sailpoint that should match with your workday application.

1 Like
3

The error is due to the invalid or non-existent field name terminatedBasedOnReportDate being used in the Workday custom report or identity attribute mapping in the SailPoint Workday connector configuration.

Resolution Steps :

  1. Check the Workday Custom Report (RaaS):
    Log in to Workday as an admin.
    Go to the Custom Report used for SailPoint integration.
    Verify whether the field terminatedBasedOnReportDate:
    Exists in the report
    Is spelled correctly (case sensitive)
    Is exposed as a web service field (RaaS field must be marked as “Web Service Field”)

  2. Check the SailPoint Workday Source Configuration:
    Navigate to Identity Security Cloud → Admin → Connections → Sources
    Open your Workday Accounts source.
    Check the Identity Profile Mappings or Account Schema
    Look for the field terminatedBasedOnReportDate and:
    Confirm if it’s mapped to a valid field from Workday
    Remove or correct it if it doesn’t exist in the Workday report

  3. Test the Report URL Separately :
    Use Postman or a browser to open the Workday RaaS URL .
    Confirm whether terminatedBasedOnReportDate is returned in the response.
    If not, the field is either not included or not web service enabled.

  4. Review Aggregation Logs in SailPoint :
    Go to Monitor → IdentityNow Tasks
    Review the logs for the aggregation task of the Workday connector.
    Look for the full WQL (Workday Query Language) SELECT clause and identify any other invalid fields.

Suggested Fix:

If terminatedBasedOnReportDate is not needed → Remove the field from the attribute mapping or schema in ISC.
If it’s needed → Make sure it exists in the Workday report and is marked as Web Service Field .

4

Hi @M_POOJITHA

To diagnose, can you toggle the “Aggregate Terminated Account” and check your “Termination Offset” to ensure it only includes the number of days of terminated accounts you require.

@narayanag - thank you for your contribution, but it reads very much like an AI generated response which has completely missed the question. Posting AI generated content goes against the purpose of this community. Obviously, apologies if it was not AI generated.

5

Thank you everyone for responding on what might be the issue here. We passed this error now after making some changes and were facing a new error as below

image
image737×292 10.6 KB

Any idea on what might be causing this issue

Thank you
Poojitha

6

Hi @M_POOJITHA Could you please post what you did to fix your initial issue? it will help future users of the community.

1 Like
7

Hi @Jeremy Place, It was a visibility issue. The workday team has added those attributes for our integration user.

1 Like
8

Any idea on the error belo

image
image737×292 10.6 KB

9

Hi - what are you doing when the error occurs? Also, are you SaaS or VA based connector?

10

This is a VA based connector

11

Sounds like it’s having a problem with a source parameter. If you haven’t done it yet, try a new source from scratch.

12

I configured a new source using “Workday Accounts SAAS” connector and that seems working

Thank you
Poojitha

1 Like
13

@madala poojitha, mark it as solution.

14

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