Why Is the Allocation Not Meeting the Net Need When Available Quantity Is Above Net Need?
Last updated on APRIL 11, 2018
Applies to:Oracle Retail Allocation - Version 13.2.6 and later
Information in this document applies to any platform.
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
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
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
The expectation is that Allocated Quantity should be 70.
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