Partner Database Primary Key Does Not Match Package Validation on PARTNER_EXISTS Function
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.
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.
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