ITPub博客

首页 > 数据库 > Oracle > cycle count

cycle count

Oracle 作者:灵蛇之珍珠 时间:2015-09-11 14:36:19 0 删除 编辑
R12 and 11i Troubleshooting Guide for All Cycle Count issues: No Data Returned or Cycle Count Not Picking Up Enough Items (Doc ID 732843.1)

Note:
When AutoSchedule is set to "Daily" then the NWorkingDays is set to "1"
When AutoSchedule is set to "Weekly" then the NWorkingDays is set to "5" 

Client cannot understand why they receive only 1 or 2 items to count. They expect at least 30 or 40 items to count.

Answer: The client does not understand the formula behind the functionality.

The formula is:
MaxItemsToSchedule = (TotalItemsInClass * NWorkingDays)/ClassCntInterval 
ClassCntInterval = NumWorkDaysThisYear / NumCountsPerYear

TotalItemsInClass = 100
NWorkingDays = 1
NumWorkDaysThisYear = 260
NumCountsPerYear = 4

Max items to schedule = [(Total items in class * ClasscountInterval) / ( Number of working days in a year / Number of counts / year for that class ) ] + 1 

Therefore atlas we algebraically have arrived at  [(100 * 1 ) / (260 / 4) ] + 1 which is solved by

100*1 = 100
260/4 = 65
100/65= 1.53
The rounded value of 1.53 = 2

Therefore about Max items to schedule = 2 counts; functionality is working correctly.


An item has zero quantity when there is no more of that item in its counted location(s), often from depletion in which either reorders were not initiated or fulfilled.

How can new items be added to a ABC and or Cycle Count

-------------------------------------------------------------------------

a. Add items manually to the  Cycle Count
b. Add the items mannually to the ABC group then update or re-initailize the Cycle Count  
c . Create new compile and abc group then update or re-initailize the Cycle Count  

Oracle does not automatically add new items/subinventory to ABC or Cycle Count



Reinitialize versus Update:
----------------------------
Do not reinitialize everyday as this is the incorrect usage of the application. Re-initialize deletes all and re-loads. Update will update the items. Re-initialize is not the way to add new items, end users should be using update instead. Everytime re-(initialization) is run on the cycle count, all historical counts are erased and the system assumes it has the total number of counts to perform. This could cause an increase of items selected for count on any given day.





来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29686022/viewspace-1797248/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: xml report error
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2014-05-31

  • 博文量
    9
  • 访问量
    16400