RY_W_RETRY_VW

(SQL View)
Index Back

Transaction retry SQL view

Dialog Event Wire Transaction retry report SQL view

SELECT RY_EXT_ID , RY_TRXN_ID , RY_RETRY_DTTM ,log.STATUS_CODE , DESCR254 ,RY_URL FROM PS_RY_WIRE_EXTSYS ext ,PS_RY_WIRE_RETRY retry ,PS_RY_W_RETRY_LOG log ,PS_RY_WIRE_TRXN trxn WHERE ext.RY_EXT_SYS_ID=retry.RY_EXT_SYS_ID AND retry.RY_RETRY_ID=log.RY_RETRY_ID AND log.RY_TRXN_SYS_ID=trxn.RY_TRXN_SYS_ID

  • Related Language Record: RY_W_RETRY_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_EXT_ID Character(40) VARCHAR2(40) NOT NULL Field used by Online Marketing.
    2 RY_TRXN_ID Character(40) VARCHAR2(40) NOT NULL Field used by Online Marketing.
    3 RY_RETRY_DTTM DateTime(26) TIMESTAMP Field used by Online Marketing.
    4 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 RY_URL Long Character(2000) VARCHAR2(2000) Template URL - Document Element