EDI-SPSI IN: Planning Schedule - ECE_INBOUND.INSERT_INTO_PROD_INTERFACE Resubmit Fails: ORA-28115: Policy With Check Option Violation (Doc ID 2880199.1)

Last updated on JULY 01, 2022

Applies to:

Symptoms

After Upgrading to 12.2.9, when resubmitting SPSI (830) Planning Schedule documents in e-Commerce Gateway
Process : View Staged Documents fails to resubmit with ORA-28115: policy with check option violation.
 
ERROR
-----------------------
ECEDOCID: EDI Inbound Document ID
---------------------------------------------
Please define ORG_ID.
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.
Insert failed for document(s).
1 documents failed in Insert.
Program level ECE_INBOUND.CLOSE_INBOUND: Please check the log file, correct the
problem, and try again.
SQL error message ORA-01403: no data found.


STEPS
-----------------------
1. Responsibility: Order Management Super User
2. Run Concurrent Program: EDI Inbound SPSI (830) for Document ID
3. Error: ORA-28115: Policy With check option violation

 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.