My Oracle Support Banner

Lack of Index on TENDER_COLLAB_SERVPROV Causes Service Provider Queries to do a Full Table Scan (Doc ID 737670.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5 to 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.04, Find that when any service provider attached with the default SERVPROV VPD profile, runs any query involving shipments, there is a full table scan on the tender_collab_servprov since that table is referred to in the VPD
EXPECTED BEHAVIOR
Expect that the full table scan is avoided by adding an index

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log on as a Service Provider and run the query on Shipment records
2. Capture the execution plan for such a query and see that there is a full table scan on the
Tender_collab_Servprov table

-- Business Impact:
The issue has the following business impact:
Due to this issue, general performance is affected for Service Perovider users

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
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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