Looking at the hz_parties table at https://docs.oracle.com/en/cloud/saas/sales/22c/oedms/hzparties-7234.html#hzparties-7234 there is an email_adress field.

https://docs.oracle.com/en/cloud/saas/human-resources/22c/oedmh/perusers-18878.html#perusers-18878 select * from per_users where person_id is null Would they have a PARTY_ID? https://docs.oracle.com/en/cloud/saas/sales/22c/oedms/hzparties-7234.html#hzparties-7234 select * from hz_parties where party_id in (select party_id…

We have found a solution by selecting the View All History button at the top of an Opt-In page. https://docs.oracle.com/en/cloud/saas/applications-common/22c/oafsm/review-opt-in-history.html#s20063052

We are now looking for the same details. Were you successful in your search?