My Oracle Support Banner

Primary Key Joins Are Missing In CORESVC_ITEM Package Causing Performance Issue (Doc ID 2453120.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Primary key joins are missing in CORESVC_ITEM package.

V_PARTNER view is being joined based on PARTNER_ID only to SVC_ITEM_SUPP_COUNTRY_LOC and SVC_ITEM_SUPP_COUNTRY tables, however the primary key on PARTNERS is the partner type and partner id.

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.