IN: Purchase Orders (850/POI) ECPOI2.sql Fails with ORA-28115: Policy With Check Option Violation
(Doc ID 1294851.1)
Last updated on NOVEMBER 30, 2020
Applies to:
Oracle Order Management - Version 12.1.2 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |