EAP: Able to Unapply Regular Voucher From Fully Applied Prepaid Voucher Even Through Prepaid Reversals Are Posted (Doc ID 3066787.1)

Last updated on JANUARY 08, 2025

Applies to:

Symptoms

When Prepaid Voucher amounts are fully applied and Prepaid Reversals are posted on a Regular Voucher, the system does not allow to unapply the Prepayments. But in this scenario, since the User opened a new window to post the Regular Voucher and then went back to the previous window where the Regular Voucher was applied to the Prepayment, the User was able to unapply the Regular Voucher from the Prepaid Voucher after Prepaid Reversals were posted. Unfortunately, there is no way to correct posted Prepaid Reversals. As a result, when Voucher Posting was run to post other Vouchers, Voucher Posting abends at Step AP_PSTCOMMON.ACCOUNTS.Step05 with a unique constraint error.

ERROR
Process xxxxxx ABENDED at Step AP_PSTCOMMON.ACCOUNTS.Step05 (Action SQL) -- RC = 805

SQL Error: ORA-00001: unique constraint (EMDBO.PS_VCHR_ACCTG_LINE) violated

STEPS TO REPLICATE
1. Accounts Payable > Vouchers > Add/Update > Regular Entry
2. Add 1st Prepaid / Supplier ID = xxxxxxxxxx / Total = 17,850.00
3. Add 2nd Prepaid Voucher / Supplier ID = xxxxxxxxxx / Total = 1,050.00
4. Add 3rd Prepaid Voucher / Supplier ID = xxxxxxxxxx / Total = 1,601.25
5. Add 4th Prepaid Voucher / Supplier ID = xxxxxxxxxx / Total = 1,188.40
6. Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
7. Pay the Prepaid Vouchers through the Pay Cycle Manager
8. Accounts Payable > Batch Processes > Vouchers > Voucher Posting
9. Run Voucher Posting to post the Prepaid Vouchers
10. Accounts Payable > Batch Processes > Payment > Payment Posting
11. Run Payment Posting to post the 4 Payments
12. Create 1st Regular Voucher / Supplier ID = xxxxxxxxxx / Total = 20,088.40
13. Accounts Payable > Payments > Manual Payment and Prepayment > Apply Vouchers to Prepayment
14. Apply Regular Voucher to 1st Prepaid Voucher
15. Apply Regular Voucher to 2nd Prepaid Voucher
16. Apply Regular Voucher to 3rd Prepaid Voucher
17. While still on the Apply Vouchers to Prepayment, click on the link for New Window
18. In the new Window, run Voucher Posting to post the Regular Voucher
19. In the new Window, Accounts Payable > Review Accounts Payable Info > Vouchers > AP Accounting Entries
      a. Display the Regular Voucher
      b. Regular Voucher has AP Accrual and Prepaid Reversals posted
20. Re-display 1st Window
21. Unapply Regular Voucher from 3rd Prepaid Voucher
22. Apply Regular Voucher to 4th Prepaid Voucher
23. Create 2nd Regular Voucher for Supplier ID = xxxxxxxxxx or any other Supplier
24. Run Voucher Posting to post the Regular Voucher using Post Voucher Option = Post Business Unit
25. Voucher Posting runs to No Success and abends at Step AP_PSTCOMMON.ACCOUNTS.Step05 abends with a unique constraint error, trying to insert into PS_VCHR_ACCTG_LINE

Changes

Cause

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