AMM_PUBCONLIST

index back

Publication Contracts

This view lists Publication Contracts in the Integration Broker (Application Message) Monitor.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.SUBNODE , A.IB_SEGMENTINDEX , A.IB_SENDPUBID , A.SUBQUEUE , A.IB_OPERATIONNAME , A.VERSIONNAME , A.PUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.MACHINENAME , A.TUXDOMAIN , A.PROCESSID , A.NRID , A.TRXTYPE FROM PSAPMSGPUBCON A

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.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
IB_SENDPUBID Signed Number(11,0) DECIMAL(10) NOT NULL IB Send Publication ID
SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
PUBCONSTATUS Number(2,0) SMALLINT NOT NULL Publication Contract Status
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
TUXDOMAIN Character(30) VARCHAR2(30) NOT NULL Tuxedo Domain Name
PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19