OracleFree worksheetPDF, Excel, Word exportOracle Fusion Cloud SCM

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.

Download:
RequirementModuleFit classPriorityEffort (days)Day rateEstimated costOwner
$3,600
$12,000
$900
$2,850
$1,800
Total effort
22 days
Total estimated cost
$21,150
Requirements logged
5
Average cost per requirement
$4,230
Average effort per requirement
4 days

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.