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 FEBRUARY 15, 2023
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.
Symptoms
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.
Changes
Apply <Patch 26728355:R12.ATG_PF.B>
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 |
Changes |
Cause |
Solution |
References |