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:
PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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:
- Navigation: Set Up Financials/Supply Chain >Product Related >Asset Management >Import Spreadsheet.
- Setup >Define Spreadsheet Template >Define Spreadsheet Template.
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |