EAR 9.2: Auto Maintenance Process (AR_AUTOMNT AE Program) Creates Unbalanced Count for a Maintenance Group, Resulting in Error Code OOBM (6035,27) When AR Update Is Run (Doc ID 2978168.1)

Last updated on OCTOBER 03, 2023

Applies to:

Symptoms

The Automatic Maintenance process (AR_AUTOMNT AE Program) is generating a Maintenance Group that has a Group Total Count greater than the actual number of Pending Items included within the Group. As a result, when trying to post the transaction, the AR Update is placing the resulting Group into Error Code OOBM.

This takes place when there is a Debit Item to be matched against a Credit Item with multiple Transaction Lines.

REPLICATION STEPS:

    1.- Create a new Automatic Maintenance Method that will match Credit Item ID with Document ID of a Debit Item, and write off small amounts   (Navigation Path: Set Up Financials/Supply Chain > Product Related > Receivables > Credit/Collections > Automatic Maintenance Methods)
    2.- Define Write Off Tolerances at the Business Unit level, Customer level, and Automatic Entry Type level, while leaving User Preferences Maintenance Worksheet write-off tolerances at 0
    3.- Set up the Automatic Maintenance Method to the Receivables Options Set ID SHARE used for Business Unit US001   (Navigation Path: Set Up Financials/Supply Chain > Business Unit Related > Receivables > Receivables Options)
    4.- Create a new Pending Item Group with a Credit Item ID AUTO-MAINT-01 on Business Unit US001, Customer ID 1001, and with 2 Lines, for an amount of -1,000.00 USD and -500.00 USD respectively. Set the Post Action to Batch Standard.   (Navigation Path: Accounts Receivable > Pending Items > Online Items > Online Item Entry Group)
    5.- Create a second Pending Item Group with a Debit Item ID OSS12345, on Business Unit US001, Customer ID 1001, an amount of 1,500.01 USD, and Document ID AUTO-MAINT-01. Set the Post Action to Batch Standard.   (Navigation Path: Accounts Receivable > Pending Items > Online Items > Online Item Entry Group)
    6.- Launch AR Update for Business Unit US001, and Pending Items option selected   (Navigation Path: Accounts Receivable > Receivables Update > Request Receivables Update)
    7.- Confirm that Item IDs AUTO-MAINT-01 (2 lines for a combined amount of -1,500.00 USD), and OSS12345 (Credit amount of 1,500.01 USD) are posted against the Customer ID 1001 Account   (Navigation Path: Accounts Receivable > Customer Accounts > Item Information > View/Update Item Details)
    8.- Launch Automatic Maintenance process (AR_AUTOMNT AE Program) for Business Unit US001, and the Automatic Maintenance Method defined   (Navigation Path: Accounts Receivable > Receivables Maintenance > Automatic Maintenance > Request Automatic Maintenance)
    9.- The Automatic Maintenance program generates the needed Maintenance Group
    10.- Launch AR Update for Maintenance transactions   (Navigation Path: Accounts Receivable > Receivables Update > Request Receivables Update)
    11.- PROBLEM: AR Update marks the Maintenance Group in Error   (Navigation Path: Accounts Receivable > Receivables Update > Correct Posting Errors > Worksheet)

ERROR MESSAGE:

The Automatic Maintenance process (AR_AUTOMNT AE Program), is generating the Maintenance Group with an inconsistent Total Count being greater than the number of Pending Items within the Group, preventing the transaction from being posted, and missing the needed Accounting Entries. Instead, the process should be able to handle the scenario at hand, balancing the Debit against the Credit Items, and write-off the small amount left over, generating the Maintenance Group with a balanced count.

Changes

Cause

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