Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

How to update cycle count entries for serialized parts through CC interface

edited May 16, 2017 5:41PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 7 commentsAnswered

Hi

We are trying to update the CC entries through the interface ( the end user is using a hand held scanner to do the cc and the results are send to the MTL_CC_ENTRIES_INTERFACE), We then run the program " Import cycle count entries from open interface" to update the corresponding scheduled CC entries. We have worked out the details for regular (not serialized and none lot controlled) , and lot controlled parts.

But we are having the following issue with the serialized parts. First of all at least in our env, when a part is serialized, we get one single CC entry record for this part in the table mtl_cycle_count_entries and all the serial numbers associated with this cycle_count_entry_id is stored in a second table MTL_CC_SERIAL_NUMBERS. Now when we populated the MTL_CC_ENTRIES_INTERFACE with a record for such serialized part, the import program gives the error "Insert error: The specified item is under serial control and no serial numbers were entered for this count." I have tracked the code and it seems that

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center