FT_ERR_RPT_VW9(SQL View) |
Index Back |
|---|---|
Error ReportingView used with Transformation error reports |
| SELECT A.PROCESS_INSTANCE ,A.FT_INTEGRATE_TYPE ,A.FT_ERROR_TYPE , A.ft_value_s01 ,A.ft_value_s02 , a.ft_fieldname_s01 , B.XLATLONGNAME , A.ft_alternate_key FROM PS_FT_ERROR_LOG A , PSXLATITEM B WHERE a.ft_required_flag = 'Y' AND a.ft_object_ident = b.fieldvalue AND a.ft_error_type IN ('POBJ','MOBJ','BOBJ','ROBJ') AND b.fieldname = 'FT_OBJECT_IDENT' ORDER BY b.xlatlongname,A.ft_alternate_key |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | FT_INTEGRATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Integration Type
I=Inbound O=Outbound |
| 3 | 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 |
| 4 | FT_VALUE_S01 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 1 |
| 5 | FT_VALUE_S02 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 2 |
| 6 | FT_FIELDNAME_S01 | Character(18) | VARCHAR2(18) NOT NULL | Source Field Name 1 |
| 7 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 8 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |