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:
-
Navigate to the File-Based Data Import for Oracle Financials Cloud guide.
-
In the Table of Contents, click File-Based Data Imports.
-
Click Post Mass Update Descriptive Details.
-
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:
-
Navigate to the Scheduled Processes page.
-
Click Schedule New Process.
-
Enter Post Mass Update Descriptive Details in the Name field and click OK.
-
Enter the book and transaction group and click Submit.
-
Verify that the Scheduled Process status is Succeeded in the Enterprise Schedule Services page.
-
If the Post Mass Update Descriptive Details process ends in error or warning:
-
Review the log file for details about the rows that caused the failure.
-
Download the CSV output file, correct the errors, and re-upload the file.
-