How Mass Update Descriptive Details Import Data Is Processed

Use the Post Mass Update Descriptive Details file-based data import process to update the descriptive details of assets in your asset book.

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

You can update the following descriptive details for assets:

• Asset number

• Tag number

• Serial number

• Global descriptive flexfield

• Asset key

• Descriptive flexfield

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 Post Mass Update Descriptive Details.

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.

• don't change the order of the columns in the template.

• You can hide or skip the columns you don't use, but don't delete them.

Settings that Affect the Post Mass Update Descriptive Details Import Process

The Post Mass Update Descriptive Details import template contains an instructions tab, plus a tab that represents the table where the mass descriptive details data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and loading data, the format of the template, submitting the Post Mass Update Descriptive Details process, and correcting import errors.
FA_DESCRIPTIVE_DETAILS_INT	Enter the mass descriptive details data that you will use to update your asset information.

How Update Descriptive Details Are Processed

Ensure that you populate the descriptive details interface table with the correct information, then run the Post Mass Update Descriptive Details process.

To submit the Post Mass Update Descriptive Details process:

1. Navigate to the Scheduled Processes page.

2. Click Schedule New Process.

3. Enter Post Mass Update Descriptive Details in the Name field and click OK.

4. Enter the book and transaction group and click Submit.

5. Verify that the Scheduled Process status is Succeeded in the Enterprise Schedule Services page.

6. If the Post Mass Update Descriptive Details process ends in error or warning:

   1. Review the log file for details about the rows that caused the failure.

   2. Download the CSV output file, correct the errors, and re-upload the file.

Note: If you're using descriptive flexfields, make sure that you enter the correct value for each segment in the Post Mass Update Descriptive Details import template, because the application doesn't validate these values.