Oracle EBS Discrete Job Statuses Reference
In Oracle E-Business Suite, the status of a discrete job decides which material, move and resource transactions Work in Process will accept. This reference lists each status with its STATUS_TYPE code and what it does on the shop floor.
| STATUS_TYPE | Status | What it means | Transactions allowed | Typical next step |
|---|---|---|---|---|
1 | Unreleased | Job exists but is not yet released to the shop floor. | Edit job, BOM and routing. No material or move transactions. | Release the job. |
3 | Released | Job is active on the shop floor. | Component issues, moves, resource charges, completions. | Complete assemblies. |
4 | Complete | Job is finished but charges can still be posted. | Charges and returns still allowed. | Run Close Discrete Jobs. |
5 | Complete - No Charges | Job is finished and further charges are blocked. | No further charges. | Close the job. |
6 | On Hold | Job is suspended by planner or supervisor. | No transactions until the hold is removed. | Release or cancel. |
7 | Cancelled | Job is cancelled and cannot be used for production. | No production transactions. | Close if charges remain. |
12 | Closed | Variances calculated and posted, job is final. | No transactions. | Reporting only. |
13 | Pending - Mass Loaded | Job loaded through the interface and awaiting processing. | None until processed. | Run the Work Order Interface. |
14 | Pending Close | Close request submitted and not yet processed. | None while closing. | Wait for the close program. |
15 | Failed Close | Close program failed for this job. | Limited, fix the cause first. | Review the log and resubmit. |
16 | Pending Scheduling | Job is waiting for the scheduler. | None until scheduled. | Run the scheduler or check the interface. |
17 | Draft | Job saved in draft and not yet firm. | Editing only. | Promote to Unreleased or Released. |
8 | Pending Routing Load | Routing is being loaded for the job. | None until the load ends. | Wait or check the interface. |
9 | Failed Bom Load | Bill of material load failed. | None. | Fix the BOM and resubmit. |
10 | Failed Routing Load | Routing load failed. | None. | Fix the routing and resubmit. |
Codes and wording come from the WIP_JOB_STATUS lookup and can differ slightly between 11i and R12 patch levels. Confirm in Application Utilities Lookups on your own instance before using a code in a customization.
Job status health check on your own data
Optional: we can review how many of your jobs sit in each status and which ones look stuck.
Optional. The tool and every export work without this. No spam.
How to use this reference
Type a status name or numeric code in the search box to filter the table. The code column matches WIP_DISCRETE_JOBS.STATUS_TYPE, so you can paste it straight into a query, a report parameter or an Alert condition. Use the Excel export when you need to hand a status chart to planners or to document a job lifecycle in a design document.
The normal job lifecycle
A typical job moves from Unreleased to Released, then to Complete when the finished quantity is received, and finally to Closed after the Close Discrete Jobs program calculates variances. Complete - No Charges is the usual choice when the shop floor is done and nobody should post more labor or material.
- Unreleased to Released: planners firm and release
- Released to Complete: assembly completion transactions
- Complete to Closed: variance calculation at period end
- Hold and Cancelled sit outside the main path
Interface and error statuses
Pending Mass Loaded, Pending Close and the Failed statuses are mostly set by programs, not by people. If many jobs sit in Pending or Failed, look at the concurrent request log for the Work Order Interface or Close Discrete Jobs, then fix the data and resubmit. Do not update STATUS_TYPE directly in the database, because related tables and accounting would be left inconsistent.
Common mistakes
Closing jobs before all charges have posted is the most frequent cause of unexpected variances. Another is cancelling a job that already has material issued, which leaves stranded cost until the job is closed. Always check pending transactions and uncosted transactions first, then change the status through the form or the supported API.
Frequently Asked Questions
Where is the job status stored in Oracle EBS?
The status is stored in WIP_DISCRETE_JOBS.STATUS_TYPE as a number. The meaning of each number comes from the WIP_JOB_STATUS lookup type, so you can join to FND lookup tables to display the text.
What is the difference between Complete and Complete - No Charges?
Complete still accepts charges such as late labor or material returns. Complete - No Charges blocks all further charges, which is useful when you want the cost to freeze before closing the job.
Can I reopen a closed job?
Closed jobs generally cannot be reopened through normal forms. Some releases offer a reopen option for specific cases. Check your version and test in a non-production instance before relying on it.
Why is my job stuck in Pending Close?
The Close Discrete Jobs request has not completed or has errored. Check the concurrent request log, resolve pending or uncosted transactions that block it, and resubmit the close.
If your planners keep asking which jobs are stuck in which status, we can build a read-only view over your EBS data that answers it in plain English.
Related Tools
Oracle EBS WIP Accounting Class Reference
Understand Oracle WIP accounting class types and which valuation and variance accounts each class uses.
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.
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.
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 Fusion Work Order Statuses ReferenceLook up what each Oracle Fusion Manufacturing work order status means, what you can do in it, and which status usually comes next.
- 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 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.
- 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.
- How to Add a Private AI Layer to Oracle EBS 12.2 On-PremReference architecture for a private AI layer on Oracle EBS 12.2: Active Data Guard replica, ISG REST, MO and responsibility security, local GPUs and audit.
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.
- Oracle Mobile Supply Chain Applications (MSCA) for Oracle EBSOracle Mobile Supply Chain Applications (MSCA) for EBS: native RF transactions for inventory, WMS and manufacturing, setup, pitfalls and where private AI helps.
- 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 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.
- 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.