Oracle Fusion Cloud SCM Fit Gap Worksheet
A fit gap log is the working record of an Oracle Fusion Cloud SCM design phase. This worksheet gives you the columns most teams end up building in Excel and totals the effort and cost as you type.
| Requirement | Module | Fit class | Priority | Effort (days) | Day rate | Estimated cost | Owner | |
|---|---|---|---|---|---|---|---|---|
$3,600 | ||||||||
$12,000 | ||||||||
$900 | ||||||||
$2,850 | ||||||||
$1,800 |
Rates and days are examples. Replace them with your own estimates. Export to Excel to filter by fit class or module.
Want requirements pulled from your legacy ERP?
Optional expert review of your fit gap list against what your current ERP actually does.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per requirement, not per workshop topic. Pick the module, then classify the fit. Enter effort in days and a day rate, and the cost column calculates itself. Keep the owner column filled so every open row has a name next to it. Export to Excel after each workshop and circulate the file so the business confirms the classification rather than discovering it at user acceptance testing.
- Write requirements as a testable statement
- Classify before you estimate
- Review Must items with a gap first
- Re-export after every workshop
What the fit classes mean
Standard means the delivered offering does it with no setup beyond the normal functional setup. Configuration means setup choices in areas like Manufacturing, Inventory or Order Management cover it. Extension means a build outside the core, typically with Visual Builder Studio, Oracle Integration or BI Publisher, so the quarterly update path stays clean. A process change gap means the business adapts. A not supported gap needs an escalation or a workaround agreed in writing.
Reading the totals
The totals show effort, cost and the number of requirements. A healthy log has most rows in Standard and Configuration. If extensions outweigh configuration, challenge the requirement wording, because legacy ERP habits often drive custom builds that Fusion handles through setup. Treat the average cost per requirement as a sanity check against your statement of work, not as a quote.
Common mistakes
Teams classify as Standard without testing in a sandbox, then reclassify later. They also hide integration work inside module rows. Give integrations their own rows so the cost of connectors, FBDI loads and REST based interfaces is visible. Finally, do not size the same requirement twice across modules; pick the module that owns the transaction.
Frequently Asked Questions
Is a fit gap analysis the same as a gap analysis?
Not quite. A fit gap analysis starts from business requirements and checks each against delivered functionality, then classifies the result. A general gap analysis compares current state to target state. In Oracle Fusion projects the fit gap log feeds scope, estimates and the extension backlog.
How granular should requirements be?
Granular enough that one test case can prove or disprove it. A line like 'handle returns' is too broad. 'Return to vendor with debit memo created from the receipt' can be classified, estimated and tested. Aim for one transaction outcome per row.
Should every gap get an extension?
No. Prefer changing the process or using a configuration option, because extensions need regression testing after each quarterly update. Build only when the business value is clear and there is no supported alternative.
Can I import this into a project tool?
Yes. Export to CSV or Excel and import the rows into your project or backlog tool. Keep the requirement text unchanged so traceability to test scripts and design documents is preserved.
If your requirements live in a legacy ERP, we can help extract and group them from existing reports and customisations before the design phase starts.
Related Tools
Oracle Fusion Data Migration Mapping Worksheet
Map legacy fields to Oracle Fusion objects and attributes, record the transform rule, and see how many records survive cleansing.
OracleOracle Fusion Manufacturing Work Definition Worksheet
Design routing operations before you key them in. Capture work centers, setup and run times, yield and the total time for an order quantity.
OracleOracle Fusion Cutover Plan Worksheet
Plan a go-live weekend task by task, with start offsets, durations, owners and a calculated end hour for each step.
OracleOracle Fusion SCM UAT Test Script Template
A fill-in test script with preconditions, step table, expected results and sign off for user acceptance testing of Oracle Fusion SCM.
More Oracle tools
See all- Oracle Fusion FBDI Template Field Guide
- Oracle Fusion Item Class Design Worksheet
- Oracle Fusion Supply Planning Checklist
- Oracle Fusion BI Publisher Report Specification Template
- Oracle Fusion Quarterly Update Test Checklist
- Oracle Fusion Role Provisioning Worksheet
- Oracle Fusion Inventory Organization Design Worksheet
- Oracle Fusion SCM Implementation Statement of Work Template
- Oracle Fusion FBDI Load Time Estimator
Keep exploring
Free tools
- Oracle EBS to Fusion Fit Gap WorksheetCapture each requirement, classify it as standard, configuration, extension or gap, and total the effort in days.
- Oracle Fusion SCM Implementation Readiness AssessmentTen questions that show whether data, process, integration and people are ready for a Fusion SCM implementation.
- Oracle Fusion Integration Design Document TemplateFill in interface details once and get a clean design document covering method, mapping, scheduling, error handling and approvals.
ERP fixes and how-tos
- Oracle Fusion: Cost Accounting Distributions Not CreatedOracle Fusion inventory transactions not costed or without distributions: check cost organization, cost book, valuation setup, missing item cost, and the processing jobs.
- Oracle Fusion Inventory: Cycle Count Setup and Adjustment ApprovalSet up cycle counts in Oracle Fusion Inventory: count definitions, ABC classes, tolerances, approval of adjustments and where the accounting lands in costing.
- Oracle Fusion Manufacturing: Work Order Cannot Complete or CloseWhy an Oracle Fusion Manufacturing work order will not complete or close: open operations, unissued components, pending transactions, cost variances and status holds.
Runs with your ERP
- Oracle Fusion Cloud Quality Management with Fusion SCMHow Oracle Fusion Cloud Quality Management logs nonconformance against WIP, receiving and supplier records and drives CAPA: flows, setup and pitfalls.
- Oracle Fusion Cloud Maintenance with Fusion ERP and SCMHow Oracle Fusion Cloud Maintenance handles work orders, preventive maintenance and warranty on Fusion SCM: data flows, setup, pitfalls and private AI ideas.
- RFgen Mobile Foundations with Oracle Fusion Cloud SCMRFgen Mobile Foundations automates Oracle Fusion Cloud SCM warehouse and inventory transactions on barcode devices: connector, data flows, setup, pitfalls.
AI on your ERP
- AI for Oracle Cloud SCM and Manufacturing, Grounded in Your Planning DataAdd grounded AI to Oracle Cloud SCM and Fusion Manufacturing: demand plans, work orders, and supplier data, answered on-prem or in a private cloud with full query visibility.
- Fusion Cloud ERP AI: OCI Generative AI Service vs. a Private LLMHow Fusion Cloud ERP AI supports GenAI implementation: OCI Generative AI Service for Fusion-only use cases, a private LLM for sensitive or cross-system data.
Integrations
- How to add AI agents to Oracle Fusion Cloud ERPHow to build AI agents on Oracle Fusion Cloud ERP: REST tool layer, BICC and OTBI for reads, FBDI and approvals for writes, and where private models fit.
- How to connect ChatGPT to Oracle Fusion Cloud ERPHow to use ChatGPT with Oracle Fusion Cloud ERP: custom GPT actions over REST, exports versus live access, enterprise data controls and private model options.