Last updated on MARCH 20, 2017
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
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