Last updated on MARCH 08, 2017
Applies to:Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
Script Ar120lclcsu.sql Took 32 Minutes To Complete During 18.104.22.168 To Release 12.1.1 Upgrade
SGS use ARLCUPB.pls version 120.12.12010000.2
SGS use ar120lclcsu.sql version 120.2
This accounts for almost all the elapsed time and has a very inefficient execution plan.
There is a full table scan HZ_CUST_SITE_USES_ALL CSU in the inline view L
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms