Looking for Issue description and resolution query

Summary:

Content (please ensure you mask any confidential information):

Dears ,

I am working on a query to get issue description and resolution , I found them but I could not exact fault message for transaction.

Here is the code I am using .

If anyone can help , it is highly appreciated.

Thank You

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECTto_char(apae.per_absence_entry_id),
papf.person_id person_id,
papf.person_number person_number,
ppnf.Display_name full_name,
to_char(apae.submitted_date, 'DD-Mon-YY', 'NLS_DATE_LANGUAGE = AMERICAN') submitted_date,