# Oracle Fusion Data Conversion Tracker Worksheet > Source: https://netray.co/tools/oracle-fusion-data-conversion-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track each conversion object across mock loads, with source counts, loaded counts, errors and automatic error rates. ## Category oracle ## Erp Oracle Fusion Cloud SCM ## Audience - Data migration lead - Oracle Cloud consultant - Program manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Conversion object **Key:** object **Type:** text #### Load method **Key:** method **Type:** select **Options:** - FBDI - REST - File based loader - Manual - Other #### Owner **Key:** owner **Type:** text #### Cycle **Key:** cycle **Type:** select **Options:** - Mock 1 - Mock 2 - Mock 3 - Dress rehearsal - Production #### Source records **Key:** source **Type:** number #### Loaded records **Key:** loaded **Type:** number #### Error records **Key:** errors **Type:** number #### Error rate % **Key:** rate **Type:** number **Expr:** if(gt(source,0), errors / source * 100, 0) **Format:** decimal #### Unaccounted **Key:** gap **Type:** number **Expr:** source - loaded - errors **Format:** integer #### Target date **Key:** due **Type:** date **Rows:** **Object:** Items **Method:** FBDI **Owner:** A. Rao **Cycle:** Mock 1 **Source:** 18400 **Loaded:** 17950 **Errors:** 450 **Due:** 2026-11-10 **Object:** Item structures **Method:** FBDI **Owner:** A. Rao **Cycle:** Mock 1 **Source:** 9200 **Loaded:** 8800 **Errors:** 380 **Due:** 2026-11-12 **Object:** Suppliers and sites **Method:** FBDI **Owner:** S. Khan **Cycle:** Mock 1 **Source:** 1250 **Loaded:** 1230 **Errors:** 20 **Due:** 2026-11-14 **Object:** On-hand balances **Method:** FBDI **Owner:** P. Lee **Cycle:** Mock 2 **Source:** 24000 **Loaded:** 23880 **Errors:** 120 **Due:** 2026-11-24 **Object:** Open purchase orders **Method:** FBDI **Owner:** S. Khan **Cycle:** Mock 2 **Source:** 780 **Loaded:** 760 **Errors:** 15 **Due:** 2026-11-26 **Object:** Open work orders **Method:** REST **Owner:** M. Diaz **Cycle:** Mock 2 **Source:** 420 **Loaded:** 390 **Errors:** 28 **Due:** 2026-11-28 **Totals:** #### Total source records **Key:** source **Agg:** sum **Format:** integer #### Total loaded **Key:** loaded **Agg:** sum **Format:** integer #### Total errors **Key:** errors **Agg:** sum **Format:** integer #### Total unaccounted **Key:** gap **Agg:** sum **Format:** integer **Summary:** #### Overall error rate % **Key:** overall_rate **Expr:** if(gt(sum_source,0), sum_errors / sum_source * 100, 0) **Format:** decimal **Primary:** true #### Objects tracked **Key:** objects **Expr:** count **Format:** integer **Notes:** A non-zero Unaccounted value means records were neither loaded nor reported as errors: investigate before the next cycle. Use one row per object per cycle. ## Content **Intro:** Data conversion decides most Oracle Fusion go-live dates, and it fails quietly when nobody reconciles counts. This worksheet tracks every object per mock cycle and shows error rates and unaccounted records automatically. **Sections:** #### How to use the tracker **Body:** Add one row per object per cycle. Enter source records extracted from legacy, records loaded and records in error. The sheet computes the error rate and the unaccounted records, which is source minus loaded minus errors. Export to Excel for the weekly steering pack, or share the PDF. **Bullets:** - One row per object per cycle - Fill owner and target date from the start - Investigate every non-zero Unaccounted value #### The reconciliation logic **Body:** Every record in a load should end in exactly one of three states: loaded, errored, or deliberately excluded. Unaccounted records reveal filtering bugs, dropped rows or partial loads. Error rate is errors divided by source records, shown as a percentage. Falling error rates across Mock 1, 2 and 3 are the evidence of a converging process. #### Common mistakes **Body:** Teams track only loaded counts and miss silent drops. Others compare counts but never compare values such as on-hand quantity or valuation. Counts are necessary but not sufficient, so add value reconciliation for inventory, open orders and balances in a separate tab. **Bullets:** - Reconcile quantities and values, not only counts - Keep error reasons categorized for root cause - Freeze extract logic between cycles **Cta:** If conversion reconciliation is slowing you down, we can show how a private AI assistant helps classify load errors and compare legacy and Fusion balances. **Faq:** #### What error rate is acceptable? **Answer:** There is no universal number. Early mocks often show several percent. The goal is a steadily falling rate and zero unaccounted records, with remaining errors understood and either fixed or consciously excluded by the data owner. #### How many mock loads should I plan? **Answer:** At least three cycles are common for core objects, with a final dress rehearsal. Complex objects such as open work orders and on-hand balances may need more because they depend on cutover timing. #### Does this replace the FBDI error reports? **Answer:** No. Oracle import processes provide detailed error output. This worksheet summarizes outcomes so management can see progress and spot trends across objects. #### Can I add more columns? **Answer:** Export to Excel and extend it with columns such as error category, fix owner and re-run date. Keep the same row structure so the formulas remain valid. ## Search terms oracle fusion data conversion tracker, data migration tracker excel, oracle fusion data migration plan, fbdi load tracker, erp data conversion status template, oracle cloud data load reconciliation, mock load tracker, data conversion error rate --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json