Clear An Oracle Fusion ESS Job Stuck In Blocked Status
Oracle Fusion ESS job stuck in Blocked status
Also searched as
- ESS scheduled process stuck in Blocked Oracle Fusion
- Enterprise Scheduler job wont run again Blocked
- Oracle Fusion scheduled process pending forever
- why is my ESS job Blocked not Running
Short answer
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.
Applies to: Oracle Fusion Cloud ERP and HCM, standard and custom ESS jobs, all monthly updates
Clear a Blocked scheduled process
- 1Open Navigator > Tools > Scheduled Processes and search by job name across all statuses, not just your own submissions.
- 2Sort by Status and find the earlier request still shown as Running, or one stuck for an unusually long time.
- 3Open that earlier request; if it is genuinely hung (no progress, no growth in the log), use Actions > Cancel Process to end it.
- 4Watch the Blocked request - it should move to Running automatically within a minute or two once the blocking request clears.
- 5If it does not move, refresh the Scheduled Processes list; some UI sessions cache a stale status.
- 6For a recurring conflict on a custom ESS job you own, open the job definition and check whether simultaneous execution is disabled by design.
- 7For Oracle-delivered jobs such as Create Accounting or Import Payables Invoices, treat single-threading as expected product behavior rather than a bug, and stagger submissions instead of trying to force parallelism.
Why Blocked Exists
ESS enforces this to protect data integrity: two instances of Create Accounting or Import Journals running for the same ledger and business unit at once could double-post or deadlock. Blocked is ESS deliberately holding the newer request instead of letting the two race against each other.
Blocked vs Error vs Warning vs Running
Running means the process is actively executing. Blocked means it is queued behind an identical or conflicting request. Error means it ended with a failure. Warning means it completed but some rows or lines were rejected. Confusing Blocked with Error wastes time chasing a fix that does not exist - the correct response is simply to clear or wait out the blocking job, not to resubmit or reconfigure anything.
When The Blocking Job Is Itself Hung
Sometimes the earlier Running job is not actually progressing. Check the View Log timestamp for the last update; if it has not changed well beyond the job's normal runtime, cancel it. If cancel does not work from the UI, Oracle support can force-close a genuinely hung server-side ESS process.
Custom ESS Jobs And Parallelism
For custom BI Publisher-based scheduled processes you control, the job definition has an option controlling whether multiple instances can run concurrently. Turning this on is appropriate for read-only reporting jobs but risky for anything that writes data, since it reintroduces the exact race condition Blocked exists to prevent.
Common pitfalls
- !Repeatedly resubmitting the Blocked request, which just creates more requests stuck behind the same blocker.
- !Cancelling the earlier job when it was actually still doing useful work, leaving a partial data state.
- !Assuming Blocked means a permissions or scheduling configuration problem when it is almost always a concurrency lock.
- !Not checking across all users - a colleague's identical job submission can block yours even though you may only be looking at My Processes.
- !Forcing parallelism on standard financial posting jobs to make blocking go away, which risks duplicate postings.
How an ERP-grounded AI assistant handles this
ERPray can watch Scheduled Processes on your behalf and tell you immediately whether a stuck request is Blocked behind an identifiable earlier job, or genuinely hung, by reading the process log timestamps and job definition concurrency settings - so you are not manually cross-checking three different processes to figure out which one is actually the problem.
Frequently asked questions
Does Blocked count against my scheduled process quota or history?
The Blocked request still shows in Scheduled Processes history like any other, but it consumes no server resources while waiting; it is a queue placeholder, not an active execution, so it will not slow down unrelated jobs.
Can I reorder which Blocked job runs first?
Not directly from the UI. ESS generally processes blocked requests in submission order once the conflict clears. If sequence matters, cancel and resubmit only the job you need first, or coordinate submission timing with whoever owns the other job.
Why does Create Accounting always seem to block itself?
It is scoped tightly per ledger and business unit by design to avoid double-posting journals. If you see it blocked often, it usually means someone is submitting it repeatedly for the same scope before the prior run finishes, rather than checking status first.
Is Blocked the same as a job stuck at 0 percent for hours?
No. A job that shows Running but stays at 0 percent with no log growth for far longer than normal is hung, not Blocked, and usually needs to be cancelled and resubmitted rather than waited out.
Related
Fix FBDI Import Failures From Interface Table Validation Errors
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.
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.
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.