My Oracle Support Banner

IN: Purchase Orders (850/POI) ECPOI2.sql Fails with ORA-28115: Policy With Check Option Violation (Doc ID 1294851.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Order Management - Version 12.1.2 and later
Information in this document applies to any platform.


When attempting to run 850 POI ECPOI2.sql to bring in the transaction into the application,the following error occurs.


Program level ECE_INBOUND.INSERT_INTO_PROD_INTERFACE: Please check the log file, correct the problem, and try again.
SQL error message ORA-28115: policy with check option violation.


1. Responsibility: e-commerce gateway responsibility and View Stage Documents responsibility
2. Navigate: Run $EC_TOP/patch/115/sql/ECPOI2.sql
3. Run the Seed Data Reconciliation Process for Purchase Order Inbound (850/POI)
NOTE: Ran this step with parameter Preserve = Y due to customization


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.