PROD_LD_ERR_VW

(SQL View)
 Index Back

Products Load Error

This table captures all errors encountered during the loading of Products. The key structure for this record corresponds to the level 4 of the message definition PRODUCT_SYNC.

SELECT ERR.EIP_PROGRAM , ERR.EIP_CTL_ID , ERR.RECNAME , ERR.FIELDNAME , ERR.MESSAGE_SET_NBR , ERR.MESSAGE_NBR , ERR.LASTUPDDTTM , ERR.EDITVALUE , ERR.EDITTABLE , ERR.DESCR254 FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR WHERE EO.EIP_DTA_STATUS = '1' AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID

  • Related Language Record: PROD_LD_ERR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    7 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.
    8 EDITVALUE Character(20) VARCHAR2(20) NOT NULL Edit Value
    9 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254