Download the appropriate FBDI template (e.g., AutoInvoice Import for Receivables or Payables Standard Invoice Import) from Oracle's documentation or the ERP cloud Help portal; populate the CSV or XLSM sheets following column definitions exactly.
Upload the completed CSV file(s) to the Oracle Universal Content Management (UCM) server using the ERP Integration REST endpoint POST /fscmRestApi/resources/latest/erpintegrations with a multipart body containing the document content and document account (e.g., fin/payables/import).
Submit the load and import job by POST-ing to /fscmRestApi/resources/latest/erpintegrations with the operationName 'importBulkData' and job parameters specifying the ESS job name (e.g., APXIIMPT for Payables Invoice Import).
Poll the job status via GET on the returned jobId resource or use the ESS job monitoring endpoint until status is SUCCEEDED or FAILED.
Retrieve the ESS job output log and error report from UCM or the erpintegrations output endpoint; parse rejected row counts and error messages to resubmit corrected records.
Known gotchas
Column order in the FBDI CSV is fixed and positional; adding or reordering columns, even empty ones, causes the entire file to fail import without a useful row-level error.
The UCM document account must match the integration template exactly; uploading to the wrong account means the import job cannot locate the file and fails with a 'file not found' error in the ESS log.
Oracle Fusion quarterly updates sometimes change FBDI template column sets; validate templates against the current release documentation before each major use in production.
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp