Upgrading From 11i To R12.2 and Running into Performance Issues with Jlzzmigawtdist.sql (Doc ID 1674542.1)

Last updated on JULY 09, 2017

Applies to:

Oracle Financials for the Americas - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1 version, Argentina Payables

You are upgrading from 11i to R12.2 and are having a performance issue with jlzzmigawtdist.sql 120.26.

Steps to Reproduce:
Run 12.2 migration steps on Test environment.
Performance issues with jlzzmigawtdist.sql 120.26 (latest version) while upgrading from 11i to R12.2.

The migration script jlzzmigawtdist.sql is taking too much time to run.  It should be parallelized to run in several adworkers.
It took almost 5:30 to run is a test environment (former prod hardware).

The script is performing a single INSERT-SELECT, it's not parallelized to run in several adoworkers, which should be better.

The query is joining the following two tables, if split, it should reduce run time.

AP_INVOICE_DISTRIBUTIONS_ALL: 41,479,662 rows
JL_ZZ_AP_INV_DIS_WH_ALL_T: 55,346,849 rows

The whole migration process took around 98hs, so this single script took 5% of the time.
Even though it ran ok, it's too much time in a single step that perhaps can be shorten.

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