Process Physical Inventory Data
This example demonstrates how to process physical inventory data in Oracle Assets using either the ADFdi spreadsheet or the FBDI template.
The following table summarizes key decisions for this scenario:
Decisions to Consider |
In This Example |
---|---|
What setup data are you uploading? |
Physical inventory data using either the ADFdi spreadsheet or the FBDI template |
Is the data an update or new setup data? |
New |
Summary of Tasks
This worked example includes details of the following tasks you perform when processing asset physical inventory:
-
Completing the prerequisite setup
-
Entering physical inventory data either using the ADFdi spreadsheet or the FBDI template
-
Uploading the data into the application
-
Verifying the entered data
Prerequisites
This worked example assumes that the following tasks are complete:-
The Allow Physical Inventory option is enabled for your asset book.
-
The In Physical Inventory check box is checked for all assets in Assets to be included in the physical inventory comparison.
Load Physical Inventory Data
You can load physical inventory data in Assets using any one of the following methods:-
Loading Physical Inventory Data using an ADFdi spreadsheet
-
Loading Physical Inventory Data using the FBDI template
Load Physical Inventory Data Using an ADFdi Spreadsheet
-
Navigate to the Scheduled Processes work area and search for the Manage Physical Inventory task.
-
Click Enter.
-
In the dialog box select Asset Book and enter a unique Physical Inventory name.
-
Click Next.
-
Sign in and download the ADFdi spreadsheet.
-
Enter the following physical inventory data in the spreadsheet:
Field
Value
Location
Enter the asset location
Number of Units
Enter the number of units
Employee
Optionally enter an employee name
Asset Number
Enter an asset number
Tag Number
Enter a tag number
Serial Number
Enter a serial number
-
Click Submit to submit the Physical Inventory Comparison process.
-
View the comparison status in the Manage Physical Inventory page.
-
Select a row and click Review to export to the ADFdi spreadsheet.
-
Verify the results in the Manage Physical Inventory page and correct the differences, if any.
-
Click Save and Close.
Load Physical Inventory Data Using the FBDI Template
-
Navigate to the Oracle Enterprise Repository and download the physical inventory FBDI template.
-
Enter the physical inventory data in the FBDI template.
-
Generate a .zip file.
-
Upload the .zip file.
-
Navigate to the Scheduled Processes work area and run the Load Interface File for Import process to import the physical inventory data.
-
Run the Asset Physical Inventory Comparison task.
-
Navigate to the Assets landing page and select your asset book.
-
Select the Manage Physical Inventory task from the Tasks panel tab.
-
Verify the comparison status in the Manage Physical Inventory page.
-
Select a row and click the Review button to export to the ADFdi spreadsheet.
-
Verify the results in the Manage Physical Inventory page and correct the differences, if any.
-
Click Save and Close.