Reject reason codes/comments

We are wanting to send the reason code and comments back to the requester on rejection. We have multiple levels of approval, so how can you send that information regardless of which level it occurred?

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

clin

Comments are stored in S$PFIMT and S$PFIME

Using query (Two ways)

SELECT

*

from IPA.PFIMETRICS PFIMT

left join IPA.S$PFIMT S$PFIMT on (PFIMT.UNIQUEID = S$PFIMT.UNIQUEID)

where PFIMT.PFIWORKUNIT='<WorkUnit Number>'

--another way

SELECT *

FROM [LMKDB].[IPA].[PFIMESSAGE] PFM

INNER JOIN [LMKDB].IPA.S$PFIME S$ on PFM.UNIQUEID = S$.UNIQUEID

where PFIWORKUNIT = '<WorkUnit Number>'

Using Landmark Transaction

_dataArea="lpa_dataarea" & _module="pfi" & _objectName="PfiMetrics" & _actionName="Find" & _actionOperator="NONE" & _actionType="MultipleRecordQuery" & _runAsUser="" & _authenticatedUser="" & _pageSize="30" & _relationName="" & _setName="" & _asOfDate="" & _effectiveDate="" & PfiWorkunit="<WorkUnit Number>" & Message

Replace <WorkUnit Number> with the workunit number in both query and landmark transaction node

All comments

unknown

If a comment was entered, it should be in the pfimessage table.

unknown

Hello,

For my design; I used the " Landmark Transaction" node to extract the message(s) for a workunit from "PfiMessage"

This is what I coded in my node:

_dataArea="<!ProdLine>" & _module="pfi" & _objectName="PfiMessage" & _actionName="Find" & _actionOperator="NONE" & _actionType="MultipleRecordQuery" & _runAsUser="" & _authenticatedUser="" & _pageSize="30" & _relationName="" & _setName="" & _asOfDate="" & _effectiveDate="" & PfiWorkunit="<!oWorkUnit>" & PfiMessage & Message & AttachByName & AttachBy

Hope this help.

TV

nathan-taylor

It looks like our pfimessage tables are empty. Is there another table that stores this data? We are on 10.1.1.62 in Production and 10.1.1.70 in Test.

russel-cornelson

Are you using a Landmark Transaction or are you using a database utility?

0712131256598360.doc

nathan-taylor

The Landmark Transaction is not finding any data. When I query PFIMessage in Spreadsheet Designer, it doesn't pull any data either. I can see the Reason code and Comment in the User Action Routing in the rich client.

0905290750040159.pdf

Copyright © 2025 Infor. All rights reserved.