Oracle EBS WIP Accounting Class Reference
A WIP accounting class decides where the cost of a job is accumulated and where its variances go. Choosing the wrong class is a common cause of confusing WIP and variance balances in Oracle EBS.
| Item | Group | Applies to | Description |
|---|---|---|---|
Standard Discrete | Class type | Standard production jobs | Normal manufacturing jobs that build inventory assemblies, costed to WIP and variances. |
Repetitive Assembly | Class type | Repetitive schedules | Used for line-based repetitive production rather than individual jobs. |
Asset Non-standard | Class type | Non-standard jobs for assets | Rework, refurbishment or asset-capitalised work, with costs capitalised. |
Expense Non-standard | Class type | Non-standard expense jobs | Maintenance, prototype or R and D work where cost is expensed on close. |
Material account | Valuation account | All production classes | Holds the cost of components issued to the job. |
Material overhead account | Valuation account | Standard Discrete, Repetitive | Holds material overhead absorbed on component issues. |
Resource account | Valuation account | All production classes | Holds labor and machine charges applied to the job. |
Overhead account | Valuation account | All production classes | Holds resource and department overhead absorbed. |
Outside processing account | Valuation account | All production classes | Holds the cost of outside processing operations. |
Material variance account | Variance account | Standard costing | Receives the difference between actual and standard material usage and cost. |
Resource variance account | Variance account | Standard costing | Receives resource rate and efficiency variance. |
Overhead variance account | Variance account | Standard costing | Receives over or under absorbed overhead. |
Outside processing variance account | Variance account | Standard costing | Receives variance on outside processing charges. |
Standard cost variance account | Variance account | Standard costing | Receives variances from standard cost changes on WIP. |
The available account fields differ by costing method and release. Account defaults are set per organization in WIP Accounting Classes, and jobs inherit them at creation. Verify the exact field names on your instance.
WIP variance review
Optional: we can analyze job variance data from your EBS system and explain the largest drivers.
Optional. The tool and every export work without this. No spam.
How to use this reference
Filter by group to see the class types, the valuation accounts or the variance accounts. When you set up a new organization, use the table as a design checklist for what to configure in the WIP Accounting Classes window. Export to Excel and fill in the actual GL account combinations beside each row for sign-off by the controller.
Class types and where costs go
Standard discrete classes are for normal production, and the job is linked to an inventory assembly. Non-standard classes are for jobs without a standard assembly, such as rework or maintenance. Asset non-standard jobs capitalise the cost, while expense jobs charge it to the expense account on close.
- Standard Discrete: build inventory assemblies
- Repetitive Assembly: line-based schedules
- Asset Non-standard: capitalised rework and projects
- Expense Non-standard: maintenance and R and D
Valuation versus variance accounts
Valuation accounts carry the cost of work in process while a job is open. Variance accounts are used when the job is closed, to hold the difference between what was charged to the job and what was credited to inventory at standard cost. Review variance accounts regularly, because large balances point to wrong BOM quantities, routings or standard rates.
Common mistakes
A frequent mistake is using one accounting class for every job, so finance cannot separate rework from production. Another is changing accounts on a class after jobs have been created, which does not change existing jobs. Plan the class structure during design and review it whenever a new job type appears.
Frequently Asked Questions
Where are WIP accounting classes stored?
They are stored in WIP_ACCOUNTING_CLASSES, by organization and class code, with the class type and the accounts. Discrete jobs hold the class code in WIP_DISCRETE_JOBS.
What is a non-standard job?
A non-standard job does not have to build a standard inventory assembly. It is used for rework, refurbishment, maintenance or projects that need material and resource tracking without a normal assembly.
Can I change a job's class after release?
Generally not once there are transactions. The class and its accounts are fixed on the job, so changing them usually requires cancelling and recreating, or an approved correction.
Do these accounts differ for average costing?
Yes, some variance accounts apply only to standard costing, and average costing handles variances differently. Check the Oracle Cost Management documentation for your costing method.
If you are reviewing WIP and variance balances before a close or an upgrade, we can help analyze job cost data from your EBS database.
Related Tools
Oracle EBS Discrete Job Statuses Reference
Look up every Oracle WIP discrete job status, its numeric code, what transactions it allows and the usual next step.
OracleOracle EBS Inventory Period Close Checklist
A step-by-step checklist for closing the Oracle Inventory accounting period, including WIP, receiving and cost transactions.
OracleOracle EBS Inventory Transaction Types Reference
Quick lookup of common Oracle Inventory transaction types, their IDs, source types and effect on on-hand quantity.
Developer ToolsOracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
More Oracle tools
See all- Oracle EBS Item Attribute Template Worksheet
- Oracle EBS MRP Exception Messages Reference
- Oracle EBS BOM Interface Load Worksheet
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
- Oracle EBS Routing and Operations Load Worksheet
- Oracle EBS Inventory Organization Parameters Setup Template
- Oracle EBS Item Cost Update Request Form
- Oracle EBS Engineering Change Order Request Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS WIP Tables ReferenceLookup of Oracle EBS Work in Process tables with purpose and key columns, covering discrete jobs, operations, requirements, resources and interfaces.
- Oracle EBS WIP Job Variance CalculatorSplit a standard cost discrete job into material usage, resource efficiency and resource rate variances before you close it.
- Oracle EBS WIP Job Close Variance WorksheetEditable worksheet to review material and resource variances per discrete job before running the close, with variance percent and totals.
ERP fixes and how-tos
- Oracle Work Order Tables: WIP_ENTITIES, WIP_DISCRETE_JOBS and the REST RouteOracle work order tables explained: WIP_ENTITIES, WIP_DISCRETE_JOBS, operations and requirements, with a join query for EBS and the Fusion REST route.
- Oracle EBS Outside Processing and Production SchedulingSet up outside processing in Oracle EBS WIP and Purchasing: OSP items, resources, departments, routing and requisitions, plus how discrete job scheduling works.
- How to Close an Inventory Accounting Period in Oracle EBSClose an Oracle EBS Inventory accounting period: clear pending transactions, run the pending transactions report, close via Inventory Accounting Periods, transfer to GL.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- MarkView for Accounts Payable and Oracle E-Business SuiteHow Tungsten (Kofax) MarkView automates AP invoice capture and discrepancy workflow inside Oracle EBS: integration, data flows, setup, pitfalls and AI.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
AI on your ERP
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
Integrations
- How to build a mobile app for Oracle E-Business SuiteBuild a shop-floor or field mobile app for Oracle E-Business Suite: barcode scanning, WIP and inventory moves, approvals and offline use over ISG and supported APIs.
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.