AP:ERROR WHILE DOING THE VOUCHER MAINTENANCE
Last updated on JANUARY 12, 2018
Applies to:PeopleSoft Enterprise FIN Payables Brazil - Version 9.1 and later
Information in this document applies to any platform.
When the Voucher has a direct tax incorporated and when using the voucher maintenance functionality the afterwards process doesn't conclude.
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)
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:
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.
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