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

(Doc ID 1294851.1)

Last updated on AUGUST 21, 2017

Applies to:

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

Symptoms


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

ERROR

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.


STEPS

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

Cause

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