My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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 adworkers, which should be better.

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

AP_INVOICE_DISTRIBUTIONS_ALL
JL_ZZ_AP_INV_DIS_WH_ALL_T

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.