My Oracle Support Banner

R12 E-Business Suite Applications Framework Attachment Text Column Contains "oracle.sql.CLOB@xxxxx" For ' LONG TEXT' Attachments (Doc ID 2422540.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Applications Framework - Version 12.1.3 and later
Oracle Common Application Components - Version 12.1.3 and later
Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications Framework, OA Framework Attachment related issues

 

 

 

 

In OA Framework (FWK) screens for all functional product modules, attachments with data type 'long text' are displayed as 'oracle.sql.CLOB@xxxx'.

For example on Requisitions in iProcurement, select Attachment whose type is LONG TEXT, then move to View Attachment screen, and Attachment Text column shows oracle.sql.CLOB@xxxxx .

Users can't confirm text data of attachment on OA Framework.

The same kind of issue happening on Self Service Purchasing and EAM Work orders as well.

Changes

Applied 23340004 - ENHANCE FND_ATTACHED_DOCUMENTS2_PKG NEW COPY_ATTACHMENT API 

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!


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