My Oracle Support Banner

Integrity Constraint Error Occurs when Clicking OK on the Create Contract Form (Doc ID 2641589.1)

Last updated on MAY 28, 2020

Applies to:

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


After applying the <Patch 29758284> (RMS_16.0.2_CUMULATIVE_HF_MAY_2019_2) the Create Contract process fails with an integrity-constraint error.

Error: "An error occurred in the Database due to an integrity constraint violation. Please contact System Administrator"

Steps To Recreate:

  1. Login to Retail Merchandise System(RMS) and Navigate to Tasks >Orders > Contracts.
  2. Select  Create Contract.
  3. Select any information on the next screen.
  4. When user click “ok”, the above mentioned error is reported.




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

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