KK_I_EXCPTN_VW

(SQL View)
 Index Back

Comm Cntrl Exceptions Insights

Commitment Control Exceptions Source View for Insights Dashboard

SELECT DISTINCT A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.LEDGER_GROUP , A.EXCPTN_TYPE , A.BUSINESS_UNIT , A.ACCOUNT , A.DEPTID , %subrec(CF12_AN_SBR, A) , %subrec(CFCC1_AN_SBR, A) , A.STATISTICS_CODE , A.KK_SOURCE_TRAN , A.NOTIFY_WF_MSG , A.MESSAGE_NBR , A.MESSAGE_PARM1 , A.MESSAGE_PARM2 , A.MESSAGE_PARM3 , A.MESSAGE_PARM4 , B.KK_PROCESS_STATUS , B.KK_DATETIME_STAMP , C.DESCR , CASE WHEN B.KK_SOURCE_TRAN IN ('AP_ACCTDSE' , 'AP_ACCT_LN' , 'AP_ACENC' , 'AP_ACEXP' , 'AP_ACTDSEC' , 'AP_VCHR_NP' , 'AP_VOUCHER') THEN 'Voucher ID: ' %Concat B.VOUCHER_ID WHEN B.KK_SOURCE_TRAN IN ('AR_MISCPAY') THEN 'Deposit ID: ' %Concat B.DEPOSIT_ID WHEN B.KK_SOURCE_TRAN IN ('AR_REVEST') THEN 'Item ID: ' %Concat B.ITEM WHEN B.KK_SOURCE_TRAN IN ('BI_INVOICE') THEN 'Invoice: ' %Concat B.INVOICE WHEN B.KK_SOURCE_TRAN IN ('CM_TRNXTN') THEN 'Item ID: ' %Concat B.INV_ITEM_ID WHEN B.KK_SOURCE_TRAN IN ('EX_ACENC' , 'EX_ACEXP') THEN 'Report ID: ' %Concat B.EX_DOC_ID WHEN B.KK_SOURCE_TRAN IN ('EX_EXCLOSE' , 'EX_EXSHEET') THEN 'Report ID: ' %Concat B.SHEET_ID WHEN B.KK_SOURCE_TRAN IN ('EX_TRVAUTH') THEN 'Travel Auth ID: ' %Concat B.TRAVEL_AUTH_ID WHEN B.KK_SOURCE_TRAN IN ('GENERIC') THEN 'Transaction Nbr: ' %Concat B.TRANS_NBR WHEN B.KK_SOURCE_TRAN IN ('GL_BD_JRNL' , 'GL_JOURNAL') THEN 'Journal ID: ' %Concat B.JOURNAL_ID WHEN B.KK_SOURCE_TRAN IN ('GM_FA' , 'GM_FA_UPG') THEN 'Project ID: ' %Concat B.PROJECT_ID WHEN B.KK_SOURCE_TRAN IN ('HP_PAY_ENC') THEN 'Document ID: ' %Concat %NumToChar(B.HP_KK_DOC_ID) WHEN B.KK_SOURCE_TRAN IN ('HYP_CHECK' , 'HYP_POST') THEN 'Transaction Nbr: ' %Concat B.HYP_TRAN_ID WHEN B.KK_SOURCE_TRAN IN ('PC_BUDGET' , 'PC_JOURNAL') THEN 'Project ID: ' %Concat B.PROJECT_ID WHEN B.KK_SOURCE_TRAN IN ('PO_POENC' , 'PO_POENCNP') THEN 'Purchase Order: ' %Concat B.PO_ID WHEN B.KK_SOURCE_TRAN IN ('PO_CCBATCH' , 'PO_PROCARD') THEN 'Employee ID: ' %Concat B.EMPLID WHEN B.KK_SOURCE_TRAN IN ('PO_RAENC' , 'PO_RAEXP') THEN 'Receiver ID: ' %Concat B.RECEIVER_ID WHEN B.KK_SOURCE_TRAN IN ('REQ_PRECNP' , 'REQ_PREENC') THEN 'Requisition ID: ' %Concat B.REQ_ID ELSE ' ' END , CASE WHEN B.KK_SOURCE_TRAN IN ('AP_ACCTDSE' , 'AP_ACCT_LN' , 'AP_ACENC' , 'AP_ACEXP' , 'AP_ACTDSEC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_AP2.GBL?Page=KK_XCP_HDR_AP2&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('AP_VCHR_NP') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_AP1N.GBL?Page=KK_XCP_HDR_AP1N&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('AP_VOUCHER') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_AP1.GBL?Page=KK_XCP_HDR_AP1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('AR_MISCPAY') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_AR2.GBL?Page=KK_XCP_HDR_AR2&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('AR_REVEST') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_AR1.GBL?Page=KK_XCP_HDR_AR1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('BI_INVOICE') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_BI1.GBL?Page=KK_XCP_HDR_BI1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('CM_TRNXTN') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_CM1.GBL?Page=KK_XCP_HDR_CM1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('EX_EXSHEET') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_EX2.GBL?Page=KK_XCP_HDR_EX2&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('EX_TRVAUTH') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_EX1.GBL?Page=KK_XCP_HDR_EX1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('GENERIC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_GEN.GBL?Page=KK_XCP_HDR_GEN&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('GL_BD_JRNL') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_GL2.GBL?Page=KK_XCP_HDR_GL2&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('GL_JOURNAL') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_GL1.GBL?Page=KK_XCP_HDR_GL1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('GM_FA' ,'GM_FA_UPG') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_GM1.GBL?Page=KK_XCP_HDR_GM1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('HP_PAY_ENC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_HR3.GBL?Page=KK_XCP_HDR_HR3&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('HP_PAY_EXP' ,'HR_PAYROLL') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_HR1.GBL?Page=KK_XCP_HDR_HR1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('HYP_CHECK' ,'HYP_POST') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_HYP.GBL?Page=KK_XCP_HDR_HYP&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('PC_BUDGET') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PC5.GBL?Page=KK_XCP_HDR_PC5&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) %Concat '&JOURNAL_ID='%Concat B.JOURNAL_ID %Concat '&BUSINESS_UNIT_PC=' %Concat B.BUSINESS_UNIT_PC %Concat '&PROJECT_ID='%Concat B.PROJECT_ID %Concat '&ACTIVITY_ID=' %Concat B.ACTIVITY_ID WHEN B.KK_SOURCE_TRAN IN ('PC_JOURNAL') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PC1.GBL?Page=KK_XCP_HDR_PC1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) %Concat '&JOURNAL_ID='%Concat B.JOURNAL_ID %Concat '&BUSINESS_UNIT_PC=' %Concat B.BUSINESS_UNIT_PC %Concat '&PROJECT_ID='%Concat B.PROJECT_ID %Concat '&ACTIVITY_ID=' %Concat B.ACTIVITY_ID WHEN B.KK_SOURCE_TRAN IN ('PO_POENC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO1.GBL?Page=KK_XCP_HDR_PO1&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('PO_POENCNP') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO1N.GBL?Page=KK_XCP_HDR_PO1N&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('PO_PROCARD') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO3.GBL?Page=KK_XCP_HDR_PO3&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('PO_RAENC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO5.GBL?Page=KK_XCP_HDR_PO5&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('PO_RAENC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO4.GBL?Page=KK_XCP_HDR_PO4&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('REQ_PRECNP') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO2N.GBL?Page=KK_XCP_HDR_PO2N&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) WHEN B.KK_SOURCE_TRAN IN ('REQ_PREENC') THEN 'MANAGE_COMMITMENT_CONTROL.KK_XCP_PO2.GBL?Page=KK_XCP_HDR_PO2&Action=U&KK_TRAN_ID='%Concat A.KK_TRAN_ID %Concat '&KK_TRAN_DT=' %Concat CAST(A.KK_TRAN_DT AS VARCHAR(12)) ELSE ' ' END FROM PS_KK_EXCPTN_TBL A , PS_KK_SOURCE_HDR B , PS_KK_SOURCE_TRAN C WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND B.KK_SOURCE_TRAN = C.KK_SOURCE_TRAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
2 KK_TRAN_DT Date(10) DATE NOT NULL Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 EXCPTN_TYPE Character(3) VARCHAR2(3) NOT NULL Exception Type
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
10 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
11 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
12 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
13 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
15 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
16 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
17 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
18 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
19 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
20 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
21 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
23 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
24 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
25 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
26 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
27 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
28 NOTIFY_WF_MSG Character(1) VARCHAR2(1) NOT NULL User WF Notification Message
29 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
30 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
31 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
32 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
33 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
34 KK_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
35 KK_DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
36 DESCR Character(30) VARCHAR2(30) NOT NULL Description
37 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
38 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)