Performance issue with Update Solution Usage Counts Process (Doc ID 2238868.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

On : 9.2 version, Solution Management

ISSUE:
Performance issue when running the Update Solution Usage Counts

 

STEPS
-----------------------

1. Navigate to Solutions > Update Solution Usage Counts

2. Run the process with following options:

Under Solution Usage Counts:
- Solution Usage Counts
- Solution usage by Category/Type/Detail

Under Create Solution Linkages:
- Solution Product Link
- Solution Category/Type/Detail Link
- Product Search table

The process RC_SOLN_USAG runs for hours.



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