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.

Symptoms


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:
========
AMDPCALC_1534907.out

Calculate Depreciation - 9.1


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

*----------------------------------------*
* PROCESS AMDPCALC_RQST *
*----------------------------------------*
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.

Cause

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 hundreds of Community platforms