Physical Counting in Oracle Inventory – R12.2


Counting is used to verify the System On hand Quantity with Actual (Physical Qty) Quantity of the item and perform the adjustments in System OHQ.

These are two types of counting.
  • Physical Counting
  • Cycle Counting

Physical Counting:
It is used to verify the System On-hand Quantity and Actual Quantity of the item based on Sub inventory or Organization and perform the adjustments.
Normally we will perform this counting yearly once or twice. During Physical Counting, the Total Inventory will freeze and can’t do any Transactions.

Step 1: Define the item through get on-hand quantity
Here we are defining three items like

Step 2: Define Sub inventories
We are creating a sub inventories like SKV

Step 3: Items should have on-hand quantity
Through miscellaneous receipt we can get the on-hand quantity.
IPHONE 4S =100, IPHONE 5S =100, IPHONE 6S =100.

Step 4: Define Physical Inventory

Navigation:  Inventory ? Counting ? Physical Inventory ? Physical Inventories

Click on New, the below dialog box appears.

You add the Tolerance and Qty of your choice.

Click on Snapshot, system automatically generate concurrent program.

Step 5: Generate Physical Inventory Tags

Navigation:  Counting ? Physical Inventory ? Tag Generation

Click on Generate.

Now the system will run  “Generate physical inventory tags” concurrent program.

Step 6: Run “Physical Inventory Tag Listing” Report

Navigation: View ? Request ? Submit New Request ? Single Request

Output of the report:

Step 7: Enter Physical(Actual) Quantity of the Item/Physical Inventory Tag counts

Navigation: Inventory ? Counting ? Physical Inventory ? Tag Counts

Select the Physical Inventory Name and then Click on Find

Now u will get one message like

Just click on Yes.

Now u will get below window

In the above you enter the quantity as 10 for all three Items, IPHONE 4S, 5S, 6S.

Step 8: Approve the Adjustments

Navigation:  Inventory ? Counting ? Physical Counting ? Approve Adjustments

Click on Find and Click on Yes, now you will get below window

Then u can select the Approve radio button against these 3 items and mention the approver.

Step 9: Performing the adjustments

Go to Physical inventory definition form query with our physical inventory

Navigation: Inventory ? Counting ? Physical Inventory ? Physical Inventories

Click on “Launch Adjustments

Now you will get below window

Click on “Launch Adjustments

Now system automatically generate concurrent program.

Select  View ?Request (Its Normal Below)

Step 10: Check out the On-hand quantity

Now go to inventory and select the on hand quantities for these 3 items as below.

Before we had 100 qty for each item after completing the physical counting we will get original qty of 10 each.

You can also view from Inventory ?Material Transaction, search for the item

This concludes Physical Counting.

  • November 28, 2014 | 110 views