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

Last updated on MARCH 09, 2017

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.

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