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:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |