You are browsing the archive for Oracle Inventory.

by oracleguru

8.6 Adjust Approved Physical Inventory Tags

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

  • 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

 

 

 

 

 

 

 

 

Tags: , , , , No Comments »

by oracleguru

8.5 Approve Physical Inventory Tag Counts

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

  • 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

 

 

 

 

 

 

 

 

Tags: , , , , , No Comments »

by oracleguru

8.4 Enter Physical Inventory Tag Count

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

  • Form Application: Inventory
  • Form Name: INVADPTE
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADPTE.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. Once tags are generated, actual on-hand quantity physically found is captured on tag.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Tag counts

  • Select the ‘Name’ of Physical Inventory
  • Click ‘Find’
  • Check ‘YES’ to query all existing tags

Output shows all tags generated. Select the tag for which on-hand quantity will be entered.

  • Enter the count quantity in ‘quantity’ field.

Save the tag count entered. Now you have actual count entered and system on-hand on tag. Based on Physical Inventory setup, oracle decided if there is a variance if it requires approval. Next step in physical inventory process is APPROVE / REJECT.

Enter Physical Inventory Tag Counts

Enter Physical Inventory Tag Counts

 

 

 

 

 

 

 

Tags: , , , , No Comments »