You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to get the only Error message from FAULT_PAYLOAD column

edited Sep 6, 2021 4:36AM in Reporting and Analytics for HCM 5 comments

Summary

How to get the only Error message from FAULT_PAYLOAD column

Content

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

21C
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!