cycle count
DESCRIPTION
Cycle CountTRANSCRIPT
![Page 1: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/1.jpg)
CYCLE COUNTING
ORACLE 11i
![Page 2: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/2.jpg)
Cycle Counting Cycle counting is the periodic counting of
individual items throughout the year. Count items of higher value more frequently than items of lower value.
Cycle counting is similar to performing physical inventory. You can use both techniques to verify the accuracy of on-hand quantities and values.
![Page 3: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/3.jpg)
Loading Cycle Count Items You must load items into your cycle
count before you can schedule or count them.
There are two methods you can use to do this:
Specify an existing ABC group from which to automatically load your items
manually enter, delete or update the items you want included/excluded
![Page 4: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/4.jpg)
Cycle Count Scheduling Manual
You can manually schedule counts in addition to, or instead of those generated with automatic scheduling.
You can request counts for specific subinventories, locators, and items, and set the count for any inventory date. For example, you could enter a request to count item A wherever it can be found in subinventory X. Or you could request to count all item quantities in subinventory Y, locator B–100.
![Page 5: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/5.jpg)
Define cycle count header
1
Update cycle-count items
2
Schedule items to count
3
Generate count requests
4
Enter cycle counts
5
Approve cycle counts
6
![Page 6: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/6.jpg)
![Page 7: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/7.jpg)
![Page 8: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/8.jpg)
![Page 9: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/9.jpg)
![Page 10: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/10.jpg)
![Page 11: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/11.jpg)
![Page 12: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/12.jpg)
![Page 13: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/13.jpg)
![Page 14: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/14.jpg)
![Page 15: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/15.jpg)
![Page 16: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/16.jpg)
![Page 17: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/17.jpg)
![Page 18: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/18.jpg)
![Page 19: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/19.jpg)
![Page 20: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/20.jpg)
Manual entry of quantity
![Page 21: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/21.jpg)
Manual entry of quantity
![Page 22: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/22.jpg)
![Page 23: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/23.jpg)
![Page 24: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/24.jpg)
![Page 25: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/25.jpg)
![Page 26: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/26.jpg)
![Page 27: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/27.jpg)
![Page 28: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/28.jpg)
![Page 29: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/29.jpg)
![Page 30: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/30.jpg)
![Page 31: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/31.jpg)
![Page 32: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/32.jpg)
![Page 33: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/33.jpg)
![Page 34: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/34.jpg)
![Page 35: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/35.jpg)
Cycle Count Scheduling Automatic
Oracle Inventory uses the number of items in each cycle count class, the count frequency of each class, and the workday calendar of your organization to determine how many and which items you need to count during the scheduling frequency.
Set the Cycle Count Enabled item attribute to Yes for the items you want to include in the cycle count.
Enable automatic scheduling when you define your cycle count.
![Page 36: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/36.jpg)
Cycle Counting Setup
Prerequisites Define the ABC classes. Define the workday calendar. When determining cycle count classes
based on ABC analysis, you must compile an ABC analysis and assign your compiled items’ ABC classes.
![Page 37: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/37.jpg)
Cycle Counting Setup Defining the Cycle Count
General Specify the name of the count Identify the calendar to use Specify the GL account for adjustments
Enter control and scope information Enter the Count Controls Determine Recount status of out–of–
tolerance counts Determine the subinventories to include
![Page 38: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/38.jpg)
![Page 39: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/39.jpg)
![Page 40: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/40.jpg)
![Page 41: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/41.jpg)
![Page 42: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/42.jpg)
![Page 43: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/43.jpg)
![Page 44: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/44.jpg)
![Page 45: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/45.jpg)
Approval Tolerances
Oracle Inventory supports two types of cycle count approval tolerances, Quantity Variance Tolerance and Adjustment Value Tolerance. For each type, you can specify a positive and a negative limit which can differ from each other.
When a particular cycle count entry results in an adjustment that exceeds any one of these limits, you have a cycle count adjustment that exceeds approval tolerances.
Based on the approval option you choose when you define your cycle count, this adjustment is either posted automatically or held for approval.
![Page 46: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/46.jpg)
Quantity Variance Tolerance Quantity Variance Tolerance:
The quantity variance tolerance is a user-defined limit for the difference between the actual cycle count quantity and the system tracked on-hand quantity. You express positive and negative quantity variance tolerances as percentages of the system on-hand quantity.
You enter these percentages when you define your:
Cycle Count Header
Cycle Count Classes
Cycle Count Items
![Page 47: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/47.jpg)
Adjustment Value Tolerance Adjustment Value Tolerance:
The Adjustment Value Tolerance is a user-defined limit for the total value of a cycle count adjustment. The adjustment value is calculated as:
adjusted value = (count qty - system on-hand qty) * current item cost The Adjustment Value Tolerance is expressed as
positive and negative amounts in your functional currency. An adjustment value is out of tolerance if it falls outside of these amounts.
You enter these tolerances when you define your cycle count header and cycle count classes
![Page 48: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/48.jpg)
Hit/Miss Tolerance Hit/Miss Tolerance:
The Hit/Miss Tolerance is a user-defined limit for the difference between the system tracked on-hand quantity and the actual cycle count quantity.
You express positive and negative hit/miss tolerances as percentages of the system on-hand quantity.
A count is considered a “hit” if it is within these tolerances, and a “miss” if it is outside them.
The Hit/Miss Tolerance allows you to evaluate the actual accuracy of your inventory.
![Page 49: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/49.jpg)
![Page 50: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/50.jpg)
REPORTS
Cycle Count Scheduler Schedule Request Report Perform Cycle Count Cycle Count Listing
![Page 51: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/51.jpg)
![Page 52: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/52.jpg)
![Page 53: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/53.jpg)
![Page 54: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/54.jpg)
![Page 55: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/55.jpg)
![Page 56: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/56.jpg)
![Page 57: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/57.jpg)
![Page 58: Cycle Count](https://reader033.vdocuments.us/reader033/viewer/2022061117/5466d7fdb4af9ff5748b511b/html5/thumbnails/58.jpg)
Thank You!!!!