FT_ERR_CNT_VW

(SQL View)
 Index Back

Fusion extract error count

Fusion extract error count

SELECT FT_INTEGRATE_TYPE , FT_RUN_ID , RUN_CNTL_ID , PROCESS_INSTANCE , FT_ERROR_TYPE , EOTF_MAP_NAME , FT_OBJECT_IDENT , FT_VALUE_S01 , FT_VALUE_S02 , FT_VALUE_S03 , FT_VALUE_S04 , FT_VALUE_S05 , FT_VALUE_S06 , FT_VALUE_S07 , FT_VALUE_S08 , FT_VALUE_S09 , FT_VALUE_S10 , FT_VALUE_S11 , FT_VALUE_S12 , FT_VALUE_S13 , FT_VALUE_S14 , FT_VALUE_S15 , FT_FLDCNT_SOURCE , FT_ALTERNATE_REC , FT_REQUIRED_FLAG , COUNT(*) FROM PS_FT_ERROR_LOG GROUP BY FT_INTEGRATE_TYPE , FT_RUN_ID , RUN_CNTL_ID , PROCESS_INSTANCE , FT_ERROR_TYPE , EOTF_MAP_NAME , FT_OBJECT_IDENT , FT_VALUE_S01 , FT_VALUE_S02 , FT_VALUE_S03 , FT_VALUE_S04 , FT_VALUE_S05 , FT_VALUE_S06 , FT_VALUE_S07 , FT_VALUE_S08 , FT_VALUE_S09 , FT_VALUE_S10 , FT_VALUE_S11 , FT_VALUE_S12 , FT_VALUE_S13 , FT_VALUE_S14 , FT_VALUE_S15 , FT_FLDCNT_SOURCE , FT_ALTERNATE_REC , FT_REQUIRED_FLAG

# 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_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 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
6 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name
7 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
8 FT_VALUE_S01 Character(254) VARCHAR2(254) NOT NULL Source Value 1
9 FT_VALUE_S02 Character(254) VARCHAR2(254) NOT NULL Source Value 2
10 FT_VALUE_S03 Character(254) VARCHAR2(254) NOT NULL Source Value 3
11 FT_VALUE_S04 Character(254) VARCHAR2(254) NOT NULL Source Value 4
12 FT_VALUE_S05 Character(254) VARCHAR2(254) NOT NULL Source Value 5
13 FT_VALUE_S06 Character(254) VARCHAR2(254) NOT NULL Source Value 6
14 FT_VALUE_S07 Character(128) VARCHAR2(128) NOT NULL Source Value 7
15 FT_VALUE_S08 Character(128) VARCHAR2(128) NOT NULL Source Value 8
16 FT_VALUE_S09 Character(128) VARCHAR2(128) NOT NULL Source Value 9
17 FT_VALUE_S10 Character(128) VARCHAR2(128) NOT NULL Source Value 10
18 FT_VALUE_S11 Character(128) VARCHAR2(128) NOT NULL Source Value 11
19 FT_VALUE_S12 Character(64) VARCHAR2(64) NOT NULL Source Value 12
20 FT_VALUE_S13 Character(64) VARCHAR2(64) NOT NULL Source Value 13
21 FT_VALUE_S14 Character(64) VARCHAR2(64) NOT NULL Source Value 14
22 FT_VALUE_S15 Character(64) VARCHAR2(64) NOT NULL Source Value 15
23 FT_FLDCNT_SOURCE Number(3,0) SMALLINT NOT NULL Source Field Count
24 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
25 FT_REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Field
N=No
Y=Yes
26 FT_ERROR_COUNT Number(10,0) DECIMAL(10) NOT NULL Error Count