EAM 9.2 : Asset Management - Importing Asset Transaction Data By Spreadsheet. How to Add More Delivered Fields to the Custom Template-ID That Use the Transaction of “Asset Addition”. (Doc ID 2849905.1)

Last updated on JULY 21, 2023

Applies to:

Goal

The Navigation - Asset Management > Send/Receive Information > Import Data via Spreadsheet > Upload Spreadsheet Data is used to load data from a CSV file. The CSV file is created based on a template that uses the "Asset Addition" transaction. Currently, the template is missing some of the fields that we want to include in the CSV file. How to add new fields to this template?

Replication:

1. Navigation: Set Up Financials/Supply Chain >Product Related >Asset Management >Import Spreadsheet.
2. Setup >Define Spreadsheet Template >Define Spreadsheet Template.
3. Open a template - "XXXX" Template that uses the transaction "Asset Template". The user would like to see the following fields available but are not existing in the fields list.

Field Description  - Table Name - Field Name

Transaction code  - COST - TRANS_CODE
Department - COST - DEPTID
Project  - COST - PROJECT_ID
Acquisition code - ASSET - ACQUISITION_CD
Asset type - ASSET - ASSET TYPE
Depreciation method - PROFILE_DET_TBL - METHOD
Depreciation percent PROFILE_DET_TBL - DEPR_PERCENT
FERC code - ASSET - FERC_CD
Comments - ASSET_COMMENTS - COMMENTS

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.