My Oracle Support Banner

Partner Database Primary Key Does Not Match Package Validation on PARTNER_EXISTS Function (Doc ID 2390626.1)

Last updated on NOVEMBER 07, 2018

Applies to:

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

Symptoms

Partner database primary key does not match package validation. If constraint PK_PARTNER uses both partner_id and partner_type, then the validation PARTNER_SQL.PARTNER_EXISTS should use both fields for checking if the partner already exists.

Steps to Reproduce:
1. Search for a partner in the UI.
2. Search for the same partner in the database.
3. Observe discrepancy in results.

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!


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