My Oracle Support Banner

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:

Oracle Inventory Management - Version 12.2.8 and later
Information in this document applies to any platform.


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.



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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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