AMM_PUBERR

index back

App Msg Monitor Pub Err View

This view is used to list Publication errors in the Application Message Monitor
SELECT PUBNODE , CHNLNAME , PUBID , ERRORTIMESTAMP , SEQNO , MESSAGE_SET_NBR , MESSAGE_NBR , PUBDATAERRLOC FROM PSAPMSGPUBERR

PeopleSoft Field NameField TypeColumn TypeDescription
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
CHNLNAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSCHNLDEFN).
PUBIDSigned Number(11,0)DECIMAL(10) NOT NULLPublication Identifier
ERRORTIMESTAMPDateTime(26)TIMESTAMPError Timestamp
SEQNONumber(5,0)INTEGER NOT NULLSequence Number
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
PUBDATAERRLOCCharacter(254)VARCHAR2(254) NOT NULLPublish Data Error Location
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19