Why Is the Allocation Not Meeting the Net Need When Available Quantity Is Above Net Need? (Doc ID 1983346.1)

Last updated on MAY 03, 2023

Applies to:

Goal

After calculating the allocation the Allocated Quantity (60) does not meet the Net Need value (70), even though there is plenty of Available Quantity (3000). All the inventory is in non sellable complex pack of 10 units each.   Why is the Allocated Quantity not being met?  

Example Steps to Reproduce:

1. Create fashion item with 4 color and 6 sizes 
select * from item_master where item_parent in ('100008003') order by diff_1,to_number(diff_2);
select * from item_master where item in ('100008003') ;

2. Create 1 non sellable fashion pack for one of the colors 
select * from packitem_breakout where pack_no in ('100008257');
select * from item_master where item in ('100008257');

3. Create a PO for the above created pack for 300 units 
select * from ordhead h,ordsku k,ordloc l
where h.order_no=23456
and h.order_no=k.ORDER_NO
and h.ORDER_NO=l.ORDER_NO
and k.ITEM=l.ITEM;

4. Create Corporate Rule
select * from alc_corporate_rule_head where CORPORATE_RULE_ID in (210);
select * from alc_corporate_rule_detail where CORPORATE_RULE_ID in (210);

5. Create size profile in the ratio of 2:4:6:8:10:12::1:1:1:1:1:1 
select * from alc_size_profile where store=1111 and style in ('100008003') and size1='BLUE' order by size1,size2;

6. Start creating allocation
PO=23456
LOC=1111
RULE=CORPORATE_RULE='TEST_AQ_NN'
Uncheck Quantity Limits(QL) (No QL Specified)
Calculate the Allocation

7. Check on the allocation 
Check on allocation 9876
Aval Qty =3000 Units
All the inventory is in non sellable complex pack of 10 units each
Net Need=70 Units
Allocation Quantity=60

The expectation is that Allocated Quantity should be 70.

Solution

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