FPY_ERR_DTRP_VW(SQL View) |
Index Back |
|---|---|
Error Detail Report ViewError Detail Report View |
| SELECT A.FPY_BO_TYPE ,A.FPY_BUS_OBJ , A.FPY_ERROR_CODE ,B.XLATLONGNAME , A.FPY_ERROR_TYPE , C.FPY_IDENT_FORMAT , A.FPY_IDENTIFIER , C.FPY_PSIDENT_FORMAT , A.FPY_PS_IDENTIFIER , A.FPY_MAP_NAME , A.FPY_DESCR ,' ' , ' ' , ' ' ,A.RUN_DTTM ,A.PROCESS_INSTANCE FROM PS_FPY_ERROR_LOG A ,PSXLATITEM B , PS_FPY_IDENTFOR_VW C WHERE ( A.FPY_BUS_OBJ = C.FPY_BUS_OBJ AND A.FPY_ERROR_CODE<>'CIER' AND A.FPY_ERROR_CODE<>'INVD' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'FPY_ERROR_CODE' AND B.FIELDVALUE = A.FPY_ERROR_CODE) UNION ALL SELECT D.FPY_BO_TYPE ,(CASE D.FPY_BUS_OBJ WHEN 'JCI' THEN 'JOB' WHEN 'PCI' THEN 'PER' WHEN 'SCI' THEN 'POS' WHEN 'OCI' THEN 'JCD' WHEN 'DCI' THEN 'DEP' WHEN 'LCI' THEN 'LOC' WHEN 'CCI' THEN 'CMP' ELSE D.FPY_BUS_OBJ END) , D.FPY_ERROR_CODE , E.XLATLONGNAME , D.FPY_ERROR_TYPE , F.FPY_IDENT_FORMAT , D.FPY_IDENTIFIER , F.FPY_PSIDENT_FORMAT , D.FPY_PS_IDENTIFIER , D.FPY_MAP_NAME , D.FPY_DESCR , ' ' , ' ' , ' ' ,D.RUN_DTTM ,D.PROCESS_INSTANCE FROM PS_FPY_ERROR_CI D ,PSXLATITEM E , PS_FPY_IDENTFOR_VW F WHERE ( D.FPY_BUS_OBJ = F.FPY_BUS_OBJ AND D.FPY_ERROR_CODE='CIER' AND E.EFFDT = ( SELECT MAX(E_ED.EFFDT) FROM PSXLATITEM E_ED WHERE E.FIELDNAME = E_ED.FIELDNAME AND E.FIELDVALUE = E_ED.FIELDVALUE AND E_ED.EFFDT <= %CurrentDateIn) AND E.FIELDNAME = 'FPY_ERROR_CODE' AND E.FIELDVALUE = D.FPY_ERROR_CODE) UNION ALL SELECT A.FPY_BO_TYPE ,A.FPY_BUS_OBJ , A.FPY_ERROR_CODE ,B.XLATLONGNAME , A.FPY_ERROR_TYPE , C.FPY_IDENT_FORMAT , A.FPY_IDENTIFIER , C.FPY_PSIDENT_FORMAT , A.FPY_PS_IDENTIFIER , A.FPY_MAP_NAME , A.FPY_DESCR ,' ' , ' ' , ' ' ,A.RUN_DTTM ,A.PROCESS_INSTANCE FROM PS_FPY_ERROR_LOG A ,PSXLATITEM B , PS_FPY_IDENTFOR_VW C WHERE ( C.FPY_BUS_OBJ =(CASE A.FPY_BUS_OBJ WHEN 'JCI' THEN 'JOB' WHEN 'PCI' THEN 'PER' WHEN 'SCI' THEN 'POS' WHEN 'OCI' THEN 'JCD' WHEN 'DCI' THEN 'DEP' WHEN 'LCI' THEN 'LOC' WHEN 'CCI' THEN 'CMP' ELSE A.FPY_BUS_OBJ END) AND A.FPY_ERROR_CODE='INVD' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'FPY_ERROR_CODE' AND B.FIELDVALUE = A.FPY_ERROR_CODE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FPY_BO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Business Object Type
A=All B=Bonus C=Company D=Department E=Absence J=Job Data L=Location O=Job Code P=Person Details S=Position Data U=Business Unit |
| 2 | FPY_BUS_OBJ | Character(3) | VARCHAR2(3) NOT NULL |
Business Object
ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position |
| 3 | FPY_ERROR_CODE | Character(4) | VARCHAR2(4) NOT NULL |
FPY Error Code
CIER=CI Errors COBJ=Child Object Bypassed DVME=DVM Errors EOBJ=Entire Object Bypassed FABS=Future Dated Absence Entry FUSE=Fusion Errors INVD=Unexpected Exception MOBJ=Missing Objects Bypassed PNAE=PNA Error POBJ=Parent Objects Bypassed ROBJ=Referenced Object Bypassed |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 5 | FPY_ERROR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
FPY Error Type
D=Dependent Errors E=Errors Requiring Action W=Warning |
| 6 | FPY_IDENT_FORMAT | Character(80) | VARCHAR2(80) NOT NULL | Fusion Identifier Format |
| 7 | FPY_IDENTIFIER | Character(254) | VARCHAR2(254) NOT NULL | Fusion Identifier |
| 8 | FPY_PSIDENT_FORMAT | Character(80) | VARCHAR2(80) NOT NULL | Peoplesoft Identifier Format |
| 9 | FPY_PS_IDENTIFIER | Character(120) | VARCHAR2(120) NOT NULL | Peoplesoft Identifier |
| 10 | FPY_MAP_NAME | Character(150) | VARCHAR2(150) NOT NULL | FPY_MAP_NAME |
| 11 | FPY_DESCR | Long Character | CLOB | Description |
| 12 | FPY_ERR_ACT_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Action required
E=Errors Requiring Action X=No Action reqd |
| 13 | FPY_DEP_ERROR | Character(1) | VARCHAR2(1) NOT NULL |
Dependent Error
D=Dependent Errors X=No |
| 14 | FPY_WARNING | Character(1) | VARCHAR2(1) NOT NULL |
Warning
W=Warnings X=no |
| 15 | FPY_EXECDTTM | DateTime(26) | TIMESTAMP | Last Run Datetime |
| 16 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |