My Oracle Support Banner

Oracle Public Sector Permits Cloud: User getting Unique Constraint Violated Error When Converting Permit Status Histories (Doc ID 2815314.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Public Sector Permits Cloud Service - Version 11.13.21.07.0 and later
Information in this document applies to any platform.

Goal

Can we request the unique constraint be removed?

Details:

User running into unique constraint violation errors when converting  records, and the issue appears to be with the ChangeDate field.

For example, the 'Submitted' and 'Permit Issued' status histories have been converted, and I attempt to convert a 'Completed' status history record with a ChangeDate that identically matches a ChangeDate from the previously converted 'Submitted' and 'Permit Issued' records, user get a unique constraint violation error.

Solution

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
Goal
Solution


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