Negative Quantities In Item Cost History Form (Doc ID 2335587.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
Negative quantity is shown in New Quantity field of Item Cost history form(CSTQICCG) even though negative balance is not allowed in organization parameter.

EXPECTED BEHAVIOR
Show correct quantity in New Quantity field of Item Cost history form.

STEPS
The issue can be reproduced at will with the following steps:

1. Negative Balance is not allowed on organization parameter.
   Inventory > Setup > Organizations > Parameters > Inventory tab : disable Allow Negative Balance.
2. Initial balance of Item A is 1.
3. 264 units of Item A are received into inventory as a result of WIP Completion on job A.
   Transaction_id=1000000
   Primary_quantity = 264
   Creation_date=2017/1/3 22:24
   Transaction_date= 2017/1/3 22:24
4. 41 units of Item A are issued fro inventory as a result of WIP Issue on a different job, job B.
   Transaction_id=2000000
   Quantity = 41
   Creation_date=2017/1/3 22:25
   Transaction_date= 2017/1/3 22:23
5. Cost Manager launched and a single cost worker proceeded the two transactions.
6. Navigate to Cost Management > Item Costs > Item Cost History form, then New Quantity is shown as -40 on Transaction_id=2000000.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.