Inserting Attachment with Accent Symbol to Note Gives Constraint Violated During Post

(Doc ID 2084641.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to attach a file in the Notes tab, the following error occurs.

ERROR
-----------------------
Error Page. Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "SYS_C0036531" violated during post operation:"Insert" using SQL Statement "INSERT INTO FND_LOBS(FILE_ID,FILE_NAME,FILE_CONTENT_TYPE,UPLOAD_DATE,PROGRAM_NAME,FILE_DATA,ORACLE_CHARSET,FILE_FORMAT) VALUES (:1,:2,:3,:4,:5,:6,:7,:8)".


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot insert attachments.

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