My Oracle Support Banner

E1: 31: R31114Z1I Work Order Completions Interoperability (P4801Z1/R4801Z11X)) (Doc ID 1151860.1)

Last updated on AUGUST 01, 2018

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
Information in this document applies to any platform.
R31114Z1I - Inventory Completion Inbound Processor, P4801Z1 - Outbound Work Order Revisions, Outbound Work Order Header interface (F4801Z1), Outbound Work Order Extraction (R4801Z1X), Inbound Completion Purge (R4801Z1), P31114 - Work Order Completions, F4801Z1 - Outbound Work Order Header Table, F4801 - Work Order Master File, F4111 - Item Ledger File, F41021 - Item Location File



Purpose

This bulletin is a supplement to existing documentation and its purpose is to explain the use of the Interoperability (Z file processing) for Work Order Completions for Inbound and Outbound transactions.  It explains basic setup and required fields to complete the transaction.

It also includes detailed instruction on how to perform full or partial Work Order Completions using the Inventory Completion Inbound Processor (R31114Z1I).
On the inbound side, this transaction is used to update EnterpriseOne tables with work order completion information.
On the outbound side, this transaction is used to generate records that can be used by a third party to update their system with the work order completion information.

Overview

Work Order Completion transactions are used to record the completion of item production to the inventory in the system.

On the inbound side, this transaction is used to update EnterpriseOne tables with work order completion information.

On the outbound side, this transaction is used to generate records that can be used by a third party to update their system with the work order completion information. 

The permanent E1 tables primarily affected by this transaction are the Work Order Master File (F4801), the Item Ledger File (F4111), and the Item Location File (F41021).

The Inbound Completions Processor (R31114Z1I) can only be used to Update an existing Work Order Header record, not Add.  Attempts to add or convert from F4801Z to F4801 will fail and result in Error: Work Order Number Invalid Cause: The Work Oder Number entered odes not exist in the Work Order Master file (F4801).

There is no Inbound functionality to create Work Order Headers (F4801).  As stated in E1: 31: Importing Work Orders into JDE and Updating WO Status, Parts Lists & Routings Document 629428.1 under Overview,

[... The P4801Z1 application cannot be used for uploading inbound work order (WO) headers from an external system, as there are no interoperability tables to pull in work order header details.  Inbound interoperability is not supported for any of the work order records stored in F4801 since the Work Order Document Number (DOCO.F4801) is the primary key to the file and there is not a way to synchronize the incoming numbers with JDE Next Numbers.  Redesign is not planned. ...]

Refer:

Bug 10947926 INBOUND WORK ORDER DOES NOT E - SAR: 8351091 (Closed, not feasible to fix).

Also E1: INTEROP: Interoperability Interface Tables in EnterpriseOne Document 1275030.1, for the Inbound/Outbound capabilities of existing interoperability programs.

Workaround

Users may consider using inbound F3460 MRP Order Messages, and processing those to generate work orders.

Scope

Shop Floor Control users will find this bulletin useful when using the R31114Z1I interoperability functionality.

Details

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
 Overview
Scope
Details
 Relationships to Other Transactions
 Transaction-Specific Instructions
 Inbound Transactions - Outbound Work Order Header (F4801Z1) Table
 Control Columns
 Required Data Columns
 Frequently Used Optional Data Columns
 Processing Inventory Completions - R31114Z1I
 Viewing Records
 Outbound Transactions - Table F4801Z1
 Performing full or partial Work Order Completions using Inventory Completion Inbound Processor (R31114Z1I)
 Is there a way to have the UBE process data as follows?
 Solution for XE and ERP 8
 Solution for 8.9 onward
 Frequently Asked Questions
 Question 1:  Is it possible to record completions with backflush using Interoperability?
 Question 2:  Can completions be reported with R31114Z1I for process manufacturing?
 Question 3:  Is it possible to complete serialized parent items via R31114Z1I such as automatically issuing the related serialized components?
 Question 4:  Is it possible to record completions for Rate Schedules using the R31114Z1I processor and generate License Plate numbers in the same time?
 Question 5:  WO number defaulting as the Lot Number regardless of lot number entered in Inbound Completion (P4801Z1) Lot Serial Number (LOTN) field?
 Question 6:  What happens when the Work Order Lot and Location Defaults processing option is blank?
References

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