Oracle E-Business Suite Recommended Performance Patches (Doc ID 244040.1)

Oracle E-Business Suite Recommended Performance Patches The latest version of this document can be found in My Oracle Support Document "Oracle E-Business Suite Recommended Performance Patches (Document 244040.1)" This document contains a list of performance-related patches that Oracle E-Business Suite Performance Group recommends should be applied. The most current version of this document can be obtained in My Oracle Support Knowledge Document 244040.1. There is a change log at the end of this document. In This Document This document is divided into the following sections: Overview Section 1: Database and Technology Patches Section 2: Applications Technology Patches Change Log Note: To receive automatic notifications of updates, subscribe to the Hot Topics Notification feature in My Oracle Support, as described in Document 793436.2, How to use Hot Topics Email notification to subscribe to Support Product News, SRs, Bugs, etc. and events so that you Never Miss an Important Update. Overview You should go through these lists and identify the patches that are applicable to your environment and current patch level. In addition to these patches, you should ensure that you have applied all the patches recommended in the relevant Oracle Database certification knowledge documents available on My Oracle Support. Be aware of the following important points: Patches may not be available on all platforms. If you are encountering a Documented issue and a Patch is not available on your platform, please contact Oracle Support. See bugs and patch readmes for further information on the problem and solution. Patches related to Upgrade are listed in "Outstanding Performance Bugs, Issues and Solutions during Upgrade (Document 2357810.1)". Section1: Database and Technology Patches Most database and technology bugfixes and recommended default patches are listed in "Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Document 1594274.1)". However, this section will contain bugfixes that impact the performance of Oracle E-Business Suite Release 12.2, that are not yet included in Document 1594274.1 Unless otherwise noted, the patch number is the same as the bug number. Product Affected versions Bug No. Bug Desc Further description of issue resolved My Oracle Support document Oracle Database 11.2.0.4 to 12.1.0.2 Bug 17305006 SEVERE PERFORMANCE SLOWDOWN WHEN RESULTS CACHE IS THRASHING See: Document 17305006.8 Document 1588763.1 Oracle Database 11.2.0.4 to 12.1.0.2 Bug 22146267 TRACKING BUG TO ADD DIAG PATCH PROVIDED IN 21953328 See Document 2097725.1 Oracle Database 12.1.0.2 Bug 26436717 RESULT CACHE: "BYPASS OBJECTS" INCORRECTLY USED BY WAITING PROCESSE See: Document 26436717.8 Document 2256587.1 Section 2: Applications Technology Patches Module Patch Patch Desc Orig Bug (If Diff) Further description of issue resolved My Oracle Support document Included Since AD Patch 16400364:R12.AD.C INT1224.3:QREP:AIX:WIN:HPIPF:SOL:REPLICATE SEED DATA RUNNING FOR LONG TIME See Document 2003758.1 R12.AD.C.delta.6 AD Patch 17862026:R12.AD.C QREP1223.5:ADPATCH HANGS WHILE GENERATING CUSTOMALL.JAR IN NON-INTERACTIVE MODE See Document 1987831.1 ADPATCH hangs, while applying a patch containing jcopy actions, in non-interactive mode on windows platform. R12.AD.C.delta.7 AD Patch 19477748:R12.AD.C DURING 12.1.3 TO 12.2.3 UPGRADE, HIT PERFORMANCE ISSUE ON DBA_EDITIONING_VIEW_CO When generating EV for the same table, The SQL query (Sql ID: 55rgk1744skh4) in AD_ZD_TABLE.GENERATE_EV takes time even STATS on dictionary tables are present. R12.AD.C.delta.6, DBA CUP6 AD Patch 19543460:R12.AD.C R1222: STANDALONE READINESS REPORT AND GLOBAL STANDARDS COMPLIANCE CHECKER (GSCC) Bug 19566604 ADZDPMAN.sql long running (in SECTION-8 (MANUAL FIX: Base Column Names may only use '#' as last character). R12.AD.C.delta.6 AD Patch 20208298:R12.AD.C ADOP CUTOVER VERY SLOW AFTER APPLICATION OF LATEST NOVEMBER TXK AND AD PATCHES CUTOVER_INDEXES API taking time in table manager. Full table scan on dictionary tables. R12.AD.C.delta.6 AD Patch 27098139:R12.AD.C Performance fix to adgrants.sql Bug 26612557 adgrants.sql long running. SQL "SELECT count(1) from dba_tab_privs where ...." executes large number of times in loop and is inefficient. R12.AD.C.delta.11 Patch 29273993: AD CONSOLIDATED PATCH II ON TOP OF DELTA 10 AD Patch 28986462:R12.AD.C ACTUALIZE_ALL CAUSING CONCURRENCY LOCKS ACTUALIZE_ALL long running. Contention (concurrency events) seen in run edition during actualize_all on patch edition. R12.AD.C.delta.11 Patch 29273993: AD CONSOLIDATED PATCH II ON TOP OF DELTA 10 BNE Patch 24411756:R12.BNE.C 1OFF:19954813:EXCEL INITIALIZATION RUNS FOR TOO LONG, CT HOPE IT COMPLETES ABOUT Bug 19954813 Exports of items in PIM Item to excel takes long time. 12.2.7 RUP FND Patch 16579895:R12.FND.C GETTING SESSION INFORMATION IS CONSUMING HIGH CPU Bug 16495843 A simple 'is trace enabled' function initializes several package variables on each call. Also, Init code called every time package is initialized even if the init code values are unnecessary (trace is not enabled). 12.2.4 RUP FND Patch 17955567:R12.FND.C 1OFF:12.2.3:FND_FLEX_HIER_COMPILE_ALL.SQL RUNNING SLOW Changes for ER 10016213 resulted in LOV was moved to the back end to pre process all valid values and store in a new table. This new table is populated when the hierarchy compiler is run. Because the compiler has to process all the data at one time rather than based on responsibility, performance can be poor. 12.2.5 RUP FND Patch 19001790:R12.FND.C SWITCHING RESPONSIBILITIES (TOP HAT) TAKES LONG TIME FOR SOME USERS See Document 2000591.1 Long running SQL "SELECT .... FROM FND_RESPONSIBILITY_VL R, FND_USER_RESP_GROUPS U, FND_SECURITY_GROUPS_VL S WHERE ..." 12.2.5 RUP FND Patch 19375417:R12.FND.C 1OFF:12.2.3:FND_FLEX_HIER_COMPILE_ALL.SQL RUNNING SLOW Process long running during patch, so moved to run as a concurrent request (in background). 12.2.5 RUP, 12.2.0 CUP6 FND Patch 19891697:R12.FND.C 1OFF:12.2:PERFORMANCE PROBLEMS RESULTS SET CACHE FND_PROFILE package is making redundant use of the RESULT CACHE directive filling up RC space and causing high 90% RESPONSE TIMES 12.2.5 RUP In: Patch 31563978:R12.FND.C FND Recommended Patch Collection (8/2020) Patch 26560435:R12.FND.C FND Recommended Patch Collection (12/2017) Patch 25796137:R12.FND.C FND Recommended Patch Collection (4/2017) FND Patch 20213516:R12.FND.C QRE1225.2:GSI: LONG RUNNING : FND :AFUPDFMT.SQL (2 HRS: 29 MINS) Bug 17001252 Long running if large amount of data in FND_LOBS table. File stubbed. For R12 the FND_LOBS records should be correctly set and not require the file_format be updated/corrected and the index be required to be dropped/rebuilt. 12.2.5 RUP In: Patch 31563978:R12.FND.C FND Recommended Patch Collection (8/2020) Patch 26560435:R12.FND.C FND Recommended Patch Collection (12/2017) Patch 25796137:R12.FND.C FND Recommended Patch Collection (4/2017) FND Patch 20751767:R12.FND.C LOCKING ON FND_LOGINS WHEN LOGGING IN AND OUT WITH MULTIPLE USERS See: Document 2078703.1 Document 1938090.1 Document 2079471.1 12.2.6 RUP Supercedes: Patch 20439180:R12.FND.C Patch 18903648:R12.FND.C FND Patch 21612876:R12.FND.C 1OFF:12.2.4:CONSOLIDATED PATCH/CROSS VALIDATION PERFORMANCE ISSUES Long running when there are large numbers (thousands) of CVR rules. Number of code combinations has an impact too. 12.2.6 RUP In: Patch 31563978:R12.FND.C FND Recommended Patch Collection (8/2020) Patch 26560435:R12.FND.C FND Recommended Patch Collection (12/2017) Patch 25796137:R12.FND.C FND Recommended Patch Collection (4/2017) FND Patch 23186361:R12.FND.C PERFORMANCE ISSUES AFTER APPLYING PATCH 20085935 See: Document 2301460.1 Document 2162364.1 12.2.6 RUP FND Patch 25571587:R12.FND.C USER-LEVEL LOCKS ARE GETTING CREATED WHILE RUNNING LDT FILES These were often from the triggers used to mark changed records (e.g. on FND_MENU_ENTRIES). 12.2.9 RUP FND Patch 25878814:R12.FND.C FND_FUNCTION COMPILE - PERFORMANCE ANALYSIS On Function compile_menu_all ( FND_FUNCTION ) 12.2.9 RUP FND Patch 25911647:R12.FND.C 1OFF:12.2.4:PERFORMANCE ISSUE WITH CROSS VALIDATION ENTERING A DISTRIBUTION CHARGE Bug 25911647 Bug 27697277 When entering a distribution charge code against a purchase order line. 12.2.9 RUP FND Patch 28141361:R12.FND.C RESOURCEAUDIT ISSUES Connection leak when enabling the auditing in 12.2.7. Calls being made for each resource accessed, causing large number of connections, rapidly exceeding limits. See Document 2465067.1 12.2.9 RUP FND Patch 28978298:R12.FND.C 1OFF:12.2.4:AFTER 27697277 CVR Validation hangs from client side Forms are hanging when cross validation is enabled on Client side. See Document 2492829.1 12.2.9 RUP FND Patch 29389395:R12.FND.C AOLJ CODE NOT HONOURING CONN LABELS(IN WLS POOL MECHANISM) LEADING TO IMPROPER TRIGGERING OF SERVER SIDE INITIALIZATIONS See Document 2538442.1 12.2.9 RUP In: Patch 31563978:R12.FND.C FND Recommended Patch Collection (8/2020) FND Patch 29810066:R12.FND.C 1OFF:29340625:CONNECTION LEAKS @ ORACLE.APPS.FND.SECURITY.RESOURCEAUDIT$RECORD.R Bug 29340625 @ ORACLE.APPS.FND.SECURITY.RESOURCEAUDIT$RECORD.RUN(RESOURCEAUDIT.JAVA:358) 12.2.9 RUP FND Patch 30134567:R12.FND.C DO NOT STORE LAST SESSION LANGUAGE FOR GUEST USER Bug 29338316 See Document 2578726.1 12.2.10 RUP FND Patch 30486363:R12.FND.C TRACE NOT GETTING GENERATED FROM APPLICATION IF TRACE_FILE_IDENTIFIER IS TOO LONG. See: Document 2700633.1 Document 2707712.1 12.2.10 RUP FWK Patch 20784744:R12.FWK.C VO QUERY GETTING FIRED MULTIPLE TIMES FOR THE SAME BINDS In PPR and apply action on one of product page. 12.2.6 RUP FWK Patch 20810195:R12.FWK.C FWDPORT:20028688:PERFORMANCE ISSUE WITH PATCH 18388305 See Document 2044087.1 12.2.6 RUP FWK Patch 21501307:R12.FWK.C RICH TABLE INTERACTIONS AFFECT THE PERFORMACE BY EXECUTING BLIND QUERY Views created by the personalization handler are causing the views panel of query beans to execute blind queries even when the query bean has a selective search criteria defined. 12.2.6 RUP OWF Patch 23729834:R12.OWF.C 1OFF:12.2.3:[WORKFLOW BACKGROUND PROCESS] IT TAKES SOME HOURS TO RUN FNDWFBG FNDWFBG long running when parameter "Process Stuck = Y". Due to SQL query "SELECT ... FROM WF_ITEM_ACTIVITY_STATUSES WIASP, WF_ITEMS WI, WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP WHERE ... " 12.2.9 RUP TXK Patch 20300514:R12.TXK.C ADOP CUTOVER WONT HAPPEN IN MORE THAN 10 NODES MULTI-NODE See Document 1986770.1 R12.TXK.C.DELTA.6