EAM: AMDPREPT Is Failing at Step AMDPREPT.DPRPT500.Step00 (SQL) -- RC = 1407

(Doc ID 648454.1)

Last updated on JUNE 05, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 8 to 9.2 [Release 8 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201014985



***Checked for relevance on 27-Apr-2010***
***Checked for relevance on 10-Jan-2014***
***Checked for relevance on 16-Nov-2015***


Symptoms


PeopleSoft Asset Management Information Center > Listing of AMDPREPT Error Messages and Troubleshooting Tips to Resolve Each Error > Note 648454.1


The AMDPREPT process is failing when running certain books with the following error:
SQL error. Stmt #: 1604 Error Position: 0 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_DEPR_RP4_TMP"."TRANS_CODE") to NULL

I verified that all rows in the source tables for TRANS_CODE were not null - they either had a value or were blank. Process is failing only on certain books - traced the AMDPREPT application engine program and checked the temp tables, and found no nulls in the source temp tables used either. This appears to be a problem with how the SQL is written that its results pull back a null when all the TRANS_CODE values are blank in the source.

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