Here are some Oracle Fusion Manufacturing interview questions
tailored for experienced professionals, typically with 3+ years of hands-
on experience. These questions are a mix of functional, technical, and
scenario-based queries that can help assess both depth and breadth of
expertise.
🔧 Functional/Process-Oriented Questions
1. Explain the end-to-end flow of Oracle Fusion Manufacturing.
How is it different from EBS?
2. How do Work Definitions work in Oracle Fusion, and what
components are required to create one?
3. What are Standard Operations and how are they reused across
Work Definitions?
4. How do you manage revisions and effectivity dates in Work
Definitions or Work Orders?
5. What is the difference between Discrete Manufacturing and
Process Manufacturing in Fusion?
6. How do you handle co-products and by-products in Oracle
Fusion Manufacturing?
7. What is the role of Supply Chain Orchestration (SCO) in Work
Order management?
8. Explain the backflush process in Fusion. How is it triggered?
9. What is the role of Manufacturing Lead Time in Planning?
10. How does Oracle Fusion handle work order reservations
and pegging?
🧠 Scenario-Based Questions
1. A user reports that completed quantities are not reflected in
Inventory. What steps would you take to troubleshoot?
2. How would you handle a situation where a component on a
work order is obsolete but still appears in the picking list?
3. Describe how you would implement a new production line in
Oracle Fusion Manufacturing.
4. A client needs to restrict work order visibility based on
business units or plants. How would you approach this?
5. Explain how to automate work order creation from Sales
Orders. What modules are involved?
Technical Questions
1. What tables are involved in Work Order creation and tracking
in Oracle Fusion?
2. Describe the key REST/SOAP APIs used in Oracle Fusion
Manufacturing.
3. How can you use Oracle Integration Cloud (OIC) to integrate
manufacturing data with third-party systems?
4. How do you customize reports or dashboards in Oracle Fusion
Manufacturing using OTBI or BI Publisher?
5. What are the common FBDI templates used in Manufacturing?
📈 Reporting & Analytics
1. How do you track production efficiency and scrap in Oracle
Fusion?
2. What are key performance indicators (KPIs) available out-of-
the-box for Manufacturing?
3. How do you handle real-time reporting of WIP (Work in
Process)?
⚙️Configuration & Setup
1. What are the mandatory setups required before starting
Manufacturing transactions in Fusion?
2. How do you configure Work Centers and Resources?
3. Explain the concept of Resource Instances and how they are
useful.
4. How are Costing and Accounting integrated with
Manufacturing transactions?
To create and use ChatGPT canvas, you'll need to be logged in to ChatGPT.
Once you're logged in, I can help you generate a fully structured document
with questions and answers inside the canvas.
In the meantime, I’ll begin by answering the first few questions here. Let me
know if you’d like the rest continued in this format or once you’ve logged in.
🔧 Functional/Process-Oriented Questions (With Answers)
1. Explain the end-to-end flow of Oracle Fusion Manufacturing. How
is it different from EBS?
Answer:
Fusion Flow:
1. Create Item & Work Definition
2. Create Work Order (manual or via Supply Orchestration)
3. Release Work Order
4. Issue Components (Manual or Backflush)
5. Report Operations (optional)
6. Report Completion
7. Close Work Order
8. Cost Transactions
Differences from EBS:
o Fusion is cloud-native with modern UI and REST APIs.
o No WIP Accounting Class setup; costing handled via Costing
module.
o Real-time analytics via OTBI.
o Work Orders can be auto-created via Supply Chain Orchestration.
2. How do Work Definitions work in Oracle Fusion, and what
components are required to create one?
Answer:
Work Definition is a template for manufacturing an item.
Components Required:
o Item (Make item with WIP supply type)
o Work Centers and Resources
o Operations (sequence of tasks)
o Components (Bill of Material lines)
o Optional: Output products (for co/by-products)
3. What are Standard Operations and how are they reused across
Work Definitions?
Answer:
Standard Operations are predefined operation templates.
Can be reused in multiple Work Definitions to maintain consistency and
reduce setup time.
Example: A “Cutting” operation defined once can be used across items
that require cutting.
4. How do you manage revisions and effectivity dates in Work
Definitions or Work Orders?
Answer:
Revisions allow tracking changes to the structure or process.
Each revision can have:
o Effective Start/End Dates
o Associated component/operation changes
When creating a Work Order, the system picks the effective Work
Definition based on the scheduled start date.
5. What is the difference between Discrete Manufacturing and
Process Manufacturing in Fusion?
Answer:
Discrete Manufacturing:
o Produces distinct items (e.g., cars, mobile phones).
o Uses Work Definitions and Work Orders.
o Items are individually tracked.
Process Manufacturing:
o Used for formulas and recipes (e.g., chemicals, food).
o Uses formulas, process instructions, and batch production.
o Supports attributes like potency, shelf life, and yield.
Note: Oracle Fusion currently focuses on Discrete Manufacturing. Process
Manufacturing is available in Oracle Cloud SCM but has separate setup and
flow.
6. How do you handle co-products and by-products in Oracle Fusion
Manufacturing?
Answer:
During Work Definition setup, you can define multiple output items.
Co-products: Secondary items produced with the main item (e.g.,
during refining).
By-products: Residuals or scrap that may or may not have value.
The system allows defining output percentages and cost allocation
between outputs.
7. What is the role of Supply Chain Orchestration (SCO) in Work
Order management?
Answer:
SCO is the integration layer between Order Management, Planning,
and Manufacturing.
It automatically creates Work Orders when a make-supply is
triggered (e.g., from Sales Order or Forecast).
Monitors the fulfillment progress and updates demand sources.
Handles exceptions and re-planning events.
8. Explain the backflush process in Fusion. How is it triggered?
Answer:
Backflush means issuing components automatically upon reporting
operation or completion.
Triggered during:
o Report Operation
o Report Completion
Based on the supply type “Backflush” set in the component line of the
Work Definition.
Reduces manual effort and improves real-time accuracy.
9. What is the role of the Manufacturing Lead Time in Planning?
Answer:
Determines how far in advance the system should plan work orders.
Used in:
o Supply Planning
o GOP (Global Order Promising)
Impacts ATP calculations and planned order dates.
Includes preprocessing, processing, and post-processing days.
10. How does Oracle Fusion handle work order reservations and
pegging?
Answer:
When SCO creates a Work Order, it reserves it to the originating
demand (e.g., Sales Order).
Pegging is visible in:
o Supply Chain Workbench
o Work Order Details
Ensures supply is used for the intended demand, preserving demand-
supply integrity.
🧠 Scenario-Based Questions
11. A user reports that completed quantities are not being reflected
in Inventory. What steps would you take to troubleshoot?
Answer:
1. Check if Report Completion was successfully done.
2. Validate if the Completion Subinventory is defined.
3. Review transaction errors in the Review Completed Transactions UI.
4. Check costing/accounting processes.
5. Ensure the interface to Inventory was not interrupted.
12. How would you handle a situation where a component on a work
order is obsolete but still appears in the picking list?
Answer:
Check component effectivity in the Work Definition.
Revise the Work Definition to exclude obsolete parts.
Ensure Work Order is using the latest revision.
If already released, use the Change Order or Manual Component
Replacement.
13. Describe how you would implement a new production line in
Oracle Fusion Manufacturing.
Answer:
1. Define a new Work Center.
2. Create/Assign Resources.
3. Update relevant Work Definitions to include the new work center.
4. Configure resource calendars and shifts.
5. Test Work Orders to validate the production flow.
14. A client needs to restrict work order visibility based on business
units or plants. How would you approach this?
Answer:
Use Data Security Policies tied to Business Units or Inventory
Orgs.
Define roles with custom duty roles.
Apply data access sets to ensure users only see relevant entities.
15. Explain how to automate work order creation from Sales Orders.
What modules are involved?
Answer:
Involved modules:
o Order Management
o Supply Chain Orchestration (SCO)
o Manufacturing
Sales Order → Triggers make supply → SCO evaluates → Creates Work
Order.
Must have:
o Make Items setup
o ATP Rules and Sourcing Rules
o Proper Work Definitions
Technical Questions
16. What tables are involved in Work Order creation and tracking in
Oracle Fusion?
Answer:
Some key tables include:
WIE_WORK_ORDERS – Work Order header
WIE_WO_OPERATIONS – Work Order operations
WIE_WO_MATERIALS – Components on the Work Order
WIE_WO_OUTPUTS – Output products
WIE_WO_RESOURCES – Resources assigned to operations
INV.MTL_SYSTEM_ITEMS_B – Item master
BOM.BOM_STRUCTURES_B – Work Definition structures
Fusion tables are part of OTBI or queried through BI Publisher using BICC (BI
Cloud Connector) or SQL in a Data Model.
17. Describe the key REST/SOAP APIs used in Oracle Fusion
Manufacturing.
Answer:
Important APIs:
Work Order REST API:
o /fscmRestApi/resources/latest/workOrders
Work Order Operation Transactions:
o Report Completion, Report Operation APIs
Work Definitions API:
o /fscmRestApi/resources/latest/workDefinitions
Manufacturing Transactions API:
o Issue, return, scrap, etc.
REST is preferred due to modern architecture. Authentication via OAuth2 or
Basic Auth for integrations.
18. How can you use Oracle Integration Cloud (OIC) to integrate
manufacturing data with third-party systems?
Answer:
Use OIC Adapters for Oracle ERP Cloud and external apps (FTP, REST,
SOAP).
Design an integration flow to:
o Read incoming orders → Call Fusion API to create Work Order
o Monitor Work Order status and push updates
Scheduled orchestration can be used for periodic batch updates.
Supports error handling, retries, and notifications.
19. How do you customize reports or dashboards in Oracle Fusion
Manufacturing using OTBI or BI Publisher?
Answer:
OTBI: Drag-and-drop ad hoc reporting. Use subject areas like:
o Manufacturing - Work Order Operations Real Time
o Manufacturing - Work Order Performance
BI Publisher:
o Used for pixel-perfect or transactional reports.
o Create custom data models using SQL.
o Schedule report bursts or exports.
20. What are the common FBDI templates used in Manufacturing?
Answer:
FBDI (File-Based Data Import) templates:
Work Definitions: [Link]
Work Centers: WorkCentersImportTemplate
Resources: ResourcesImportTemplate
Work Orders: WorkOrderImportTemplate
Templates are uploaded to UCM, and the process is run from Scheduled
Processes.
📈 Reporting & Analytics
21. How do you track production efficiency and scrap in Oracle
Fusion?
Answer:
Report Operation captures:
o Actual time vs. standard
o Yield vs. expected output
o Scrap and rework quantities
Use OTBI dashboards or Manufacturing KPIs to monitor:
o Resource utilization
o Scrap rate
o Operation variance
22. What are key performance indicators (KPIs) available out-of-the-
box for Manufacturing?
Answer:
Work Order Performance
Resource Utilization
Scrap Percentage
Manufacturing Cycle Time
Production Yield
On-Time Completion
Accessible via Supply Chain Command Center (if enabled) or OTBI
dashboards.
23. How do you handle real-time reporting of WIP (Work in Process)?
Answer:
Use OTBI real-time subject areas:
o Manufacturing - Work Order Operations Real Time
o Manufacturing - Work Orders Real Time
These allow tracking:
o In-progress operations
o Open vs. closed work orders
o Component consumption
Also, dashboards can be created to highlight WIP bottlenecks.
⚙️Configuration & Setup
24. What are the mandatory setups required before starting
Manufacturing transactions in Fusion?
Answer:
1. Define Inventory Orgs and Business Units.
2. Enable Manufacturing in Functional Setup Manager (FSM).
3. Define Work Centers and Resources.
4. Create Standard Operations (optional).
5. Set up Work Definitions for Make Items.
6. Configure Subinventories for supply and completion.
7. Define Costing setups (for accounting).
8. Set up role-based access.
25. How do you configure Work Centers and Resources?
Answer:
Work Center: Logical grouping of resources.
Resources: Machines, labor, or tools assigned to operations.
Define:
o Resource Type (Labor/Machine)
o Utilization % and efficiency
o Costing details
Assign Work Centers to operations in Work Definitions.
26. Explain the concept of Resource Instances and how they are
useful.
Answer:
Resource Instances: Track individual machines/labor units under a
resource.
Enables:
o Detailed scheduling
o Performance tracking
o Maintenance history (if integrated with Maintenance module)
Example: CNC Machine-01 and CNC Machine-02 under "CNC Machine"
resource.
27. How are Costing and Accounting integrated with Manufacturing
transactions?
Answer:
Component issues, resource usage, and output completion create cost
transactions.
Sent to Cost Accounting, where:
o Work Order variances are calculated.
o Accounting entries are generated.
Includes absorption of labor, overhead, and material costs.