'ORA-28115: policy with check option violation' when importing value sets — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

'ORA-28115: policy with check option violation' when importing value sets

Summary:

We're trying to import Flexfields and Value Sets from one environment to another, but we are getting this error when doing so:
"ORA-28115: policy with check option violation", and in the error log we can see that this error is caused by trying to do an INSERT into the Value Sets Table.
Has anyone had and resolved this error? We're wondering if this is caused by a missing user privilege, or if it's caused by something else.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!