EEX8.8SP1/ 8.9/ 9.0: Expense Processing Abends at Step EX_POST_LIAB.INSERTAE.INSAE with Unique Constraint Error When Unposting with 'Post Liabilities' Selected
(Doc ID 656628.1)
Last updated on APRIL 17, 2025
Applies to:
PeopleSoft Enterprise FIN Expenses - Version 8.8 SP1 to 9 [Release 8.8 to 9]Information in this document applies to any platform.
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201049202
Symptoms
Once an Expense Report in the system has been created and gone through the Post Liabilities request process, if the transaction is marked for unposting, the UNPOST_SEQ field from the record PS_EX_SHEET_HDR is not calculated correctly.
This happens when in the Mark Expense Report For Unpost page (), users click the UnPost several times having previously changed the Unpost Date. Each time the system stores in PS_EX_SHEET_HDR record, and UNPOST_SEQ field the new number.
When later on the Expense Processing program (EX_TRAN_PRCS) gets launched with the 'Post Liabilities' option selected, it abends as it is trying to insert duplicate accounting lines into PS_EX_ACCTG_LINE table, as it is expecting to process a new repost. The Error Message obtained is the following:
-- 08.42.56 Process 5075 ABENDED at Step EX_POST_LIAB.INSERTAE.INSAE (Action SQL) -- RC = 805
ROLLBACK
/
-- 08.42.56 SQL Error: ORA-00001: unique constraint (EMDBO.PS_EX_ACCTG_LINE) violated
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 |