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.
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.
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