EAP: Voucher Build Abends At Step APVEDTSCHD.MAIN.Step15 (Action SQL) -- RC = 1407

Last updated on MARCH 20, 2017

Applies to:

Symptoms

Voucher Build process abends when Invoice Date is less than Supplier's Address Effective Date

ERROR
File: e:\pt85506c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 27  Return: 1407 - ORA-01407: cannot update ("EMDBO"."PS_VED_VCH_TAO5"."PYMNT_CNT_MAX") to NULL Failed SQL stmt: UPDATE PS_VED_VCH_TAO5 SET PYMNT_CNT_MAX = ( SELECT MAX(A.PYMNT_CNT) FROM PS_VED_PV X_TAO5 A WHERE A.PROCESS_INSTANCE = PS_VED_VCH_TAO5.PROCESS_INSTANCE AND A.BUSINESS_UNIT = PS_VED_VC H_TAO5.BUSINESS_UNIT AND A.VOUCHER_ID = PS_VED_VCH_TAO5.VOUCHER_ID) WHERE PROCESS_INSTANCE = 91513   

Process 91513 ABENDED at Step APVEDTSCHD.MAIN.Step15 (SQL) -- RC = 1407  30 2:58:29PM 91513 APVEDTSCHD MAIN Step15 SQL 1407

STEPS
1. Take an existing supplier - 0000000044 and creating a quick invoice with invoice dt 06/01/2016 (less than the supplier's address date which was 07/01/2016)
2. In the quick invoice payment link - checked the separate payment checkbox
3. Ran voucher build from the page itself
4. Process abends with the following error

Changes

Cause