My Oracle Support Banner

EAR9.2: ARPUDATE Abends At Step IU_PROCESSOR.U400.U400-010 (Action SQL) (Doc ID 2005127.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.


Statement of Issue
ABENDED at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805
-- 11.54.40 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated

This is happening when ARUPDATE processes items with multiple lines. Replication includes standard Chartfield Configuration where some chartfields were activated/inactivated, order of fields were changed and there were name changes. This resulted in differences in the order of chartfields in the SQL definitions.

Steps to Replicate
1. Create an item with multiple AR lines
2. Pay item with bank from different GL BU to create interunit entries


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

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