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 MAY 15, 2016

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 <Note 367511.11) When WMS is not enabled and when using average costing, the cost group on the
the onhand quantity table should match the cost group in the
subinventory.

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

select moq.organization_id, to_char(NULL) as subinventory_code,
moq.cost_group_id, 'Average Cost issue' Data_issue
from mtl_parameters mp,mtl_onhand_quantities_detail moq
where mp.organization_id = &org_id
and moq.organization_id = mp.organization_id
and mp.primary_cost_method = 2
and mp.wms_enabled_flag = 'N'
and moq.cost_group_id <> mp.default_cost_group_id
group by moq.organization_id,moq.cost_group_id
union
select moq.organization_id,moq.subinventory_code,
moq.cost_group_id , 'Standard Cost Issue' Data_issue
from mtl_parameters mp,mtl_onhand_quantities_detail moq,
mtl_secondary_inventories msi
where mp.organization_id = &org_id
and moq.organization_id = mp.organization_id
and moq.subinventory_code = msi.secondary_inventory_name
and mp.organization_id = msi.organization_id
and mp.primary_cost_method = 1
and mp.wms_enabled_flag = 'N'
and moq.cost_group_id <> msi.default_cost_group_id
group by moq.organization_id,moq.subinventory_code,moq.cost_group_id;

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms