My Oracle Support Banner

E1: 43: Cache/Work File (workfile) in Procurement (F4301Z, F4311Z, F43121Z, F4314Z) (Doc ID 1463725.1)

Last updated on APRIL 25, 2023

Applies to:

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


 This note is to discuss cache and workfile in EnterpriseOne procurement. This note is a trouble shooting guide when the issue is coming from cache or work file.

Document discusses Work Files in Procurement (F4301Z, F4311Z, F43121Z and F4314Z) based on the list of applications below,

Note that Purchase Order can be created/updated through multiple applications (including Sales and Manufacturing and so on). For this example, any routine which writes F4301 (Purchase Order Header)/F4311 (Purchase Order Detail) are defined as purchase order.

In creating Purchase Order, temporary tables (namely Work File/Workfile/WF) such as F4301Z (PO Header Work File), F4311Z (Purchase Order Generator File), F43121Z (Receiver workfile) and F4314Z (Voucher Match Selection File) can be used to hold data temporarily before it gets committed to Purchase Order Header/Detail, PO Receipt and Voucher Match.

In this note, workfile/work file stands for physical tables whereas cache stands for memory/cache or data structure. In purchase order processing cache is to be used heavily because (as temporary table stored value for limited times) cache can be referenced in any other form/application till it gets terminated.

Unlike Sales Order, only P43060 (Order Release/Generate) has implementation to write work file to support consolidation (because lines can not be consolidated with cache). However R4311Z1I (PO Unedited Transaction Inbound Processor) shall not utilize work file unlike R47010 (EDI Inbound Purchase Order Edit/Create). In your running P43060 if you specify line consolidation option, which writes F4301Z/F4311Z.

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 are the temporary tables used in processing Procurement?
 Question 2 : Why are temporary tables used in Processing Purchase Order?
 Question 3 : How does system determine whether to write cache or workfiles (work files)?
 Question 4:  Is there a diagram to represent the flow of data through voucher match?
 Question 5:  If there is data in these tables can it be purged?
 Question 6 : Can the parameters to write to cache or a workfile be changed?
 Question 7 : Table (Data) Structure has been changed through baseline ESUs, what is the follow-up action?
 Question 8:  Which applications can create a purchase order?

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