My Oracle Support Banner

EAR 9.2: The Collections Workbench Times Out when a Search for Corporate Customer with 5000 Child Customers Is Done (Doc ID 2674861.1)

Last updated on MAY 27, 2020

Applies to:

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

Symptoms


After applying the fix from <Bug 30067030> (AR: COLLECTIONS WORKBENCH ERROR MESSAGE AR_CWB_WRK.FUNCLIB.FIELDFORMULA), the Collections Workbench functionality (Page COLLECTION_WRKBNCH), no longer throws an SQL Error Message if the User performs a search for a Customer ID marked as the Corporate Customer for more than 5,000 Child Customers.

However, the page search functionality keeps spinning, until it now times out.

REPLICATION STEPS:

  1.- Log into the FSCM Online Application as a Receivables User
  2.- Navigate to: Customers > Customer Information > General Information
  3.- Open an existing Customer ID, and at the General Info tab, select the 'Corporate Customer' flag
  4.- Save the changes
  5.- Now open a second existing Customer ID, and at the General Info tab, make sure the 'Corporate Customer' flag in NOT selected, and instead, select the Customer Set ID and Customer ID values from point #3
  6.- Save the changes
  7.- Repeat steps #5 through #6 roughly 5000 times
  8.- Navigate to: Accounts Receivable > Collections Workbench
  9.- Populate the Customer Set ID, Customer ID as the Corporate Customer, and click on SEARCH button
  10.- The system keeps spinning until it times out

The Collections Workbench functionality cannot be used for such Corporate Customers, and as such, the Users are unable to perform their reviews, and daily tasks. The Users also get kicked out of their session, which means any changes at the page level will be lost.

The delivered functionality should have a more efficient SQL Select Statement around Record View PS_CUST_HVIEW_VW, and allow Collections Workbench to pull the requested transaction data in a timely manner for further review.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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