EAP - Abend at Step DCAP24941462.MAIN.STEP02 (SQL) (Doc ID 2239004.1)

Last updated on APRIL 06, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When applying FSCM 9.2 updates from PUM 22, App Enging DCAP24941462 runs and the following error occurs.

ERROR
-----------------------
PeopleTools 8.54.19 - Application Engine
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85419b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL
Failed SQL stmt: UPDATE PS_VCHR_LINE_WTHD SET PS_VCHR_LINE_WTHD.WTHD_RULE = ( SELECT (CASE WHEN VNDR.WTHD_RULE = ' ' THEN CAT.WTHD_RULE ELSE VNDR.WTHD_RULE END) FROM PS_VOUCHER VCH , PS_WTHD_ENTITY_HDR HDR , PS_WTHD_ENTITY_DTL DTL , PS_WTHD_CATEGORY CAT , PS_VENDOR_WTHD_JUR VNDR , PS_WTHD_BU_JUR BU , PS_VENDOR_LOC LOC , PS_WTHD_BU_HDR BUHDR WHERE VCH.BUSINESS_UNIT =PS_VCHR_LINE_WTHD.BUSINESS_UNIT AND VCH.VOUCHER_ID =PS_VCHR_LINE_WTHD.VOUCHER_ID AND BUHDR.BUSINESS_UNIT = VCH.BUSINESS_UNIT AND BUHDR.EFF_STATUS = 'A' AND BUHDR.EFFDT = ( SELECT MAX(BUHDR2.EFFDT) FROM PS_WTHD_BU_HDR BUHDR2 WHERE BUHDR2.BUSINESS_UNIT = BUHDR.BUSINESS_UNIT AND BUHDR2.EFFDT <= VCH.ACCOUNTING_DT ) AND BU.BUSINESS_UNIT = BUHDR.BUSINESS_UNIT AND BU.EFFDT = BUHDR.EFFDT AND HDR.WTHD_ENTITY =PS_VCHR_LINE_WTHD.WTHD_ENTITY AND HDR.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_WTHD_ENTITY_HDR B WHERE B.EFFDT <= VCH.ACCOUNTING_DT AND HDR.WTHD_ENTITY = B.WTHD_ENTITY ) AND HDR.EFF_STATUS = 'A' AND DTL.WTHD_ENTITY = HDR.WTHD_ENTITY AND DTL.WTHD_TYPE =PS_VCHR_LINE_WTHD.WTHD_TYPE AND DTL.WTHD_JUR_CD =PS_VCHR_LINE_WTHD.WTHD_JUR_CD AND DTL.WTHD_CLASS =PS_VCHR_LINE_WTHD.WTHD_CLASS AND DTL.EFFDT = HDR.EFFDT AND CAT.WTHD_ENTITY = DTL.WTHD_ENTITY AND CAT.WTHD_TYPE = DTL.WTHD_TYPE AND CAT.WTHD_JUR_CD = DTL.WTHD_JUR_CD AND CAT.WTHD_CLASS = DTL.WTHD_CLASS AND CAT.EFFDT = DTL.EFFDT AND VNDR.SETID = VCH.VENDOR_SETID AND VNDR.VENDOR_ID = VCH.VENDOR_ID AND VNDR.VNDR_LOC = VCH.VNDR_LOC AND VNDR.WTHD_ENTITY = HDR.WTHD_ENTITY AND VNDR.WTHD_TYPE = DTL.WTHD_TYPE AND VNDR.WTHD_JUR_CD = DTL.WTHD_JUR_CD AND VNDR.DEFAULT_CLASS = DTL.WTHD_CLASS AND CAT.VENDOR_CATEGORY = VNDR.VENDOR_CATEGORY AND BU.WTHD_ENTITY = DTL.WTHD_ENTITY AND BU.WTHD_TYPE = DTL.WTHD_TYPE AND BU.WTHD_JUR_CD = DTL.WTHD_JUR_CD AND CAT.BU_CATEGORY = BU.BU_CATEGORY AND LOC.SETID = VNDR.SETID AND LOC.VENDOR_ID = VNDR.VENDOR_ID AND LOC.VNDR_LOC = VNDR.VNDR_LOC AND LOC.EFF_STATUS = 'A' AND LOC.EFFDT = ( SELECT MAX(LOC2.EFFDT) FROM PS_VENDOR_LOC LOC2 WHERE LOC2.EFFDT <= VCH.ACCOUNTING_DT AND LOC2.SETID = LOC.SETID AND LOC2.VENDOR_ID = LOC.VENDOR_ID AND LOC2.VNDR_LOC = LOC.VNDR_LOC ) AND VNDR.EFFDT = LOC.EFFDT) WHERE PS_VCHR_LINE_WTHD.WTHD_RULE = ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_WTHD PWTHD WHERE PWTHD.BUSINESS_UNIT = PS_VCHR_LINE_WTHD.BUSINESS_UNIT AND PWTHD.VOUCHER_ID = PS_VCHR_LINE_WTHD.VOUCHER_ID)

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85419b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL
Failed SQL stmt: UPDATE PS_VCHR_LINE_WTHD SET PS_VCHR_LINE_WTHD.WTHD_RULE = ( SELECT (CASE WHEN VNDR.WTHD_RULE = ' ' THEN CAT.WTHD_RULE ELSE VNDR.WTHD_RULE END) FROM PS_VOUCHER VCH , PS_WTHD_ENTITY_HDR HDR , PS_WTHD_ENTITY_DTL DTL , PS_WTHD_CATEGORY CAT , PS_VENDOR_WTHD_JUR VNDR , PS_WTHD_BU_JUR BU , P (200,0)
Process 388319 ABENDED at Step DCAP24941462.MAIN.Step02 (SQL) -- RC = 1407 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 388319 ABENDED at Step DCAP24941462.MAIN.Step02 (SQL) -- RC = 1407 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms