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 Name Field Type Column Type Description
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
ERRORTIMESTAMP DateTime(26) TIMESTAMP Error Timestamp
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
PUBDATAERRLOC Character(254) VARCHAR2(254) NOT NULL Publish Data Error Location
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19