Posts

Showing posts with the label PeopleSoft Financial

PeopleSoft Web Portal Cumulative Features Overview (CFO) tool

CFO tool https://apexapps.oracle.com/pls/apex/f?p=10319:18:0
Post a Comment
Read more

Getting the Message Log Data for a Specific Process

Below SQL will give the details in a Message Log entry for a specific process or list of processes ran between the days. PS_MESSAGE_LOG -- Stores the Log Header Data for Specific Process Instance ID PS_MESSAGE_LOGPARM  -- Stores all the Details Data for a specific Process Instance Id. Below SQL will help you to write your own SQLs to get the Log Data for a specific process. Use NVL in the Sub Selects to avoid error in the SQL if there are no rows returning from the Sub Select. SELECT DISTINCT MLOG.PROCESS_INSTANCE , MLOG.MESSAGE_SEQ ,(SELECT LPRM1.MESSAGE_PARM FROM PS_MESSAGE_LOGPARM LPRM1 WHERE LPRM1.PROCESS_INSTANCE = LPRM.PROCESS_INSTANCE AND LPRM1.MESSAGE_SEQ = LPRM.MESSAGE_SEQ AND LPRM1.PARM_SEQ = '1') AS SETID ,(SELECT LPRM1.MESSAGE_PARM FROM PS_MESSAGE_LOGPARM LPRM1 WHERE LPRM1.PROCESS_INSTANCE = LPRM.PROCESS_INSTANCE AND LPRM1.MESSAGE_SEQ = LPRM.MESSAGE_SEQ AND LPRM1.PARM_SEQ = '2') AS VENDOR_ID ,(SELECT LPRM1.MESSAGE_PARM FROM PS_MESSAGE_LOGPARM...
Post a Comment
Read more

PeopleBooks

http://docs.oracle.com/cd/E17566_01/epm91pbr0/eng/psbooks/psft_homepage.htm
Post a Comment
Read more