EAR 9.2: AR Statements Are Generated for Customers Having Negative Balances or for Inactive Status Ignoring the Statement Rules Defined on the Statement Setup When Run for Multiple Customers. (Doc ID 2921201.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

AR Statements are generated for customers having negative balances or for inactive status ignoring the statement rules defined on the Statement setup when run for multiple customers.
 
If the process is run for a single customer, it's working as expected based on the statement setup.


REPLICATION STEPS:
---------------------------

1. Goto Set Up Financials/Supply Chain > Product Related > Receivables > Payments > Define Statement ID's > Statement MODEL and check all cancel document options.
2. Go to Receivable Options (Set Up Financials/Supply Chain > Business Unit Related > Receivables > Receivables Options), and Setup Statement ID as MODEL.
3. Open Customer USA02 (Customers > Customer Information > Create Customer Information), Go to Correspondence Options - set the statement ID as MODEL and the select group as GROUP D.
4. Open Customer USA04, Go to Correspondence Options - select group as GROUP D and set the statement ID as Blank, so it gets defaulted from receivable options.
4.1 - For USA04 ensure that it has a negative balance.
5. Go to Customer USA95: Set the Customer as Inactive, set the statement ID as MODEL and the select group as GROUP D.
6. Go to Statements RunControl: Provide the following parameters
Unit: All BU,
Customer ALL Customers
NO Balance Forward
7. Run AR Statements (ARSTMT) Process (Accounts Receivable > Customer Interactions > Statements > Create Customer Statements > Statement Parameters).
8. Total of 3 statements were generated, one for the inactive customer, the second has a negative balance and only 1 should be generated based on the setup having a positive balance.

Cause

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