My Oracle Support Banner

E1: 41: Inbound Cycle Count Interoperability (P4141Z1 / R4141Z1I / R4141Z1P) (Doc ID 625452.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

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 Inbound Cycle Count Process can be used to upload information about the actual number of items that are in the inventory at a specific point, into the Cycle Count Transaction File (F4141) and Cycle Count Header (F4140) tables.

  Menu:

 Interface Tables:

The Cycle Count Header (F4140) file stores the Cycle Count Number, Description, Cycle Count Status and the Count Date. As per Bug 11010903: R4141Z1I NO CYLO OR CYIT - SAR: 8929011, it should also store information on the Number of Items selected (CYIT) and Number of Locations selected (CYLO).

The Cycle Count Transaction (F4141) file is shared by both the Cycle Count and the Tag Count programs. It holds information about the items selected for count, including the on-hand value currently in the Item Location (F41021) file. This on-hand value is "frozen" because once the Cycle Count Transaction (F4141) records are created, they do not change regardless of inventory transactions, sales or receipts that occur in the system.

This process can only be used to create secondary locations for items for which primary locations already exist.  It is not possible to load all the item locations for a new item and branch using this process.  Error 2895 - Cannot add Secondary Without a Primary will be encountered during Cycle Count Update (R41413) if the item does not already have an existing primary location defined.

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
Scope
Details
 Flat File Information
 The Inbound Cycle Count Process
 Minimum Required Fields in the Cycle Count Unedited Transaction table (F4141Z1)
 Example
References

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