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

Last updated on MAY 16, 2016

Applies to:

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

Symptoms

On : 12.1.2 version, Order Management

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
-----------------------
The issue can be reproduced at will with the following 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