My Oracle Support Banner

EAP: Voucher Post Failed When Run After Payment Post From The Payment Cancellation Page (Doc ID 3037190.1)

Last updated on AUGUST 06, 2024

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When the user tries to cancel a payment with close/do not reissue option on the payment cancellation page, and then runs payment posting followed by voucher posting, the voucher posting fails due to a unique constraint as it tries to do payment post entries again. Both processes were triggered by selecting the process from dropdown and then just saving the page.

ERROR
------------
 Process 1169722 ABENDED at Step AP_PSTCOMMON.ACCOUNTS.Step05 (Action SQL) -- RC = 805
ROLLBACK
/
SQL Error: ORA-00001: unique constraint (PS_VCHR_ACCTG_LINE) violated



STEPS:

1. Menu > Accounts Payable > Payments > Payment Cancellation

2. Select any payment and choose the Void and Do Not Reissue/Close Liability option and Save Page

3. Select Payment Post and Save Page

4. At this point, payment cancellation entries are created.

5. After Payment Post runs to Success, without refresh, return to search and select the same payment again

6. Select Voucher Post and Save the page

7. Voucher post abends with unique constraint because payment cancellation entries are already created, and it is trying to create them again along with closure entries

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.