12.2 E-Business Suite Workflow Script Wfdsadnt.sql And Eccppg.ldt Performance Is Poor Or Script Hangs When Applying Patch 21900895 Requiring More Undo Space Related To Call WF_DIRECTORY.Add_Language
Last updated on DECEMBER 15, 2017
Applies to:Oracle Workflow - Version 12.2.6 and later
Oracle Applications DBA - Version 12.2.6 and later
Information in this document applies to any platform.
E-Business Suite 12.2 Workflow, Patch Application related issues
Users report the installation of ATG Delta 6 <Patch 21900895> hangs or performance is very slow.
Monitoring the patch session the following scripts are consuming significant resources and using all available undo space:
For example in one case running the above two files required 18gb of undo space for wfdsadnt.sql, and 4gb undo space for eccppg.ldt.
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