Completed Agreements (PS_SCC_TM_AGRVW) Performance Issue (Doc ID 2926905.1)

Last updated on OCTOBER 16, 2023

Applies to:

Symptoms

When students attempt to review a completed Agreement / Activity Guide the system is slow and sometimes students are unable to view their Agreement.

This seems to be happening because there are no criteria on a query using the View SCC_TM_AGRVW.

It is expected the query will be quickly executed.

The issue can be reproduced at will with the following steps:

1. Assign an activity guide to a student.
2. Login to Self-Service as the student.
3. Open the Tasks tile.
4. Open the Completed Agreements item from the navigation collection.

Cause

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