Partner Database Primary Key Does Not Match Package Validation on PARTNER_EXISTS Function

(Doc ID 2390626.1)

Last updated on APRIL 30, 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

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 hundreds of Community platforms