PeopleSoft Wiki

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 ocassionally want to query the information in the message log. To do this there two tables that you need to use:

• PS_MESSAGE_LOG
• PS_MESSAGE_LOGPARM

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'

Writing to the message log

You write to the message log with an Application Engine by simply using the log message action or by using the MessageBox function in PeopleCode.