My Oracle Support Banner

EAM 9.1:AMDPCALC Abended with Error Cannot insert the value NULL into column 'ANALYSIS_TYPE' When Upgrading from 8.9 to 9.1 MP#5 (Doc ID 1315761.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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


PeopleSoft Asset Management Information Center > Listing of AMDPCALC Error Messages and Troubleshooting Tips to Resolve Each Error > Note 1315761.1
EAM:Errors in 9.1 after applying bundle #9 update id 816363 or MP5 > Note 1315761.1

In release 9.1, test, MP5, am_depr_calc is run and errors as follows:

Calculate Depreciation - 9.1

Program Started at 2011-04-13 16:54:52.497

f:\psoft\fs910mp5\user\sqr\amdpcalc.sqr: AMDPCALC - SQL Statement =

SQL Status = 515, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'ANALYSIS_TYPE', table 'FS910PRD.dbo.PS_DEPRECIATION'; column does not allow nulls. INSERT fails.

Error on line 70:
(SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.
Business impact:
Because of this, cannot create depreciation or accounting entries.

However, am_depr_calc goes to success in DEMO and went to success in release 8.9 prior to the upgrade.

Steps to replicate:
1. Upgrade from 8.9 to 9.1
2. Apply MP5
3. Run amdpcalc.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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