How to get the only Error message from FAULT_PAYLOAD column
Summary
How to get the only Error message from FAULT_PAYLOAD columnContent
Hi Experts,
Good Day!!
We are trying to pull the failed transaction details from transaction console.
For that we are using the table fusion.fnd_console_issue to get the error message of the failed transactions which is saving in the column FAULT_PAYLOAD of CLOB data type.
Could any one please let me know how to get the only error message from the FAULT_PAYLOAD column.
Regards,
Charan Teja.K
Version
21C0