Cycle Count Records Not Interfaced Correctly When Using The Cycle Count Open Interface (Doc ID 868992.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When attempting to run MTL_CCEOI_IMPORT module: Import cycle count entries from open interface the following error occurs:
0 will be processed by the Import concurrent program.
No rows retrieved! Worker do not started.
Worker = 0
Rows/Worker

Further investigation shows that there are a number of records in mtl_cycle_count_entries MCCE table which are in uncounted status (entry_status_code = 1) but the corresponding adjustment transactions exists in MMT.

Cause

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