My Oracle Support Banner

AP:ERROR WHILE DOING THE VOUCHER MAINTENANCE (Doc ID 2181277.1)

Last updated on APRIL 02, 2019

Applies to:

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

Symptoms

 

ISSUE:
---------
When the Voucher has a direct tax incorporated and when using the voucher maintenance functionality the afterwards process doesn't conclude.

ERROR:
------------


AP_DRTXCALC.PRO_WTHD.PRO_WTHD4

Failed SQL stmt: INSERT INTO PS_VCH_DUP_INV_REG (BUSINESS_UNIT , VOUCHER_ID , VENDOR_SETID , VENDOR_ID , INVOICE_ID , ERS_INV_SEQ , INVOICE_DT , GROSS_AMT) SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_SETID , A.VENDOR_ID , UPPER(A.INVOICE_ID) , A.ERS_INV_SEQ , A.INVOICE_DT , A.GROSS_AMT FROM PS_VED_VCH_TAO6 A WHERE PROCESS_INSTANCE = 105992 AND NOT EXISTS( SELECT 'X' FROM PS_VCH_DUP_INV_REG D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.VOUCHER_ID = A.VOUCHER_ID)
 
STEPS:
-----------
When the Voucher has a direct tax incorporated and when using the voucher maintenance functionality, then afterwards the Voucher creation process will finish unsuccessfully it doesn't conclude.
 Below are the prints showing the error:

Voucher 00006663:
 

Imposto Direto (Direct Tax) :
 
In this example I will use the Voucher maintenance option to change one account:
Navigation - Main Menu > Accounts Payable > Vouchers > Maintain > Voucher Maintenance.
After changing the account, click in “Save” botton

 
After changig what was necessary, run the creation voucher process by selecting the maintenance option by navigating trough:

Main Menu > Accounts Payable > Batch Processes > Vouchers > Voucher Build
After selecting the yellow fields, click in “Run” botton then clikc in “OK”.
 
Clicking in the link “Process Monitor” you will be able to verify that the process ended with the status: “ No Success.

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


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