FT_ERR_RPT_VW(SQL View) |
Index Back |
|---|---|
View used by Error ReportingView used by Error Reporting |
| SELECT FT_INTEGRATE_TYPE , FT_ERROR_TYPE ,PROCESS_INSTANCE , FT_OBJECT_IDENT , FT_REQUIRED_FLAG , FT_VALUE_S05 ,FT_VALUE_S06 ,FT_VALUE_S07 ,FT_VALUE_S08 ,FT_VALUE_S09 ,FT_VALUE_S10 FROM PS_FT_ERROR_LOG WHERE FT_ERROR_TYPE = 'DVM' AND PROCESS_INSTANCE = 6547 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_INTEGRATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Integration Type
I=Inbound O=Outbound |
| 2 | FT_ERROR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Error types for fusion extract
BOBJ=Entire object bypassed DMAP=Unable to load DVM map DUPN=Duplicate Content Item Name DVM=Unable to map the DVM value(s) FOBJ=Object not supported by Fusion MJOB=Employee with multiple jobs MOBJ=Missing reference object MSAL=Multiple Salary Bases NTER=Termination row updates OOBJ=Other Objects Bypassed PNOV=Position override POBJ=Object Bypassed By Parent ROBJ=Reference to object in error XMAP=Unable to load XREF map XREF=Unable to map the XREF |
| 3 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | FT_OBJECT_IDENT | Character(4) | VARCHAR2(4) NOT NULL | A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound |
| 5 | FT_REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Field
N=No Y=Yes |
| 6 | FT_VALUE_S05 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 5 |
| 7 | FT_VALUE_S06 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 6 |
| 8 | FT_VALUE_S07 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 7 |
| 9 | FT_VALUE_S08 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 8 |
| 10 | FT_VALUE_S09 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 9 |
| 11 | FT_VALUE_S10 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 10 |