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
Learn Oracle 