Oracle E Business Suite: Inventory-Cycle Counting class /25

Cycle counting is the periodic counting of items in the course of the year to ensure the accuracy of inventory quantities managing supply and demand, and planning production. You have to identify ABC class items to identify groupings like High class, Medium class, Low class items. While later you assign items of higher rank to high class, lower rank to medium class, and lowest rank to lower class. Cycle counting is the method of maintaining physical inventory updated and in consideration you can verify both the quantities and values.

Examples Can be given on the bases of this :

  • Class A items shall be counted 4 times a year
  • Class B items shall be counted 2 times a year
  • Class C items shall be counted once a year

Steps required for cycle counting for ABC Analysis

  1. Creating ABC Compile: The compilation Criteria is based on simple implications of current on hand quantity, current on hand value, Previous cycle count adjustment quantity, Previous cycle count adjustment value. These provisions makes it possible to complete the cycle count.In this criteria you have to select organization, and the sub-inventory,and the plan name from date and to date are required for specific criterion. After that you can save your work and execute the compile. And verify that the status of the report is normal.
  2. Generate ABC Descending value Report :  As the items are being compiled then the customer Descending value report is being generated and you can view the output button and if needed take the print of the report.
  3. Define ABC Class: The criterion will be the same
Class Name Description
Class A High Value
Class B Medium Value
Class C Low Value


In this You define the class of an item like class A, B, C as high, medium, and low value. The categorization will be done in a view that most frequently used item, then medium used and lastly minimum used item of the frequency table. In a manufacturing unit cycle counting is most unique way of counting items and minimizing wastage. As per my experience I worked for Jindal pipes limited where there was cycle count is done manually. And afterwards with launch of ERP system in Unit everything became online and handpicked.



There are various types of Cycle Count Scheduling is in the process:

  1. Automatic Scheduling: Oracle Inventory uses number of items of cycle count and workday calendar of the organization to determine how many and which items you need to count. For automatic scheduling these are the necessary prerequisites :
  • Select the item attribute to yes for the item you want to include in cycle count
  • While defining cycle count you must enable scheduling
  • Request the schedule using automatic generate schedule windows

As your schedule is for weeks then all the items you have selected will be counted on all of the    workdays of the week. And if your schedule is days then inventory only schedules those items that are due for counting on current date.

2    Manual Scheduling: It can be done most frequently where you can request counts for specific sub-inventories , items, or locators. This will give you insight of the item and the extracted data to the optimum level of cycle counting.

3 Physical Scheduling: You can use this feature for counting each sub-inventory and locator.

There are 3 different levels which you can set cycle count tolerance:

  • Items attribute windows
  • Items Class Definition
  • Cycle Count Header

When determining for approvals the system first checks item attributes, and if no item tolerance is defined then the system item class definition and at last if item class definition is not defined then it will check cycle count header count.

As you have scheduled your counts you can submit the process to generate count request. After the scheduling the count it generates count request for each item number, revision number, lot number. After that oracle assigns unique sequence number that can be used for reporting, querying , and rapid count entry.

If you have questions, please ask below

Leave a Reply

If you have any questions headover to our forums

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <code> <em> <strong>