My Oracle Support Banner

E1: 31: R3190 Understanding Work Order Repost (Doc ID 1248874.1)

Last updated on AUGUST 28, 2023

Applies to:

JD Edwards EnterpriseOne Service Management - Version XE and later
JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
JD Edwards EnterpriseOne Engineer to Order - Version 8.9 and later
JD Edwards EnterpriseOne Capital Asset Management - Version 8.11 SP1 and later
JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
Information in this document applies to any platform.
R3190 - Repost Open Work Orders, R31410 - Work Order Processing, P3111 - Work Order Parts List, P48013 - Manufacturing Work Order Entry, P3009 - Manufacturing Constants, P4101 - Item Master, P4021 - Supply and Demand Inquiry, P41001 - Branch/Plant Constants, P41202 - Item Availability, P31113 - Work Order Inventory Issues, P31114 - Work Order Completions, P43250 - Receipt Routing Movement and Disposition, R43990 - Repost Open Purchase Orders, R42995 - Repost Active Sales Orders


This document discusses the functionality of the Repost Open Work Orders (R3190).  It includes screen prints of commitments and how they are updated using the Repost UBE.  Also included is a set of frequently asked questions.


The Work Order Repost (R3190) program, based on data selection, recalculates and then 'reposts' the commitment quantities in the Item Location File (F41021) by performing calculations on the current data in Work Order Parts List file (F3111) and Work Order Header table (F4801), based on the work order status specified in the processing option.  The purpose of the report is to get the quantities in various locations to be in sync with what is specified on the work order details. The open work order commitments can be incorrectly stated when a work order is closed or canceled with open quantities remaining.  It is recommended to run the R3190 repost on a regular basis to clear out these remaining commitments.

Note: R3190 does not clear anything! 

This is a common misconception of the repost process.  Repost was designed to perform a net change on F41021 quantities instead of a traditional clear and repopulate.  Consider reposting work orders to be a net change process.  The repost program is not a commitment availability engine.  If R3190 is leaving a residual value in FUN1 for a component item, it is because there are instances of that item on an active work order parts list soft committed to the primary location.  FUN1 is the work order soft commit quantity, where as PCOM is the combined WO/SO soft commit quantity.   The R3190 does a compare to update those fields in order to align them.  If the two fields (FUN1 and PCOM) are mismatched, look for sales order soft commits in addition to the work order soft commit.


This document is helpful for users of the JD Edwards EnterpriseOne Manufacturing suite of applications.  Users should be well-versed in manufacturing processes, commitment setup and implementation, and good business practices.


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
 This document discusses the functionality of the Repost Open Work Orders (R3190).  It includes screen prints of commitments and how they are updated using the Repost UBE.  Also included is a set of frequently asked questions.
 In E1 811 SP1 and above, the R3190 repost UBE is enabled for Equipment and Service orders.
 Defining the Commitment Rules
 Running Repost Commitments
 When to run Repost R3190
 What the Repost Open Quantities batch program will do
 Processing Options and Data Selection
 Processing Option for R3190
 Alphanumeric Work Order Status on an AS400
 Alphanumeric Work Order Status on Other Platforms
 Data Selection Considerations
 Repost Files and Fields
 Repost and Other Applications
 Work Order Completions using Receipt Routings
 Rate Schedules
 Service and Equipment Work Orders
 Process Manufacturing
 Frequently Asked Questions
 Question 1:  When a sales order is canceled, should the corresponding work order and its parts list be canceled, too? 
 Question 2:  Why is the R3190 batch application running extremely slowly after an upgrade to SQL?
 Question 3:  How can soft commitments be displayed after running R3190?
 Question 4:  Is it possible to run R3190 (Work Order Repost) and R3482 (MRP planning) programs simultaneously?
 Question 5:  Regarding the cutoff status code R3190 processing option, should the status in the Processing Option be greater than the status of the existing WO’s?  
 Question 6:  Is it possible to clear out the QWBO (Quantities on Work Order Receipt) quantities from F41021 table for an obsolete item using R3190 Repost program?
 Functional Test

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