Oracle EBS Inventory Period Close Checklist
Closing an inventory accounting period in Oracle EBS is easy to start and easy to block. Pending transactions, uncosted rows or unprocessed receipts will stop the close or push errors into the next period.
0 of 31 items complete
10 critical items still open - these are the highest-risk gaps.
Before you start
Pending and uncosted transactions
Receiving and purchasing
WIP and costing
Close and reconcile
Steps and window names vary by release and by which modules you license. Adapt the list to your own close calendar and test it in a non-production instance before the first live close.
Close blocker dashboard
Optional: we can show how a read-only view over your EBS data flags close blockers early.
Optional. The tool and every export work without this. No spam.
How to use this checklist
Work through the groups in order and tick items as they are completed. The items marked critical are the ones that most often block a close or lead to a reconciliation gap. Print the checklist or export it to PDF and attach it to the close file so an auditor can see what was done and who signed off.
Why pending transactions matter
Oracle will not let you close a period when material transactions are still pending, uncosted or in error in the interface. Resolving them early in the close calendar is the single most effective way to avoid last-minute surprises. Treat the interface tables as part of the daily routine, not a month-end task.
- Interface errors: fix at source or purge
- Uncosted: confirm the Cost Manager is running
- Receiving: process pending deliveries
- WIP: resolve pending move and resource rows
Reconciling to the ledger
After you close, the inventory value, WIP value and accrual balances should agree with the general ledger. Differences normally come from transactions posted to GL late, manual journals against control accounts or mismatches between cost methods. Investigate in this order: unposted subledger entries, manual entries, then valuation differences.
Common mistakes
Closing inventory before receiving and WIP is done leaves accounting pointing at the wrong period. Another mistake is closing jobs with open charges, which pushes variance into the next period. Finally, skipping the reconciliation means errors only show up in the following month, when the context is gone.
Frequently Asked Questions
Can I close Inventory before WIP and Purchasing?
Oracle supports separate period statuses by module, but the sequence matters. Most companies close receiving and WIP first so that the inventory close reflects all of their activity.
What blocks the inventory period close?
Pending material transactions, uncosted transactions, unresolved interface errors and pending shipping or receiving rows are the usual blockers. The Resolve Pending Transactions window shows many of them.
Can a closed inventory period be reopened?
Oracle provides a reopen option in some releases, with restrictions. Policy often requires approval, so plan the close carefully and test reopen behaviour in a non-production system.
How often should we run this checklist?
Every period, with the same owner and a date for each step. Update the list after any change to modules, plants or cost methods.
If your close takes days of manual reconciliation, we can help build read-only checks over your EBS data that flag blockers before close day.
Related Tools
Oracle EBS Inventory Transaction Types Reference
Quick lookup of common Oracle Inventory transaction types, their IDs, source types and effect on on-hand quantity.
OracleOracle EBS Discrete Job Statuses Reference
Look up every Oracle WIP discrete job status, its numeric code, what transactions it allows and the usual next step.
OracleOracle EBS WIP Accounting Class Reference
Understand Oracle WIP accounting class types and which valuation and variance accounts each class uses.
Developer ToolsOracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
More Oracle tools
See all- Oracle EBS Item Attribute Template Worksheet
- Oracle EBS MRP Exception Messages Reference
- Oracle EBS BOM Interface Load Worksheet
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
- Oracle EBS Routing and Operations Load Worksheet
- Oracle EBS Inventory Organization Parameters Setup Template
- Oracle EBS Item Cost Update Request Form
- Oracle EBS Engineering Change Order Request Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS Pending Transactions SQL Generator for Period CloseBuilds SQL that counts and lists pending, errored and uncosted transactions in inventory and WIP before you close an Oracle inventory accounting period.
- Oracle EBS GL Period Close ChecklistA month-end close sequence for Oracle General Ledger and the subledgers that feed it, with critical steps marked.
- Oracle EBS WIP Job Close Variance WorksheetEditable worksheet to review material and resource variances per discrete job before running the close, with variance percent and totals.
ERP fixes and how-tos
- How to Close an Inventory Accounting Period in Oracle EBSClose an Oracle EBS Inventory accounting period: clear pending transactions, run the pending transactions report, close via Inventory Accounting Periods, transfer to GL.
- Oracle EBS Month-End Close Checklist: GL, AP, ARStep-by-step Oracle EBS month-end close order: finish sub-ledger transactions, close AP and AR periods, transfer to GL, reconcile, then close GL. Menu paths included.
- Fix Oracle EBS Uncosted Material Transactions Blocking Period ClosePeriod close blocked by uncosted material transactions? Find rows with COSTED_FLAG N or E, read the ERROR_EXPLANATION, fix costing setup and rerun the Cost Manager in EBS.
Runs with your ERP
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- Oracle Mobile Supply Chain Applications (MSCA) for Oracle EBSOracle Mobile Supply Chain Applications (MSCA) for EBS: native RF transactions for inventory, WMS and manufacturing, setup, pitfalls and where private AI helps.
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
AI on your ERP
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
Integrations
- How to build a mobile app for Oracle E-Business SuiteBuild a shop-floor or field mobile app for Oracle E-Business Suite: barcode scanning, WIP and inventory moves, approvals and offline use over ISG and supported APIs.
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.