My Oracle Support Banner

'ORA-28115: policy with check option violation' Error During CSV Upload (Doc ID 2577381.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Global Trade Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management - Version 4.0 and later
Oracle Global Trade Management - Version 6.1.0 and later
Information in this document applies to any platform.

Symptoms

You are trying to update (U) the ITEM DESCRIPTION in the ITEM table using CSV file. The description is (PLATE, SPACER, 5" PIN SPACING) includes double quotes.

The CSV file upload fails with (ORA-28115: policy with check option violation).

It works if you remove the double quotes.

Replication Step:
--------------------

01. Create a CSV file as follows.

ITEM
ITEM_GID ITEM_XID ITEM_NAME DESCRIPTION DOMAIN_NAME
EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
DOMAIN_NAME.6920590 6920590 SWE8550-50 PLATE, SPACER, 5" PIN SPACING DOMAIN_NAME


02. Upload the file via Business Process Automation > Integration > Integration Manager > Upload an XML/CSV Transmission
On the next page, use U transaction code.

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


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