My Oracle Support Banner

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

Last updated on MARCH 17, 2021

Applies to:

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

Symptoms

On : 12.2.9 version, Open Interfaces

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.

Customer run stats hourly by cron job so that's not the issue, either.


EXPECTED BEHAVIOR
-----------------------
WIP Mass load should complete without delays.


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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create new jobs as planning is halted due to the issue.

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.