EAM: AMDPREPT DPRPT600 STEP01 ORA-01407: Cannot Update ("SYSADM"."PS_DEPR_RP4_TMP4"."LOCATION") (Doc ID 2069888.1)

Last updated on MAY 24, 2016

Applies to:

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

Symptoms

AMDPREPT DPRPT600 STEP01 ORA-01407: cannot update ("SYSADM"."PS_DEPR_RP4_TMP4"."LOCATION") to NULL

App engine AMDPREPT is failing at DPRPT600 STEP01 with the error message cannot update ("SYSADM"."PS_DEPR_RP4_TMP4"."LOCATION") to NULL. This error was introduced by the code change to this step in bundle 33. On pre-bundle 30 version of the sql, the step does not fail.

ERROR
-----------
ORA-01407


STEPS
----------
The issue can be reproduced at will with the following steps:
1. Add an asset
2. Run Depreciation
3. Run AMDPREPT process

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the reports

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