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 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.

Symptoms

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.

Cause

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