E1: 31: Open Select Statements Generated by R31410 Causing Performance Problem (Doc ID 1618706.1)

Last updated on FEBRUARY 01, 2016

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Symptoms

JD Edwards EnterpriseOne : 9.0 version, Discrete Mfg

R31410 Order Processing

Tools Version 8.98

ACTUAL BEHAVIOR
---------------
R31410 is running longer than expected

New line of items are introduced and many more work orders are created for smaller amounts. This makes it necessary to run the R31410 over larger batches (more work orders). Before a couple of work orders would run in 2 minutes time at most but now 6-7 work orders can run in 22 minutes


EXPECTED BEHAVIOR
-----------------------
The R31410 run faster

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run R31410 over 6-7 work orders to hard commit the inventory and print work order

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The rest of the shop floor cannot conduct other jobs when the R31410 is running

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