Issue transaction was put on hold to avoid generating negative inventory

No onhand in the VALUATION UNIT to deplete + cost profile Process Negative Quantity = NEVER.

1. First rule out the setup trap: an Asset/Expense flag mismatch on the subinventory can fake this error (see the ref note)
2. Run the first SQL below to list exactly which transactions are stuck
3. Run the second SQL per item to confirm onhand really was missing at that date, in that valuation unit
4. Replenish: create a misc receipt for the missing quantity, in the SAME valuation unit, dated inside the processor's cutoff
5. Run Transfer Transactions from Inventory to Costing, then the cost processor, the frozen issue thaws
6. If the transfer's own receipt leg later restores the quantity, misc-issue your replenishment back out to true-up onhand

• Cost Accounting work area, Review Cost Accounting Distributions (Transaction Errors tab)
• Inventory Management → Create Miscellaneous Transaction
• Navigator, Tools, Scheduled Processes → run “Transfer Transactions from Inventory to Costing”
• Cost Accounting work area, Create Cost Accounting Distributions (the cost processor)

Which transactions are stuck on negative onhand?

select transaction_date, transaction_id, transaction_quantity, inventory_item_id, organization_id from inv_material_txns where transaction_id in (select cte.external_system_ref_id from cst_transaction_errors cte, cst_cp_errors ce where cte.cp_error_id = ce.cp_error_id and ce.error_code in ('CST_CPROC_UNRESOLVED_NEG_INV','CST_QTYFL_NEVER_PENDING') and ce.request_id = &request_id)

Was there really onhand at that date?

select sum(transaction_quantity) from inv_material_txns where inventory_item_id = &item_id and organization_id = &org_id and transaction_date <= to_date('&txn_date','YYYY-MM-DD HH24:MI:SS')

Read-only diagnostic queries. Substitute the bind values for your instance; run in a test environment first.

My Oracle Support document IDs for readers with access: 2187643.1 · 2261010.1. We do not reproduce their content.

• Perpetual average cost was not found (outgoing)
• Existing layer cost was not found, actual cost (incoming)
• The standard cost for this transaction does not exist
• Receiving transaction information is missing
• See all cost processor errors and fixes