Unable to retrieve Reassign and Reopen data from the SAAS Journey per_allocated_checklists_vl table

Dear Team,

We have received a requirement from our client to fetch Reassign and Reopen data from the Journey module for reporting purposes. However, we are currently unable to retrieve this data from the per_allocated_checklists_vl table.

As this is a high-priority requirement, we are reaching out to the Oracle team for assistance. Kindly help us with the required data at the earliest.

The following is the custom BI Report query where we are not getting reasssign and reopen task details, any experts can help us or guide usto fetch the data.

with function lookup

(

p_status in varchar2