My Oracle Support Banner

E1: 31A: P31022 Using the Production Cost Inquiry (F3102) (Doc ID 1392226.1)

Last updated on MARCH 13, 2023

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
Information in this document applies to any platform.


This document explains the Production Cost Inquiry (P31022) based on the F3102.  The Variance File (F3102) tracks variances by work order and provides information from a costing and cost variance perspective.   The F3102 is the source for variance journal entries (R31804).

This document explains how each named variance is created and calculated.


The Production Cost Inquiry program (P31022) displays the costs and variances that are associated with manufacturing work orders or rate schedules. It was not designed to work with other modules, like Capital Asset Mgmt (P48211), or Service Mgmt (P17714), but those programs associated with Manufacturing only.

Note:  If using Cost by Work Center

1.  Activate the Cost by Work Center option in the Manufacturing Constants program (P3009)

2.  Define cost components by work center

P31022 will display the cost information by work center and subtotals by cost components for the work centers in which they occur.

You can review variances by comparing amounts that the system calculated in one mode to amounts that the system calculated in another mode. Modes include: Standard, Current,    Planned, Actual, Completed and Scrapped


Users who need to track work order costs, work in progress, and variances can use this inquiry.


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
 Column Names, Aliases and Calculations
 Unit Calculations
 Amount Calculations
 Work in Process
 Engineering Variance
 Planned Variance
 Actual Variance
 Other Variance
 Production Cost Inquiry Details (P31022)
 Selection Criteria Tab
 Display Tab
 Columns Tab
 Display after WO Header is Created & Parts List/Routing attached
 After Material Issues & Hours & Quantities
 After a Work Order Completion
 Work Order with X Costs
 Frequently Asked Questions
 Question 1: How is the Current cost calculated when the 'Copy from WO' option is used to copy a parts list from an existing Work Order?.
 Question 2: At what stages in the manufacturing cycle is the Production Cost file F3102 updated?
 Question 3: Why are the Variable and Fixed Labor (C1-C4) Units and Amounts not populated after the Routing is attached to a work order?
 Question 4: How can the source of the A1 variance be seen in the P31022?
 Question 5: What scenario would cause a Blank Cost Type, Blank Standard Amount, and Blank Current Amount in the P31022 / F3102?
 Question 6: How are the F3102 MCU and MMCU fields populated?

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