My Oracle Support Banner

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 (Doc ID 2336778.1)

Last updated on FEBRUARY 06, 2019

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:

1. eccppg.ldt
2. wfdsadnt.sql

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.


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.