IN: Purchase Orders (850/POI) ECPOI2.sql Fails with ORA-28115: Policy With Check Option Violation
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.
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
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