The message log is used by a number of processes to provide debugging and troubleshooting information. You can view the message log from the process monitor after clicking on the details hyperlink for a process and the by clicking on the message log hyperlink in the actions area.
You may occasionally want to query the information in the message log. To do this there two tables that you need to use:
You can use the following query to get the message log data for a given process instance:
select ML.DTTM_STAMP_SEC, ML.JOBID, ML.PROGRAM_NAME, ML.MESSAGE_SET_NBR, ML.MESSAGE_NBR, MLP.PARM_SEQ, MLP.MESSAGE_PARM from PS_MESSAGE_LOG ML inner join PS_MESSAGE_LOGPARM MLP on ML.PROCESS_INSTANCE = MLP.PROCESS_INSTANCE and ML.MESSAGE_SEQ = MLP.MESSAGE_SEQ where ML.PROCESS_INSTANCE = 'PROCESS_INSTANCE'
You can write to the message log with an Application Engine by simply using the log message action or by using the
MessageBox function in PeopleCode.