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.


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
-- 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.


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