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

Last updated on FEBRUARY 05, 2019

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.