Fix FBDI Import Failures From Interface Table Validation Errors
FBDI import failed - interface table validation errors
Also searched as
- Oracle Fusion FBDI import errors interface tables
- Correct Import Errors spreadsheet Oracle Fusion
- Load Interface File for Import failed Oracle Fusion
- FBDI Loader Worker ended in error
Short answer
When a Fusion FBDI import job errors out, the cause is almost always bad data in the interface tables (an invalid value set, a wrong date format, or a missing required column), not the ESS job itself. Open the process's Interface Errors Report or the Correct Import Errors spreadsheet to see the exact rejected rows and reason codes, fix the source data, and resubmit from the interface tables instead of re-running the whole FBDI load.
Applies to: Oracle Fusion Cloud ERP (Financials, SCM), all monthly updates; standard FBDI templates from the Oracle File-Based Data Import guide
Diagnose and fix a failed FBDI import
- 1Open Navigator > Tools > Scheduled Processes and find the import job (Import Journals, Import Payables Invoices, Import AutoInvoice, and similar).
- 2Click the process name, then View Log and View Output; look for "ended in error" or a count of rejected rows.
- 3Open the Interface Errors Report link on the process details page, or download the Correct Import Errors spreadsheet (ADFdi Excel) if the product offers one.
- 4Match each rejected row's error code to a real cause: invalid value set combination, wrong date format (FBDI expects YYYY/MM/DD as text), duplicate source document reference, or a business unit not enabled on the ledger.
- 5Fix the data either in the FBDI source spreadsheet and re-run Load Interface File for Import plus the product import job, or correct rows directly through the Correct Import Errors spreadsheet and resubmit only the corrected rows.
- 6Query the interface table directly (for example AP_INVOICES_INTERFACE, GL_INTERFACE, RA_CUSTOMERS_INTERFACE_ALL) through BI Publisher or OTBI if the UI report does not show enough detail.
- 7After a clean run, confirm the interface table is empty for your batch - leftover rows mean some records were never processed.
Why FBDI Errors Point At Data, Not The Job
FBDI (File-Based Data Import) loads a zipped CSV, generated from Oracle's macro-enabled XLSM templates, into standard Oracle interface tables using the same underlying validation the transactional UI applies. The file upload step itself rarely fails once the zip is well formed.
The ESS jobs Load Interface File for Import (stages the file into interface tables via UCM) and the product-specific import job almost never fail structurally; they fail because a row violates a rule the transactional screen would also enforce - an invalid GL segment combination, a supplier site not associated with the business unit, or a currency code that does not match the ledger.
Reading The Correct Import Errors Spreadsheet
Many Financials import flows - Payables invoices, Receivables AutoInvoice, GL journal import - expose a Correct Import Errors (or similarly named) ADFdi spreadsheet that lets you view, edit, and resubmit only the failed interface rows without regenerating the whole FBDI file. This is far faster than editing the original template and re-uploading everything when only a handful of rows failed.
Navigator > Tools > Scheduled Processes > (select failed import job) > View Output > Interface Errors Report
Common Root Causes By Module
Payables: the supplier site is not enabled for the invoicing business unit, or the invoice source name and number combination already exists as a duplicate.
General Ledger: the journal category and source combination is not defined for the ledger, or the accounting period is not Open.
Receivables: the transaction type is not assigned to the business unit, or an AutoInvoice grouping rule does not match the incoming lines, leaving them ungrouped and rejected.
When Interface Rows Get Stuck
Rows can be left in a New or Error status in the interface table after repeated failed attempts. Use the supported correction spreadsheet or the product's purge/delete process rather than deleting rows with ad hoc SQL, since orphaned control records and mismatched batch IDs are a common side effect of manual cleanup.
Common pitfalls
- !Editing interface table rows directly with SQL instead of the supported spreadsheet or UI - unsupported and can leave orphaned records.
- !Assuming a date typed as MM/DD/YYYY will import correctly - FBDI templates require YYYY/MM/DD as text, not an Excel date type.
- !Re-running Load Interface File for Import again after a partial failure, which re-stages rows and can duplicate what is already sitting in the interface table.
- !Ignoring a process that completed with warnings - some rows silently reject while others post successfully.
- !Forgetting that value sets and cross-validation rules differ per business unit and ledger, so a template that worked for one BU can fail for another.
- !Not checking whether the accounting period is open before troubleshooting the data - a closed period produces the same generic import-failed symptom.
How an ERP-grounded AI assistant handles this
ERPray grounded on your Fusion instance can read the actual Interface Errors Report and interface table rows for a failed FBDI run and explain, in plain language, which specific rows failed and why - cross-referencing the value sets, business unit setup, and period status behind the rejection instead of you tracing five error codes by hand across three setup screens.
Frequently asked questions
What is the difference between Load Interface File for Import and the product import job?
Load Interface File for Import only takes the zipped FBDI CSV from UCM and stages the rows into the target interface table, such as GL_INTERFACE. It does not validate business rules. The second job - Import Journals, Import Payables Invoices, and so on - actually validates and posts the staged rows, and it is where most real errors surface.
Can I fix rejected rows without regenerating the FBDI file?
Yes for most Financials imports. Products that expose a Correct Import Errors spreadsheet let you open, edit, and resubmit only the failed interface rows in place, which is much faster than rebuilding and re-uploading the whole template for a handful of bad rows.
Why do my dates import as the wrong day?
FBDI templates expect dates as plain text in YYYY/MM/DD format. If Excel auto-converts the cell to a date type, or your regional settings reformat it on save, the loader can misread day and month or reject the row outright. Format date columns as text before entering values.
The job says success but my data is missing - what happened?
Check the process output for a rejected-row count even when the overall status shows success or warning. Partial failures are common: some rows post cleanly while others sit rejected in the interface table with a reason code visible only in the Interface Errors Report or process log.
Related
Clear An Oracle Fusion ESS Job Stuck In Blocked Status
A Blocked status on an Oracle Fusion Enterprise Scheduler (ESS) job almost always means an earlier instance of the exact same job is still running or stuck, and the job definition does not allow simultaneous requests. Find and finish, or cancel, the earlier request first; only then does the Blocked request move to Running.
How-toOTBI vs BI Publisher: Which One Should You Use
Use OTBI when a business user needs ad hoc, self-service, real-time analysis with no fixed layout. Use BI Publisher when you need a pixel-perfect, scheduled, high-volume, or externally distributed document such as an invoice, check, or statutory report. Most Fusion implementations end up using both, not one instead of the other.
How-toPaginate And Authenticate Oracle Fusion REST API Calls Correctly
Oracle Fusion Cloud REST APIs authenticate with HTTP Basic Authentication, an integration user's credentials, over HTTPS by default, and paginate with limit and offset query parameters rather than a page number. Loop on the hasMore flag in the response until it returns false to retrieve a full result set.
Error fixFix The Oracle Fusion "You Don't Have Access To This Data" Error
This generic Oracle Fusion security message means the function privilege and the data security scope did not both line up for that user on that record - most often the job role is assigned but the matching data role, security profile, or business unit and ledger context in Manage Data Access for Users is missing. Fix it by checking data access setup for the user's role, not by re-granting the same job role again.
How-toHCM Data Loader Vs FBDI: Which One Loads Your Fusion Data
HCM Data Loader (HDL) is the dedicated bulk tool for HCM business objects - workers, assignments, compensation, absences - and uses a plain-text .dat file with METADATA and MERGE or DELETE action lines, not a spreadsheet template. FBDI is the general Financials and SCM bulk-load framework built on Excel macro templates that stage data into interface tables. If the object lives in HCM, use HDL; if it lives in Financials, Procurement, or SCM, use FBDI.
How-toConnect Oracle Integration Cloud (OIC) To Fusion ERP
OIC connects to Fusion ERP primarily through the prebuilt ERP Cloud Adapter, which wraps Fusion's REST and SOAP web services with OAuth-based authentication and pick-list discovery of available business objects and operations, instead of you hand-building every REST call. Use the adapter for standard integrations; drop to a generic REST or SOAP adapter only when the ERP Cloud Adapter does not yet expose the specific service you need.
AI for ERPFusion Cloud ERP AI: OCI Generative AI Service vs. a Private LLM
Oracle's OCI Generative AI Service is a real option for Fusion Cloud ERP, but not the only one. Compare it honestly against a private LLM for sensitive data.
AI for ERPOracle ERP AI Consulting: What a Partner Should Deliver
What to demand from an Oracle ERP AI consulting partner across EBS, JD Edwards, NetSuite, and Fusion Cloud: interface tables, APIs, and buyer questions.
Stuck on Oracle Fusion Cloud ERP?
Talk to engineers who work inside Oracle Fusion Cloud ERP every week, and who build private AI that answers these questions from your own ERP data.