Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Learning notifications

luisfrancisco93
Explorer

on ‎2022 Nov 21 4:15 PM

0 Likes
506

Hello,

Does anyone know if it is possible to check the notifications (with report) sent by email for the users? I was able to extract some report, but the Body from that notifications seems encrypted, do we have any way to check that body information for notifications?

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
dmak
Participant
‎2022 Nov 22 7:15 PM

we had to make a copy of the email summary audit report and add a new field to the report using PRD in order to show email contents:

select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(BODY,2000,1)) BODY from pa_mail_archive

That will give us the content of registration emails sent from the system for example

Accepted Solutions (0)

Answers (0)

Ask a Question