My Oracle Support Banner

E1: 46: Inventory Balances in F4602 and F41021 (Doc ID 625720.1)

Last updated on AUGUST 31, 2022

Applies to:

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



When setting up the Warehouse Management System, in addition to the Item Location file (F41021) that keeps information related to item inventory balances, the warehouse module uses also the Location Detail Information file (F4602). The purpose of this additional file is to keep the inventory balances at a more detailed level, including information related to item unit of measure structure and capacity requirements, which is not available in F41021. The integrity between these tables should be monitored on a regular basis. This paper documents how the two files are updated during the most common transactions in Advanced Warehousing.


 This document provides an overview of how the on-hand quantities are updated in the Location Detail Information file (F4602) and Item Location file (F41021), when using the Warehouse Management System.


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
 Inventory Commitments with Warehouse Management System
 Test Scenarios
 Picking and updates to F41021 and F4602
 Replenishment and updates to F41021 and F4602
 Putaway and updates to F41021 and F4602
 Hard committing at sales order entry

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