My Oracle Support Banner

E1: 40: Troubleshoot F41021WF in Inventory Transaction (Doc ID 2068721.1)

Last updated on MARCH 16, 2020

Applies to:

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


The primary purpose of the workfile F41021WF is it enables user/application to rollback a certain transaction when hitting a Commit Fail error. This document is intended for the environment where you hit frequent Commit Fail error and/or discrepancy between F4111 (Item Ledger File) and F41021 (Item Location File) or growing orphaned data from F41021WF (F41021 Transaction Workfile). This document is to analyze as-is configuration and possible way to debug when you have this type of issue.

Troubleshooting Steps

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
Troubleshooting Steps
 Question 1:¬† What's table F41021WF (F41021 Transaction Workfile) for?
 Question 2: What is the relationship between F41021WF and F41021 (Item Location File)?
 Question 3: What is a transaction and commit fail error and rollback?
 Question 4: What is rollback process in system level and user interface level?
 Question 5: What is a typical auto-rollback routine?
 Question 6: Is growing data from F41021WF normal?
 Question 7: How to handle it when we determine it is orphaned data?
 Question 8: History of auto-rollback routine and it's considerations?
 Question 9: Can data from F41021WF are purged? Any concerns?
 Question 10: Example of actual transactions which affects F41021WF?
 Question 11: Business Functions related?
 Question 12: What are applications¬†which access F41021WF directly?

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