My Oracle Support Banner

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

Last updated on MARCH 09, 2019

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 Recreate:

1. Search for a partner in the UserInterface(UI).
2. Search for the same partner in the database.
3. Observe discrepancy in results.




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.