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

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of Issue
-----------------------------------
ABENDED at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805
ROLLBACK
/
-- 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms