INv: Unable to Issue Out On-hand Item with Project and Task: Direct Inter Org Transfer Gets "Transaction processor error Negative balances not allowed" but there is no Reservation For On-Hand (Doc ID 1684343.1)

Last updated on APRIL 18, 2023

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Direct inter org transfer
Direct org transfer for 1 item with no reservations ( available to transact = On hand)

get error:

"Transaction processor error Negative balances not allowed" but there is no reservation for on Hand

In the Material Workbench, the Project and Task columns are populated, plus the locator is project locator

You verified the project ans task are valid (ie project is open, task is valid task)

Primary_cost_method, 1 ( '1-Standard',2, '2-Average' ) ==> 2 per mtl_parameters

Org is not WMS enabled

Table mrp_project_parameters has the project_id and organization_id

Review this note:
Fix for Cost Group ID when Negative Balances Not Allowed Error Doc ID 367511.1 When WMS is not enabled and when using average costing, the cost group on the
subinventory.

Had customer run sql below to verify 1) and 2)

no rows, as this customer is case 1) - ie moq.cost_group_id = mp.default_cost_group_id

Standard Cost Query

MSN cost group should match MOQ cost group -

SELECT msn.serial_number , moq.inventory_item_id, moq.organization_id, moq.subinventory_code, moq.locator_id, moq.revision, moq.cost_group_id, msn.cost_group_id

FROM mtl_serial_numbers msn , mtl_onhand_quantities_detail moq

where msn.inventory_item_id = moq.inventory_item_id

and msn.current_organization_id = moq.organization_id

and msn.current_subinventory_code = moq.subinventory_code

and nvl(msn.current_locator_id, -1) = nvl(moq.locator_id, -1)

and nvl(msn.revision, -1) = nvl(moq.revision, -1)

and msn.cost_group_id <> moq.cost_group_id ;