Cannot Find Items On Cycle Count Entries Form For Old Pending Approval, Uncounted, And Recount Cycle Counts But See Items Still Exist Via SQL (MTL_CYCLE_COUNT_ENTRIES) (Doc ID 2947908.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

Old Cycle Counts in various statuses (Pending Approval, Uncounted, Recount) do not appear in Cycle Count form but appear via SQL.

The "Old Cycle Counts" would mean pending counts from a few months back.

STEPS - Form : Do not find items on cycle count via form.

1. Navigate to Inventory > Counting> Cycle Count Entries form > Query cycle count name and enter date

2. Some expected pending cycle counts are missing.

STEPS - SQL: Do find items in SQL.

1. Confirm the cycle count header id with SQL based on the cycle count name:

3. Users noted that they see more cycle count entries via SQL that they saw on the Form.

Changes

Found that the item setup was changed. The item was changed from cycle count enabled = Yes to No. 

Cause

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