EAR9.2: ARUPDATE Fails At AR_POSTING.ALOG_PAY.INS_DB (Action SQL) for Partial Unpost Payment When Audit Logging is Enabled for Unpost Payment (Doc ID 2068526.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of the issue:
----------------------------------
ARUPDATE fails at AR_POSTING.ALOG_PAY.INS_DB (Action SQL) for partial unpost payment when the audit logging enabled for Unpost payment.

Error Message:
--------------------
Process 725293 ABENDED at Step AR_POSTING.ALOG_PAY.INS_DB (Action SQL) -- RC = 805
ROLLBACK
/
-- 14.12.17 SQL Error: ORA-00001: unique constraint (HEACPT.PS_AR_AUD_PYMNT) violated

Steps to Replicate:
---------------------------------

  1. Audit logging enabled for Unpost payment.
  2. Unpost a partial payment.

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