12.2.6.3 - Collections Takes Longer To Complete After Upgrade - Collecting Delivery Details Runs Long

(Doc ID 2374654.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

12.2.6.3

PROBLEM
-------------
We are in process of upgrading from 12.2.5 to 12.2.6.3.
When compared pre-upgrade, and after the upgrade, we are seeing the Planning Data Pull runtime has increased
Planning ODS Load also takes longer.

We isolated the long running process in the Planning Data Pull log file as

09-MAR 09:12:51 : Task Number is 62
09-MAR 09:12:51 : Global RN (msc_cl_pull.v_lrn): -1
09-MAR 09:12:51 : Procedure LOAD_DELIVERY_DETAILS started.
09-MAR 09:12:51 : Loading Delivery Details
09-MAR 09:29:16 : 16.5 minutes elapsed.

And in ODS Loader Worker Log file

09-MAR 09:43:05 : Procedure MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS started.
09-MAR 10:30:49 : Alter table: ALTER TABLE MSC.DELIVERY_DETAILS_VCP LOGGING
09-MAR 10:30:49 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_2021 WITH TABLE DELIVERY_DETAILS_VCP WITHOUT VALIDATION
09-MAR 10:32:18 : Submitted CP for purge MSC_TRANSPORTATION_UPDATES. 16102357
09-MAR 10:32:18 : 49.3 minutes elapsed.

When checking the WSH_DELIVERY_DETAILS count on the source side.
ERPPROD: 42,676,994  - 12.2.5
ERPDEV: 42,318,541 - 12.2.6.3

The count of MSC_DELIVERY_DETAILS... It is large difference between the PROD and DEV.
VCPPROD: 510,611 records  - 12.2.5
VCPDEV: 40,843,257 records - 12.2.6.3


STEPS
--------
Normal daily data collections with complete refresh


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