My Oracle Support Banner

WIP Mass Load Performance Is Bad Only For Source_code=MSC (Doc ID 2713139.1)

Last updated on FEBRUARY 16, 2024

Applies to:

Oracle Work in Process - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

While performing WIP Mass Load, performance issues are observed as the requests never complete.

This issue is ongoing for weeks and customer cannot keep splitting batches manually any longer.

Even after doing a major purge of the WIP interface tables, there is zero effect on run time.


STEPS

The issue can be reproduced at will with the following steps:
1. Run WIP Mass load with batches with source_code of MSC.
2. Request will not complete after 5 or more hours.


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
Cause
Solution
References


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