EAR9.1: Automatic Maintenance 'Resolve, Item Balance Open' not Working as Described in Peoplebooks. The Process is not Selecting any Debit and Credit Items for Processing. (Doc ID 1598072.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

On : 9.1 version, Automatic Maintenance

ACTUAL BEHAVIOR
---------------
Automatic Maintenance (AR_AUTOMNT) process using action 'Resolve, Item Balance Open' is not working as described in Peoplebooks.
The process is not selecting any debit and credit items for processing.

EXPECTED BEHAVIOR
-----------------------
Automatic Maintenance (AR_AUTOMNT) process using action 'Resolve, Item Balance Open' should be working as described in Peoplebooks.
The process should select debit and credit items for processing.
The process should close the items with the larger total absolute amount, except for the item with the latest due date, which remains open with a balance equal to the difference between the two amounts.

REQUIRED SETUP
---------------------

  1. Navigate to Set Up Financials/Supply Chain > Product Related > Receivables > Credit/Collections > Automatic Maintenance Methods and create a new method with the following setup:
    • Enable 'Match References'.
    • Debit Field: Order No
    • Operator =
    • Credit Field: order No
    • Customer Level: N
    • Match Type: All
    • Remaining Balance Action
      • = 0 Resolve
      • > 0, within tolerance Resolve, Item balance open
      • > 0, over tolerance Resolve, Item balance open
      • < 0, within tolerance Resolve, Item balance open
      • < 0, over tolerance Resolve, Item balance open
  2. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Receivables > Receivables Options and link Automatic Maintenance Method to the Receivables Options.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create and post the following 4 items for business unit US007 and customer USA10:
    • DEBIT_04, due 01-Aug-2013, amount 75 USD
    • DEBIT_05, due 22-Aug-2013, amount 125 USD
    • CREDIT_04, due 08-Aug-2013, amount -100 USD
    • CREDIT_05, due 15-Aug-2013, amount -45 USD
  2. Run SQL update to populate Order Number for all items. Example:
    • UPDATE PS_ITEM SET ORDER_NO = 'ORDER_02' WHERE BUSINESS_UNIT = 'US007' AND CUST_ID = 'USA10'
  3. Navigate to Accounts Receivable > Receivables Maintenance > Automatic Maintenance > Request Automatic Maintenance and run Run Automatic Maintenance (AR_AUTOMNT) process.
  4. Message log is showing:
    • 0 debit items selected for processing.
    • 0 credit items selected for processing.
    • 0 Maintenance Worksheets created.
    • 0 line items created on Maintenance Worksheets.
    • 0 Pending Groups created.
    • 0 line items created in Pending Groups.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Automatic Maintenance to match debit to credits using action 'Resolve, Item balance open'.

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