Oracle EBS Outside Processing and Production Scheduling
oracle ebs outside processing
Also searched as
- oracle ebs production scheduling
- oracle ebs mfg
- oracle wip outside processing item resource setup
- oracle discrete manufacturing scheduling
Short answer
Outside processing (OSP) in Oracle EBS lets a discrete job send work to a supplier, such as plating or heat treat. You define an outside processing item, an OSP resource with a charge type, a department that owns it, and a routing operation that uses it. When the job is released, WIP drives a requisition to Purchasing; receiving against the PO charges the job.
Applies to: Oracle E-Business Suite 12.1 and 12.2 Discrete Manufacturing with WIP, Bills of Material, Purchasing and Inventory. Details such as profile values vary by release.
How to set up outside processing
- 1Create the outside processing item in the Master Item form with the Outside Processing Item attribute on, a purchasable flag and a unit of measure matching how the supplier prices (for example each or pound).
- 2Define a resource in Bills of Material > Routings > Resources with the Outside Processing check box on and a charge type of PO Receipt or PO Move. Link the OSP item to the resource and set the unit of measure.
- 3Create a department (Bills of Material > Routings > Departments) and assign the OSP resource to it.
- 4Add an operation to the routing for the department and include the resource, with the usage rate and basis (item or lot).
- 5Create the job in WIP > Discrete > Discrete Jobs with the routing. Release it.
- 6On release, WIP populates the requisition interface; run Requisition Import in Purchasing to create the approved requisition.
- 7Use Autocreate to turn the requisition into a PO, send it to the supplier, and receive against it. With PO Receipt charge type, receipt charges the resource and can move quantity.
- 8Check the job in the Operations and Resources views and in the OSP cost reports.
How the pieces fit
The routing is where the supplier step lives. The operation points to a department; the department holds an OSP resource; the resource points to the OSP item that Purchasing buys. The charge type decides when cost lands on the job. PO Receipt charges when goods are received from the supplier, and PO Move also moves the job quantity to the next operation on receipt, while the Manual charge type applies to non-OSP resources.
The item you buy does not have to be the item the job makes. The OSP item represents the service. The job's own assembly item travels out and returns, and the unit costs from the PO price and any variance accrue to the job.
How production scheduling works in EBS
Discrete job scheduling uses operation times, resource usage rates, department calendars and shifts defined in Bills of Material, plus item lead times. When you create or reschedule a job, WIP can schedule forward from a start date or backward from a completion date, producing operation start and end dates.
That scheduling is infinite capacity: it does not check whether the resource is overloaded. For finite capacity and supply-demand planning, companies use Advanced Supply Chain Planning, or Oracle Manufacturing Scheduling in some setups, while the planned order release feeds jobs back to WIP. Check which planning product your site licenses before designing a process.
-- Jobs with outside processing resources, quick check
SELECT wo.wip_entity_id, wo.operation_seq_num, wor.resource_id
FROM wip_operations wo
JOIN wip_operation_resources wor
ON wor.wip_entity_id = wo.wip_entity_id
AND wor.operation_seq_num = wo.operation_seq_num
AND wor.organization_id = wo.organization_id
WHERE wo.organization_id = :org_idWhat goes wrong in practice
Most failures are in requisition creation. If no requisition appears after release, check that Requisition Import ran and look at the PO requisition interface errors, such as missing buyer, category or approved supplier list entries. See the page on requisition import errors for details.
Cost surprises come from price differences between requisition and PO, and from receipts posted to the wrong organization. Reconcile through the outside processing and job cost reports before period close.
Try it here, free
Oracle EBS WIP Job Variance Calculator
Split a standard cost discrete job into material usage, resource efficiency and resource rate variances before you close it.
Common pitfalls
- !Forgetting to link the OSP item to the resource, so release creates no requisition.
- !Choosing PO Receipt when you need the job to move automatically, or the reverse.
- !Mismatched units of measure between the OSP item and the resource usage rate.
- !Assuming WIP scheduling is finite; it ignores resource load.
- !Closing a job before the supplier invoice is matched, locking in estimated cost.
How an ERP-grounded AI assistant handles this
An assistant grounded in EBS data (ERPray, read-only and showing its SQL) can list released jobs with OSP operations that have no requisition or PO, show which supplier is late against the scheduled date, and explain a price variance on a given job. For defense and aerospace sites running EBS on-premises, a locally hosted model keeps job and supplier data inside the network. For the setup itself, your Oracle documentation and a functional consultant remain the right source.
Frequently asked questions
What is outside processing in Oracle EBS?
Outside processing sends part of a discrete job to a supplier, such as plating, using a purchase order. The supplier step is an operation in the routing, with an outside processing resource linked to a purchasable service item.
What is the difference between PO Receipt and PO Move charge types?
PO Receipt charges the resource cost when the goods are received. PO Move also moves the job quantity forward to the next operation as part of the receipt, so shop floor staff do not need a separate move transaction.
Does Oracle EBS do finite production scheduling?
Core WIP scheduling is infinite capacity using calendars and rates. Finite scheduling and supply-demand planning need additional products such as Advanced Supply Chain Planning, depending on what your organization licenses.
Why did releasing a job not create a requisition?
Common causes are a missing link between the OSP resource and item, a non-purchasable item, or Requisition Import errors. Check the requisition interface error table and the concurrent request log.
Related
Fix Oracle EBS Requisition Import Errors in PO_INTERFACE_ERRORS
When Requisition Import (REQIMPORT) rejects rows, it leaves them in PO_REQUISITIONS_INTERFACE_ALL with PROCESS_FLAG = 'ERROR' and writes a reason per row to PO_INTERFACE_ERRORS. Read the Requisition Import Exceptions Report or query the error table, correct the source data, reset the rows and run the import again with the right Import Source and Batch ID.
How-toOracle Work Order Tables: WIP_ENTITIES, WIP_DISCRETE_JOBS and the REST Route
In Oracle E-Business Suite, a discrete work order (job) is stored in WIP_ENTITIES (the identity and name) and WIP_DISCRETE_JOBS (the header detail such as item, quantities, status and dates), with operations in WIP_OPERATIONS, resources in WIP_OPERATION_RESOURCES and components in WIP_REQUIREMENT_OPERATIONS. In Fusion Cloud, do not query tables directly; use the work orders REST resource or a BI report.
Error fixFix Oracle EBS Uncosted Material Transactions Blocking Period Close
Uncosted material transactions are rows in MTL_MATERIAL_TRANSACTIONS whose COSTED_FLAG is N (waiting for the Cost Manager) or E (costing error). Use the Resolve Uncosted Transactions form to read the error, fix the cause in costing setup or item cost, then let the Cost Manager reprocess them. The inventory period will not close while these rows exist.
How-toNetSuite Outsourced Manufacturing: Subcontract Work Order Flow
NetSuite outsourced manufacturing lets you buy a finished or processed assembly from a vendor while supplying the components yourself. A purchase order drives a linked work order, components are sent to the vendor, and the item receipt brings in the assembly with component cost plus the vendor charge. It works well once the item, vendor charge and component location are set correctly.
Error fixFix FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-06508
FRM-40735 with ORA-06508 almost always means a PL/SQL package used by the form was recompiled while your session still held the old cached state, or the trigger's own exception handling does not trap a real data error. Exit the form completely and re-enter it; if the error repeats for all users, recompile invalid objects on the database and check for a bad custom trigger.
Error fixOracle EBS Concurrent Manager Will Not Start: How to Fix It
A concurrent manager that will not start in Oracle EBS is almost always one of three things: the node registered in FND_NODES no longer matches the actual hostname (common after cloning), stale OS processes are blocking a fresh start, or the database and listener the manager connects to are unreachable. Check the internal manager log, verify the node name, clear stale processes, and restart with adcmctl.sh.
AI for ERPAI for Oracle E-Business Suite, Without Leaving On-Prem
Hosting 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.
AI for ERPAI for Oracle EBS in Aerospace and Defense Manufacturing
AI on Oracle EBS for aerospace and defense manufacturers: project manufacturing, serial control, and ITAR segregation handled without a cloud dependency.
Stuck on Oracle E-Business Suite?
Talk to engineers who work inside Oracle E-Business Suite every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- 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.
- 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.
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.
- How to Create an Item in Oracle EBSCreate an inventory item in Oracle EBS: Master Items form, master organization, templates, attributes, organization assignment, categories and common errors.
- Fix Oracle EBS Requisition Import Errors in PO_INTERFACE_ERRORSRequisition Import rejected your rows? Read PO_INTERFACE_ERRORS and the Exceptions Report, fix item, category, org or approver data, then rerun the import in Oracle EBS.
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.
- Prometheus GWOS-AI with Oracle E-Business SuiteHow Prometheus GWOS-AI adds graphical work order scheduling on Oracle EBS maintenance data, also for Fusion and JD Edwards: flows, setup, pitfalls, AI ideas.
- Loftware Integration for Oracle EBS: WMS Label RequestsHow the Loftware Integration - Oracle EBS component connects Oracle WMS label requests to Loftware Cloud, Enterprise SP or NiceLabel LMS, plus setup.
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.