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