Cycle Count Not Picking Up Enough Items But No Errors Are Displayed (Doc ID 2515770.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

On : 12.2.4 version, Cycle count

ACTUAL BEHAVIOR
---------------
Cycle Count Not Picking Up Enough Items

We have automatic scheduling of cycle counts enabled, and we generate counts every Monday.

Our cycle count calendar ends on 11/30/2018.

That means there will only be 3 more days of counts getting generated (11/12/2018, 11/19/2018, 11/26/2018).

The cycle count scheduler has been generating approximately 227 counts every Monday this year.

However, we have over 1000 items that still need counts generated.

We are concerned that not all items will get counted.

The problem is that the average number of counts getting generated each Monday (107), multiplied by the number of Mondays remaining in November (2), is significantly less than the total number of unscheduled counts remaining (890). 107 * 2 < 890

----------------------------------------------------------------

The majority of items are added to the cycle count when we set up the new cycle count headers each year. We run ABC Initialization on the ABC Assignment Group via the following navigation:

Counting > Cycle Counting > Cycle Counts > (query cycle count header) > Open > Adjustments and ABC > (in the ABC Initialization Option field, select Reinitialize and click save)

Additionally, users set up a few new items throughout the year, and those items individually get added to the cycle count via the following two steps:

Add item to ABC Assignment group:
ABC Codes > Update Item Assignments

Add the item to the Cycle Count Header:
Counting > Cycle Counting > Cycle Counts > (query cycle count header) > Open > Adjustments and ABC > (in the ABC Initialization Option field, select Update and click save)

1. Output of:

select a.inventory_item_id,a.abc_class_id,msi.cycle_count_enabled_flag
from mtl_abc_assignments a, mtl_system_items msi
where a.assignment_group_id = 1004
and msi.organization_id = NNNN
and a.inventory_item_id = msi.inventory_item_id

Shows 878 of the items in the ABC Control Group are not cycle count enabled.


2. Output of:
SELECT segment1, inventory_item_id
FROM mtl_system_items_b WHERE inventory_item_id IN ( SELECT
inventory_item_id
FROM mtl_cycle_count_items WHERE cycle_count_header_id = NNNNN
AND cycle_count_enabled_flag = 'N'
AND organization_id = NNNN;

Shows 179 items that the customer expected to be in this cycle count but that are NOT cycle-count enabled.

4. Parameters used:

CYCLE_COUNT_HEADER_NAME = XYZ 2018 Cycle Count
CYCLE_COUNT_HEADER_ID = nnnnn
ORGANIZATION_ID = NNNN
ABC_ASSIGNMENT_GROUP_ID = XXXX
LAST_UPDATE_DATE = 11/12/2018 09:41:53
CALENDAR = CALENDAR_NAME_FOR_THIS_NOTE
LATE DAYS = 60
STARTING SEQUENCE = 4914
UNSCHEDULED ENTRIES checked
SPECIFIC SUBINVENTORIES checked
SERIAL COUNT not allowed
AUTOSCHEDULE = weekly
COUNT ZERO QUANTITY checked
LAST DATE = 12-NOV-2018
NEXT DATE = 19-NOV-2018

5. Output of select * from mtl_cycle_count_items where cycle_count_header_id = NNNNN shows:

4354 items.
33 items added in November alone.
2 classes used here - 29 and 30

Changes

Cause

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