My Oracle Support Banner

E1: 41: How to Create Item Master and Item Branch Plant Records Using Interoperability (R4101Z1I/P4101Z1/F4101/F4102/F4101Z1) (Doc ID 625451.1)

Last updated on JANUARY 14, 2021

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version XE and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version XE and later
JD Edwards EnterpriseOne Inventory Foundation - Version XE and later
JD Edwards EnterpriseOne Service Management - Version XE and later
JD Edwards EnterpriseOne Sales Order Management - Version XE and later
Information in this document applies to any platform.

Purpose

General Information

This document provides details on how to create Item Master and Item Branch Plant records using Interoperability.

The definition of Interoperability is enabling applications and technologies to allow one system to share data and/or logic with another system. It is often used to transfer large amounts of data from one system to another. The Item Master (F4101) is used to record information about stock items. Interoperability is a tool provided in EnterpriseOne enables the mass upload of multiple items from an external system into EnterpriseOne inventory tables. Depending on the release of EnterpriseOne being used, Item Branch Plant records may also be added. This process can be used for migration (importing) a large number of records.The Item Master Inbound Transaction Process allows the upload of Item Master (F4101) and Item Branch Plant (F4102) records into the system.

Note: Item Branch Plant (F4102) records can also be created, but the process must then be run twice: once for the Item Master (F4101) record creation and then run a second time for the Item Branch Plant (F4102) record creation.

Manufacturing Note: Prior to using Manufacturing programs, it is necessary to run the Integrity Analysis program (R30601) to properly set low level codes based on Bill of Material (BOM) levels. Not doing so will result in program failures due to duplicate record errors. When creating items using P41026, the Item Branch Plant records (F4102) Low Level codes are set to“1”. Using Interoperability, R4101Z1i, the Item Branch Plant records (F4102) Low Level codes are set to“0”. If the Integrity Analysis program (R30601) indicates errors, correct the processes or BOM's and run the Integrity Analysis program again. When the program does not find errors in the processes, it updates the low-level codes (IMLLX) in both the Item Master (F4101/LL CD column) and the Item Branch File (IBLLX- F4102). Low-level codes are commonly referred to as LLX, IMLLX, IBLLX, or lower level codes.

Scope

 

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
 General Information
Scope
Details
 Flat File Information
 Outbound Transactions
 Outbound Item Master record
 Outbound Item Branch record
 Inbound Transactions
 The Item Master (F4101) Creation Process
 Populating the F4101 Item Master Unedited Transactions (F4101Z1) manually for the Item Master (F4101) records
 Executing the Item Master Inbound Transaction Process (R4101Z1I) in order to create the Item Master (F4101) records
 The Item Branch Plant (F4102) Creation Process
 Frequently Asked Questions
 Question 1: What is F4101Z1A used for in the Item Master and Item Branch Inbound Transaction Process (R4101Z1I)?
 Question 2: How are the Batch Number (EDBT) and Transaction Number (EDTN) fields populated in the screen? Where is the next number of these fields stored?
 Question 3: Is there a purge UBE to remove the records From F4101Z1 (F4101 Item Master Unedited Transaction table)?
 Question 4: Can the Z file process (R4101Z1I Item Master Unedited Transactions Process) be used to upload Non-Stock items?
 Question 5: We are populating the field "Commodity Code" in Inbound Item Master (Work With F4101Z1 Item Master Revisions) (P4101Z1) for a non-stock item, but this value is not uploaded in "Commodity Code" field from P4101N Work With Non-Stock items after running successfully R4101Z1I. Why is the Commodity Code field not uploaded?
 Question 6: Tried to run Item Master Unedited Transaction Inbound (R4101Z1I) program, but Work Center is sending the error "Quantity Invalid".
 Question 7: Is it possible to use the interoperability process to create Kit Parent item master records? A work center error message is received when attempting to process a stock type 'K' item, which states 'Blanks Invalid'.
 Question 8: When creating Item Branch/Plant records using the R4101Z1I program, an error Invalid Location is received.  The location exists in the F4100 table.  What could be causing this?
 Question 9: Is it possible to create secondary locations using R4101Z1I? Also, is it possible to create a primary location for already existing Item Branch/Plan records?
 Question 10: Why does R4101Z1 not generate an item master record, even though the pdf output shows the record was processed without error?
 Question 11: What are the mandatory fields required for importing a dual UOM item?
 Question 12: What is the use of the SUTM field (Unit of Measure - Stocking) in the Item Master table (F4101)?
References

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