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

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Environment:
---------------------
FMS 9.2 Production

Statement of the issue:
------------------------------------
ARUPDATE failed at step (AR_POSTING.ALOG_UNP.TAO_INSP)

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.


Business Impact:
--------------------------
Customer can not correct the wrong amount

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