You are browsing the archive for Oracle Inventory.

9.2 ABC Assignment Groups

 

  • Form Application: Inventory
  • Form Name: INVADAGR
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADAGR.fmx

ABC Assignment Group connects the ABC compiles and ABC classes together. This helps in assigning items to ABC classes.

Navigation: Inventory responsibility -> ABC Codes -> ABC Assignment Groups

  • Enter the ABC ‘Group Name’
  • Enter the ABC ‘Compile Name’
  • Click on ‘Group Classes’
  • Enter Priority of ABC class
  • Choose the previously defined ‘ABC Class’ to assign to this group

Save the details. ABC Assignment group details along with ABC classes and ABC compile is saved.

ABC Assignment Groups

ABC Assignment Groups

9.1 Setup ABC Classes

 

  • Form Application: Inventory
  • Form Name: INVADACL
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADACL.fmx

ABC classification of Items helps in cycle counting and management reporting. ABC classification can be based on count or value. Most common approach is based on current on-hand value.

Navigation: Inventory responsibility -> ABC Codes -> ABC Classes

  • Enter the ABC ‘Class Name’
  • Enter the ABC ‘Description’
  • Enter the ‘Inactive Date’ to end date a classification

Save the details. ABC classes you defined are saved. Now they could be used in ABC Assignment Groups.

ABC Classes

ABC Classes

 

 

 

 

 

 

 

 

9.0 ABC Compile

 

  • Form Application: Inventory
  • Form Name: INVAAACP
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVAAACP.fmx

ABC classification of Items helps in cycle counting and management reporting. ABC classification can have more than A,B and C classifications. ABC classification can be based on count or value. Value is the most preferred approach. A class items typically are high valued items, B class is medium valued items and C class is low valued items based on inventory valuation.

ABC compilation is a process where items, on-hand quantity and inventory value are calculated and arranged in ascending or descending order for classification into ABC classes.

Navigation: Inventory responsibility -> ABC Codes -> ABC Compiles

  • Click on ‘New’ to create a new compile
  • Enter the ‘Compile Name’
  • Enter the Compile ‘Description’
  • Scope of Compile – Select to compile at Inventory Organization or Sub-inventory. If sub-inventory select the sub-inventory code
  • Compile Criteria – Various criteria supported are
    • Current on hand quantity
    • MRP demand usage quantity
    • MRP demand usage value
    • DRP demand usage quantity
    • DRP demand usage value
    • MPS demand usage quantity
    • MPS demand usage value
    • Current on-hand value
    • Historical usage value
    • Historical usage quantity
    • Historical number of transactions
    • Forecasted usage value
    • Forecasted usage quantity
    • Previous cycle count adjusted value
    • Previous cycle count adjusted quantity
  • Select the ‘Cost Type’ for value calculation
  • Select ‘Forecast’ name if it is based on forecast usage
  • Select the MRP ‘Plan’ name if it is based on MRP Plan usage
  • Enter ‘From’ and ‘To’ Date for forecast or Plan range
  • Click on ‘Compile’ to start compilation.

Concurrent Request ‘Compile ABC Analysis’ (INCAAC) will be submitted with default parameters. You will get the option to ‘Print Compile Results’, click YES to see the compile output.

ABC Compile

ABC Compile

 

 

 

 

 

 

Once concurrent Request is completed navigate to ‘View -> Requests -> View Output’ to see the output

ABC Compile Output

ABC Compile Output