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.


JD Edwards EnterpriseOne : 9.0 version, Discrete Mfg

R31410 Order Processing

Tools Version 8.98

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

The R31410 run faster

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

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


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