August 1, 2018

Oracle Cycle Count

bishnupc / /

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

Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here