FT_ERR_VW1 (SQL View)	Index Back
Transformation Error Reports View used with Transformation Error Reports

FT_ERR_VW1

(SQL View)

Transformation Error Reports

View used with Transformation Error Reports

SELECT A.PROCESS_INSTANCE , A.FT_INTEGRATE_TYPE , A.FT_ERROR_TYPE , b.XLATLONGNAME , COUNT(*) FROM PS_FT_ERROR_LOG A , PSXLATITEM B WHERE a.ft_object_ident = b.fieldvalue AND b.fieldname = 'FT_OBJECT_IDENT' AND a.ft_required_flag = 'Y' GROUP BY A.PROCESS_INSTANCE, A.FT_INTEGRATE_TYPE, A.FT_ERROR_TYPE, b.XLATLONGNAME

# 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

5 COUNT_EE Number(12,3) DECIMAL(11,3) NOT NULL Employee Count

#	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	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
5	COUNT_EE	Number(12,3)	DECIMAL(11,3) NOT NULL	Employee Count