To freeze the system on-hand quantities:Before you can generate tags for a physical inventory, you must take a snapshot of all system on-hand quantities for your items. The snapshot saves all current item on-hand quantities and costs. Oracle Inventory uses this information as the basis for all physical inventory adjustments. All tag counts you enter for this physical inventory are compared with these static quantities. This allows you to resume normal inventory operations after you have entered your counts but before you have authorized all final physical inventory adjustments. You can perform your recounts or investigate certain results without holding up transaction processing.
Attention: Oracle Inventory does not stop inventory processing during a physical inventory. Therefore, you must procedurally coordinate the snapshot of your physical inventory with your actual counting, and ensure that no transaction activity occurs in a particular location until after you have performed your adjustments.
Attention: It is recommended to clear the Pending Transactions and Transactions Open Interface, before taking a snapshot of inventory quantities.
For example, suppose that at the start of your physical inventory the system on-hand quantity for item WIDGET in a particular bin is 30. Oracle Inventory saves this information with the physical inventory snapshot. During the warehouse count, you count a total of 25 units of item WIDGET in the same bin. Before you approve your counts and perform your adjustments, you resume normal transaction operations, and consequently, item WIDGET reaches a system on-hand quantity of 45. At this point, you perform your physical inventory adjustments. Oracle Inventory computes the adjustment as the difference between the tag count and the snapshot quantity, NOT the current system quantity of the item that has now reached 45. So in this case, the adjustment is 25 - 30 = -5 units. When the adjustment is posted, the new system on-hand quantity becomes 40 units.
To freeze the system on-hand quantities:Navigate to the Physical Inventories Summary folder window.
Select the physical inventory you want to use.
Choose Perform snapshot from the Tools menu. This launches the snapshot concurrent process.
Note: You can also choose Snapshot from the Define Physical Inventory window. See: Defining a Physical Inventory.
When the concurrent process is finished, re-query the physical inventory to see the effects of the snapshot. The effects include:
The Snapshot Complete box is checked on the Physical Inventories Summary folder window.
The Snapshot Complete box is checked, the Snapshot Date is updated, and the Tags button is enabled in the Define Physical Inventory window.
