EAR9.2: AR_AUTOMNT Creates Match Group for Item Balance When Amounts are Not Unique (Doc ID 1933323.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

ENVIRONMENT
-------------------------
EAR 9.2 Image 5

Statement of Issue
-----------------------------------
AR_AUTOMNT creates match group for item balance when amounts are not unique.

Expected Behavior
-----------------------------------
As per Peoplebooks on Match Type = One to One:
Matches debit and credit items of the same amount for a customer as long as the amounts are unique. For example, if you select Item Balance as the matching criteria in both the Debit Field and the Credit Field, and there are two 1,000.00 USD debits and one 1,000.00 USD credit, it does not match the items.

Actual Behavior
--------------------------------
Match Group gets created for 2 credits and 1 debit of the same amounts.

Business Impact
---------------------------------------
When ARUPDATE runs results in OOBM error:
Maintenance Group Out of Balance. (6035,27)
Action: Verify the sum of control base amount equals the control amount and the total count of pending items.

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

  1. Create debit and credit items for customer US003/1003.
  2. Create another credit item with the same amount for the same customer US004/1003.
  3. Set up Automatic Maintenance using Item Balance.

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