EAR9.2: AR30003 Includes Multiple Customers When Running For Single Customer (Doc ID 2160960.1)

Last updated on JULY 18, 2016

Applies to:

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

Symptoms


When running the report AR30003 for a single customer (for instance EU0186), the result includes other customers as well, all having the same beginning sequence (such as EU01860, EU01861 and EU01861).

Steps To replicate
-----------------------

  1.  Go to Accounts Receivable/ Pending Items/ Online Items/ Group Entry and create 2 items for customer 1000- one with Payment Terms Immed and one with Payment Terms NET30 in order to be caught by Aging process;
  2.  Go to Accounts Receivable/ Pending Items/ Online Items/ Group Entry and create 2 items for customer 10001- one with Payment Terms Immed and one with Payment Terms NET30 in order to be caught by Aging process;
  3.  Go to Accounts Receivable/ Receivables Analysis/ Aging/ Aging Detail by Unit Rpt for Customer ID 1000 and save and run AR_Aging process - SQR report for process name AR30003 is listing items for all the customers that have the same beginning sequence, instead of listing the results only for the selected customer (listed items are for both customers - 1000 and 10001).

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