My Oracle Support Banner

EAP: POREVERSAL - ORA - 00001 Unique Constraint Error When Deleting Voucher That Already Created PO EE Entries (Doc ID 2755456.1)

Last updated on FEBRUARY 21, 2023

Applies to:

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

Symptoms



POREVERSAL error when deleting voucher that already created PO EE entries


ERROR
-----------------------
File: e:\pt857p10b_1909250501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_EE_PO_ACCTG_LN) violated Failed SQL stmt: INSERT INTO PS_EE_PO_ACCTG_LN (BUSINESS_UNIT, PO_ID, UNPOST_SEQ, APPL_JRNL_ID, LINE _NBR, SCHED_NBR, DISTRIB_LINE_NUM, MOD_SEQ_NBR, DST_ACCT_TYPE, VOUCHER_ID, EE_EVENT_STEP, KK_TRAN_ID , K


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Configure KK/EE to create entries for both PO and AP transactions in installation options.
2. Create PO CMREP01 with dates set to 01/01/2016. Process through to PO EE.
3. Verify PO EE entries.
4. Create voucher CMREP01 to PO CMREP01 for 01/11/2016 and budget check
5. Verify PO EE entries.
6. Create voucher CMREP02 to PO CMREP01 for 01/12/2016 and budget check
7. Verify PO EE entries.
8. Create voucher CMREP03 to PO CMREP01 for 01/13/2016 and budget check
9. Verify PO EE entries.
10. Create voucher CMREP04 to PO CMREP01 for 01/14/2016 and budget check
11. Verify PO EE entries.
12. Change accounting date on all vouchers to 02/nn/16 and re-budget check
13. Run PO EE for CMREP01 and verify PO EE entries
14. Delete vouchers CMREP01 and CMREP02.
15. Run PO EE for CMREP01 and verify PO EE entries.
16. Create voucher CMREP05 to PO CMREP01 for 01/15/2016 and budget check
17. Run PO EE for PO 84 ** GET ERROR **
 


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.