Script Ar120lclcsu.sql Took 32 Minutes To Complete During 11.5.10.2 To Release 12.1.1 Upgrade

(Doc ID 1573729.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Script Ar120lclcsu.sql Took 32 Minutes To Complete During 11.5.10.2 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

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