EAM: After Upgrading to PUM 45 The Load Depreciation Reporting Tables Process Abended at Step AMDPREPT.DPRPT250.Step01 (Action SQL) -- RC = 1407, Error: "cannot update ("SYSADM"."PS_DEPR_RP4_TMP4"."DEPR") to NULL". (Doc ID 2918297.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

After upgrading to PUM 45 and PeopleTools 8.59 The Load Depreciation reporting table AMDPREPT process failed with the following error:

Steps to Replicate:

1. Create an asset using Express Add. Transaction and Accounting dates used are 1/1/2022 and 1/1/2022 respectively.
      Menu > Asset Management > Asset transactions > Owned Assets > Express Add.

2. Run the Depreciation calculation process.
      Menu > Asset Management > Depreciation > Processing >calculate Depreciation.

3. Run Load Depreciation reporting table process(AMDPREPT) from the fiscal year 2022 through 2024.
      Menu > Asset Management > Financial Reports > Load Reporting Tables > Load Depr Reporting Table.

4. Change the end date on Define Tax/Depr Criteria page for the CORP book to 12/31/2023.
      Menu > Asset Management > Asset Transactions > Asset Book Information >Define Tax/Depr Criteria

5. Run the Depreciation calculation process.
     Menu > Asset Management > Depreciation > Processing >calculate Depreciation.

6. Run Load Depreciation reporting table process(AMDPREPT) from the fiscal year 2022 through 2024.The above error is received.
      Menu > Asset Management > Financial Reports > Load Reporting Tables > Load Depr Reporting Table.

Changes

 The issue occurs after PUM 45 and PeopelTools 8.59 Upgrade.

Cause

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