# How to Close an Inventory Accounting Period in Oracle EBS

> Source: https://netray.co/erp-help/ebs-inventory-period-close-how-to
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

Before closing an Inventory period, run the Pending Transactions report to clear every uncosted or erroring material transaction, then close through Inventory > Accounting Close Cycle > Inventory Accounting Periods. Inventory will refuse to close while pending transactions remain, and any that get force-closed into the next period will misstate both months' costed inventory value.

## Kind

how-to

## System

oracle-ebs

## Erp

Oracle E-Business Suite (EBS)

## Module

Inventory / Cost Management

## Query

how to close inventory period in oracle ebs

## Alternate Queries

- ebs inventory accounting period close
- oracle inventory cannot close period pending transactions
- ebs inventory period close checklist
- how to fix pending transactions before closing inventory period

## Applies To

EBS 12.1.3 and 12.2.x, standard and average costing

## Steps

### How to close an Inventory accounting period

**Items:**

Confirm all receiving, shipping, and internal move transactions for the period have been processed - late transactions dated in a closed period get re-dated forward and distort cost.

Run the Pending Transactions report (Inventory > Reports > Cost or Cost Management > Cost Comparison, depending on version - the report is also accessible from the Inventory Accounting Periods form itself) to find transactions stuck in an error or unprocessed state.

Resolve each pending transaction: reprocess it from Inventory > Transactions > Pending Transactions, or investigate the specific error (commonly a missing standard cost, invalid account, or WIP resource cost not defined).

If you run WIP, close the WIP accounting period first (or confirm it is aligned) since open WIP transactions can leave associated inventory transactions pending.

Open Inventory > Accounting Close Cycle > Inventory Accounting Periods, select the period, and choose Close; the form re-validates that zero pending transactions remain before allowing the status to change.

Review the Period Close concurrent request log for warnings even after a successful close - transactions that were force-moved to the next period will be listed there.

Run Create Accounting for Cost Management (if using SLA) to transfer costed transactions to GL, and reconcile the Inventory Valuation report against the GL inventory account balance.

## Sections

### What a pending transaction actually is

**Body:**

A pending transaction is a material transaction (issue, receipt, transfer, cycle count adjustment, and similar) that has been recorded in the inventory tables but has not yet been costed - it has no completed cost accounting entry attached. Until every transaction in the period reaches a costed state, Inventory Accounting Periods will not allow the close, because closing with pending transactions would either lose the cost impact or silently push it into the wrong period.

The most frequent causes are a missing or zero standard cost on an item at the time of the transaction, a disabled or invalid GL account on a subinventory or account alias, and WIP resource or overhead costs that were never defined before a job transaction posted against them.

### Finding and fixing the blockers

**Body:**

Run the Pending Transactions report first rather than attempting the close and reading a generic failure - the report lists the transaction ID, item, and the specific processing error, which is almost always enough to diagnose the root cause without opening a service request. A transaction failing for a missing item cost is fixed by defining the cost and resubmitting the Cost Manager (or Material Transaction Cost worker) so it reprocesses automatically.

For transactions failing on an account combination, correct the account in the source setup (subinventory, account alias, or the item's cost group) rather than editing the stuck transaction directly, then let the standard cost manager pick it up on its next scheduled or manual run.

**Code:**

SELECT transaction_id, transaction_type_name, error_explanation FROM mtl_material_transactions WHERE transaction_date BETWEEN :period_start AND :period_end AND transaction_id IN (SELECT transaction_id FROM mtl_transaction_accounts WHERE gl_batch_id IS NULL);

### Average costing versus standard costing differences

**Body:**

Under standard costing, a pending transaction is almost always a costing setup gap - the item, category, or cost group is missing the cost it needs. Under average costing, pending transactions more often stem from negative on-hand balances or out-of-sequence transactions, since average cost updates depend on the running quantity and cost being processed in the correct order.

If you are on average costing and see repeated pending transactions tied to negative quantities, check for a transaction that was backdated after a later transaction already processed - Cost Manager needs strict chronological order to keep the average cost calculation valid, and a backdated entry forces a reprocess of everything after it.

## Pitfalls

- Attempting the period close before running the Pending Transactions report, then troubleshooting blind from the generic close failure message.
- Force-closing a period that still has pending transactions by moving the transaction date forward, which shifts real cost impact into the wrong month.
- Missing that a WIP job transaction is the true blocker because it shows up as an inventory-side pending transaction, not a WIP one.
- Defining a missing item cost but forgetting to resubmit or restart the Cost Manager so the pending transaction actually reprocesses.
- Closing Inventory before Cost Management's Create Accounting has run, leaving costed transactions stranded in the SLA interface instead of GL.

## Ai Angle

SyteRay-style grounded assistants built the same way for EBS can query mtl_material_transactions and the cost worker error tables directly, then hand the cost accountant a plain list of which items are missing a standard cost or which account alias is disabled - turning a pending-transactions troubleshooting session that normally takes a functional consultant an hour into a two-minute lookup.

## Faq

### Why does Inventory Accounting Periods say I have pending transactions when the report shows zero?

**Answer:** The two checks are not always run at the exact same moment, so a transaction can complete costing between running the report and attempting the close. Rerun the Pending Transactions report immediately before closing, and rerun Cost Manager once more if any small gap remains.

### Can I close Inventory before WIP for the same period?

**Answer:** You can if there are no open WIP jobs generating inventory-side transactions that period, but in practice most manufacturing sites close WIP first since job completions and scrap transactions feed inventory costing. Confirm with your cost accountant before assuming the order does not matter for your setup.

### What happens if I never resolve a pending transaction and just leave the period open?

**Answer:** The period stays open indefinitely and every subsequent period close attempt will also fail its own pending-transactions check if the same underlying setup gap (like a missing item cost) keeps recurring. Fix the root cause rather than leaving periods open as a workaround, since open periods for months at a time complicate audits.

### Does closing the Inventory period automatically send costed transactions to GL?

**Answer:** No, closing the accounting period only stops new transactions from being costed into it. You still need to run Create Accounting (or the legacy Cost Collector transfer, on older setups) separately to move costed transactions from Cost Management into the GL interface and then post them.

## Search terms

ebs inventory period close, inventory accounting periods form, pending transactions report oracle inventory, ebs cannot close inventory period, oracle cost manager pending transaction, mtl_material_transactions pending, average costing pending transaction, ebs cost management create accounting, inventory close checklist oracle ebs

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json