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.
Can we request the unique constraint be removed?
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.
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