My Oracle Support Banner

E1: 31: R31122Z1I Work Order Time Entry Interoperability (Doc ID 882032.1)

Last updated on APRIL 17, 2023

Applies to:

JD Edwards EnterpriseOne EDI - Version XE and later
JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
Information in this document applies to any platform.
System Code: 31-Shop Floor Management
P311221 - Work Order Time Entry
P31122Z1 - Work Order Time Transactions Unedited Transaction Table
R31122Z1I - Hours and Quantities Inbound Processor
P3009 - Manufacturing Constants
F31122 - Work Order Time Transactions Table
F31122Z1 - Work Order Time Transactions Unedited Transaction Table
F4801 - Work Order Master Table
F3112 - Work Order Routing File
UDC 00/DT - Document Types, UDC 31/TY - Type of Hours, UDC 06/SH - Payroll Shift Codes


This document is part of an Information Center - to see other documents related to Shop Floor Control, please use the link provided:Information Center: JD Edwards EnterpriseOne Shop Floor Control > Information Center: Using JD Edwards EnterpriseOne Shop Floor Control > Note 882032.1

The purpose of this document is to explain the use of interoperability Work Order Time Entry for Inbound and Outbound transactions. It explains basic setup - control columns, required data columns and frequently used optional data completions to be populated to complete the transactions.

The inbound transaction records are used to update EnterpriseOne tables with work order time entry information.
The outbound transactions are used to generate records that can be used by a third party to update their system with the work order time entry details.
Both inbound and outbound transaction types support additions only.


Most users of Shop Floor Control module will find this functionality useful.


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
 Purpose of Transactions
 Transaction-Specific Instructions
 Inbound Transactions - Table F31122Z1
 Control Columns
 Required Data Columns
 Frequently Used Optional Data Columns
 Control Columns
 Processing Hours and Quantities (R31122Z1I)
 Frequently Asked Questions
 Question 1. Why does the R31122Z1I not update the PRTR field in table F31122 even though PRTR has a valid value in the table F31122Z1?
 Question 2. Why EDSP flag in the F31122Z1 file is not updated to 'Y' if the R31122Z1I job completes normally?
 Question 3. After running R31122Z1I for inbound hours and quantities, why isn't the work order status updating?
  Related Knowledge Content

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