Previous	Next		Contents	Index	Navigation	Glossary	Library

• A unique identifier, which can be either the asset number, tag number, or serial number

• The location

• The number of units

When you finish entering physical inventory data into Oracle Assets, you run the Physical Inventory comparison program, which highlights the differences between the asset information in Oracle Assets and the actual assets in physical inventory. This program compares your physical inventory data with your Oracle Assets data for all assets that have the In Physical Inventory check box checked.

You can view the results of the comparison online in the Physical Inventory Comparison window, or by running the Physical Inventory Comparison Report. The comparison results highlight differences between the assets in your production system and those in physical inventory You can reconcile the differences between physical inventory and the information in your database by updating each asset manually, or you can use the mass additions process to add assets that are missing from the production system.

When you have completed your physical inventory, you can run the Missing Assets Report, which lists all assets that have not been accounted for in the physical inventory process.

Prerequisites

   Ensure that the In Physical Inventory check box is checked for all assets in Oracle Assets that you want included in the physical inventory comparison program. See: Setting Up Oracle Assets Data to be Included in Physical Inventory.

   To gather and reconcile physical inventory information:

1. Take physical inventory of your assets by using a barcode scanner (if your assets are set up with barcodes) or by manually noting the location, number of units, and a unique identifier.

2. Navigate to the Physical Inventory window.

3. Enter the inventory name (for example, Q2 Physical Inventory USA) and the start date. Entering an end date indicates that the physical inventory is complete, so you should not enter an end date until you have completed all physical inventory tasks.

4. Save your changes.

5. Load the physical inventory data into Oracle Assets using the Physical Inventory window, FADI, or SQL*Loader. See: Loading Physical Inventory Data.

6. Run the Physical Inventory Comparison program. See: Physical Inventory Comparison Program.

7. Run the Physical Inventory Comparison Report or review the results online using the Find Physical Inventory Comparison window. See: See Viewing Comparison Results.

8. Analyze the report results.

9. Change Oracle Assets data to reconcile with the physical inventory data and ensure you have accounted for all assets. See: Reconciliation.

10. Run the Missing Assets Report. See: Missing Assets

11. Purge the physical inventory data. See: Purging Physical Inventory Data.