My Oracle Support Banner

EAR9.2: AR_POST1 Process Fails With Unique Constraint Errror When Unposting Group With Audit Logging Enabled (Doc ID 1982493.1)

Last updated on APRIL 08, 2019

Applies to:

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


FMS 9.2 Production

Statement of the issue:

Expected Behavior:
ARUPDATE should not fail at step (AR_POSTING.ALOG_UNP.TAO_INSP)

Steps to Replicate:

  1. Enable Audit Logging for Unpost AR Item by going to Set Up Financials/Supply Chain > Common Definitions > Audit Logging > Enable Audit Logging for Accounts Receivables
  2. Create a pending item, for example JAN7_I1 for amount $100 with payment method as direct debit and run ARUPDATE to post the item.
  3. Run create direct debit to pay the item JAN7_I1 created in Step1.
  4. Run ARUPDATE to close item JAN7_I1.
  5. Create online pending group with two pending items - one JAN7_I1 as entry type CR for an amount of -$200 and other JAN7_I1 as entry type IN for an amount of $200.
  6. Run ARUPDATE to post the group created in step 4.
  7. Unpost the group created in step 5 and run ARUPDATE.


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.