AP:ERROR WHILE DOING THE VOUCHER MAINTENANCE
(Doc ID 2181277.1)
Last updated on JANUARY 12, 2018
PeopleSoft Enterprise FIN Payables Brazil - Version 9.1 and later Information in this document applies to any platform.
ISSUE: --------- 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) 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:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!