Initiated Onboarding Journey Numbers for 2023 Decreasing

MarkS

I downloaded an onboarding template that calculates the number of Initiated task's and incompletes vs. completes for 2023 and 2024. For some reason the initiated task numbers have started to decrease which is unexpected since we are no longer in 2023. I would have thought this number would stay static as task's that were initiated in 2023 should be be initiated in 2024. The latest delay we have on a task is 120 days. Below is the filter and columns I am outputting. We went live in 2023, so there is no filter on Date.

Incomplete formula: FILTER("Checklist Task"."Count" USING ("Allocated Checklist"."Status Code" <> 'COM'))

Complete formula: FILTER("Checklist Task"."Count" USING ("Allocated Checklist"."Status Code" = 'COM'))

Creation Date: YEAR("Allocated Checklist"."Creation Date")initiated: "Checklist Task"."Count"

gclampitt

Have you got the schedule process "Archive and Purge Journey Data" running?

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faijh/examples-of-assigned-journeys-archive-and-purge.html#Example-1

MarkS

@gclampitt Yes, we have it running daily.

gclampitt

thats the reason then…its purging the data?

MarkS

@gclampitt Do you know the time frame of when they get purged? For instance, if I complete a task today, when does the system purge the data?

Is there a way to get an accurate count of task's completed vs. incomplete year over year with this process running? I don't want to stop the job and clog the system.

gclampitt

Mark that URL to the documentation should help as it has examples of when stuff is purged…
We've got the purge job running, but we dont have the requirement to look at old tasks, so i've not looked into this in great detail.
Maybe someone else can help on here..