Purchase Order Inbound (850/ORDERS) errors with ORA-28115: Policy with Check Option Violation

(Doc ID 1905263.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
*** Checked for relevance on 21-Aug-2017 ***


When attempting to IN: Purchase Orders (850/ORDERS) for a specific operating unit
the following error occurs


ORA-28115: policy with check option violation.

This error occurs when the program picks up an Order belonging to a different operating unit.

When the program is submitted with the same Operating Unit parameter as that of the Order then this completes successfully.


The responsibility security profile allows access to both the operating units, so it is expected that the program processes both the operating units orders.


1. E-Commerce Gateway Responsibility
2. Process --> Import Program --> From LOV choose "IN: Purchase Orders (850/ORDERS)"
3, Notice the program completes in Warning status and see the above error


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms