My Oracle Support Banner

EAR9.2: Auto Maintenance Process Going In Error At Step AR_AUTOMNT.#OLDEST.TOT_GRPS (Doc ID 2484711.1)

Last updated on JULY 11, 2019

Applies to:

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

Symptoms

Issue:
----------
Automatic Maintenance process ends with an error when using the #OLDEST Algorithm method to apply a credit balance item to a debit balance item from different Business Units on the same customer.


ERROR
-----------------------
SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_MT_TOTAL2_TAO4' with unique index 'PS_MT_TOTAL2_TAO4'.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create debit balance item on a customer's account with Business Unit #1
2. Create credit balance item on same customer's account with Business Unit #2
3. Run Accounts Receivable > Receivables Maintenance > Automatic Maintenance > Request Automatic Maintenance with Override Method OLDEST

Please see the replication screenshot for more details.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.