Oracle Cycle Count

Step by Step Cycle Count in Oracle Warehouse

ABC Compile: 

It sorts the items in descending order in the subinventory or org based on the selection criteria

• Define the ABC compile based on need 
• Select subinventory/organization 
• Select criteria to choose current onhand or historical transactions 
• Once defined, click on compile. It will submit a request and will generate a sorting output list of items 

ABC Assignment Groups:

• Create an assignment group 
• Assign the ABC compile 
• Attach the ABC classes 
• Then Click on Assign Items 
• Select sequence to classify the items into A B C classes 
• Then click on Assign. It will submit a request 
• Once request is completed, you can see how items are classified by clicking on Update Items 

Define Cycle Count

• Define Cycle count based on need 
• Give Adjustment account 
• Enter late Days: after how many days uncounted cycle count will be considered as late count 
• Starting seq: This is the staring number of the count 
• Enter all other details as needed 
• in Serial, LPN and Schedule tab, 
• select the serial controlled count options 
• Select the schedule, if you want to schedule the count 
• In Adjustment and ABC, 
• select approval criteria 
• Give the ABC group created earlier 
• In Option, select reinitialize and save, it will submit a request. Once the request is completed, you can see status will be completed in the cycle count as well. 
• Then click on Classes and enter the no of counts you want to do for each class in a year 
• From Tools –> Select Perform Full Cycle Count, it will submit request set, submit with proper parameter 
• Once the request is completed, go back to cycle count and re-query and click on items, you will see last scheduled date should be populated against items 
• Also in Serial, LPN and Schedule tab, you see Last date and Next date is populated as per the schedule 

Cycle Count Entry

• Now Go to cycle count entry form, select the cycle count header name and then find all open counts 
• It will show all open request counts pending 
• You can either use this form or you can directly go to MSCA –> Inventory –> Counting –> Normal for entering the counts against the records 
• Also you can count using WMS Task feature by going to MSCA, Task –> Directed task –> Warehouse –> Counting 

Approve Count

• Go to Approve Count section post counting 
• It will show all pending approval including adjustments if needed 
• Select the option and save 

View Adjustments in material transactions