My Oracle Support Banner

R12 E-Business Suite Applications DBA Patching Performance Issue With File afatch.odf During Column Conversion From Long To Clob For Table FND_DOCUMENTS_LONG_TEXT Column LONG_TEXT (Doc ID 2568161.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Oracle Applications DBA - Version 12.1.3 to 12.2 [Release 12.1 to 12.2Cloud]
Information in this document applies to any platform.


E-Business Suite R12 Applications DBA, Patch Application related issues






During a patch installation file afatch.odf causes a performance issue at statement "ALTER TABLE APPLSYS.FND_DOCUMENTS_LONG_TEXT MODIFY (LONG_TEXT CLOB)".

When running the file afatch.odf the patch appears to hang, but instead it is running slow due to conversion of a column from long to clob.

For example during the installation of <Patch 26728355:R12.ATG_PF.B>, heavy pl/sql activites can be observed if the table FND_DOCUMENTS_LONG_TEXT has a significant number of records.



 Apply <Patch 26728355:R12.ATG_PF.B>


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

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