How Physical Inventory Interface Import Data Is Processed

Use the Physical Inventory Interface file-based data import process to import physical inventory data into Oracle Assets.

You can download a spreadsheet template to use to prepare your inventory data. The template contains an instruction sheet to help guide you through the process of entering your inventory information.

To access the template, complete the following steps:

1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

2. In the Table of Contents, click File-Based Data Imports.

3. Click Physical Inventory Interface.

4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Do not change the order of the columns in the template.

• You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Physical Inventory Interface Import Process

The Physical Inventory Interface import template contains an instructions tab, plus a tab that represents the table where the data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and loading data and the format of the template.
FA_INVENTORY_INT	Enter physical inventory information that will be used to run the Asset Physical Inventory Comparison process.

Before loading physical inventory data:

• Enable the Allow Physical Inventory option for your asset book.

• Verify that the In Physical Inventory check box is checked for all assets to be included in the physical inventory comparison.

How Physical Inventory Is Processed

After you successfully load your physical inventory data, you must submit the Asset Physical Inventory Comparison process to compare your assets. You can also submit the process by clicking the Submit button in the ADF desktop integration spreadsheet.

To submit the Asset Physical Inventory Comparison process:

1. Navigate to the Scheduled Processes page.

2. Click the Schedule New Process button.

3. Select the Asset Physical Inventory Comparison process.

4. Select the Book and Inventory Name and click Submit.

5. If the Asset Physical Inventory Comparison process ends in error or warning, review the log file for details about the rows that caused the failure.

To view the comparison results:

1. Navigate to the Assets landing page.

2. Select your asset book.

3. Select the Manage Physical Inventory task.

4. View the comparison status in the Manage Physical Inventory page.

5. Select a row and click the Review button to export the information to the ADF desktop integration spreadsheet.

6. Analyze and correct the errors, if any.