You are browsing the archive for Business Processes.

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

 

 

 

 

 

 

 

 

8.6 Adjust Approved Physical Inventory Tags

 

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

Physical Inventory process helps in matching system on-hand with actual physical on-hand. Last step in physical inventory process is to post the adjustments that updates system on-hand to match with actual (count quantity) on-hand quantity.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Physical Inventories

  • Click ‘Find’
  • Select the ‘Name’ of Physical Inventory
  • Click ‘OPEN’
  • Click on ‘TOOLS’ -> Launch Adjustments
  • Enter the ‘Adjustment Account’ (GL account) and adjustment date
  • Click ‘Launch Adjustments’

Concurrent program ‘Perform Physical Inventory Adjustments’ (INCAPA) is submitted with default parameters. Wait until concurrent program is completed, then verify the adjustments.

This is the last step of Physical Inventory process. Only further action you can take is purging the physical inventory records.

Adjust Approved Physical Inventory Counts

Adjust Approved Physical Inventory Counts

 

 

 

 

 

 

 

 

8.5 Approve Physical Inventory Tag Counts

 

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

Physical Inventory process helps in matching system on-hand with actual physical on-hand. During physical inventory, first inventory snapshot is taken then tags are generated. Actual on-hand quantity physically found is captured on tag. System determines based on physical inventory setup if any of the variance (system qty/value – actual qty/value) requires ‘APPROVAL’ or not. All approval needed must be approved/rejected. Once approved, inventory on-hand will be adjusted to match with actual count quantity.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Approve Adjustments

  • Select the ‘Name’ of Physical Inventory
  • Click ‘Find’
  • Check ‘YES’ to query out of tolerance adjustment  tags only

Output shows all tags that are out of tolerance and requires approval. This screen show the system quantity, actual quantity and variance quantity. Select any of the tag and check ‘Approve’ or ‘Reject’ or ‘None’ radio button.

Save the tag count approval. Once tag variances are approved next step is to adjusting the approvals. Approvals doesn’t automatically approve the on-hand inventory in Oracle, next step of Adjusting must be done.

Adjust Approved Physical Inventory Counts

Adjust Approved Physical Inventory Counts