My Oracle Support Banner

EAM: How to Upload Assets Using the Asset Management Spreadsheet Upload Functionality? And How to Adress the "Assignment of a NULL value to a NOT NULL column is not allowed" Error. (Doc ID 2756080.1)

Last updated on FEBRUARY 26, 2021

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Goal

How to upload assets using the Asset Management Spreadsheet Upload Functionality?

Navigation: Asset Management > Send/Receive Information > Import Data via Spreadsheet > Upload Spreadsheet Data

While trying to utilize the delivered Asset Import Data via Spreadsheet functionality for adding Assets with Accumulated Depreciation the AMIF1000 application Engine errors out with the following SQL error:


Additional product questions pertaining to the same functionality:


1. What is the significance of the "Line Sequence No" field available at the template which is marked as required as well. System expects a header level row (Seq No= 0) while loading the data?
2. How can we load multiple rows for an asset having more than one Acquisition details?
3. Can we use this template to add/modify existing Accumulated depreciation information for an asset or is it applicable for newly created assets alone?
 

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


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