My Oracle Support Banner

When Doing Integration From A User In One Domain Associated with a User Role In A Sub-Domain, Error "ORA-28115 policy with check violation" Appears (Doc ID 2085644.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.4.2 [Release 6.2 to 6.4]
Information in this document applies to any platform.


When doing Integration (for e.g. for OB_LINE_REFNUM on an Order Base) from a user in one domain associated with a user role in another sub-domain, they you see the following error

Notice in the domain in the last insert statement above - it shows as TEST instead of TEST_SUB. Because grants of ALL_TS has been given, this goes through.

If that were not the case, the process will give the error "ORA-28115 policy with check 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

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