My Oracle Support Banner

EAM: Incorrect Depreciation Reporting Entries in PS_DEPR_RPT Created by the “Load Depr Reporting Table” Process (AMDPREPT) (Doc ID 2890581.1)

Last updated on AUGUST 24, 2022

Applies to:

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

Symptoms

Incorrect Depreciation reporting entries in PS_DEPR_RPT created by the "Load Depr Reporting Table" process(AMDPREPT)
Navigation: Asset Management > Financial Reports . Load Reporting Tables > Load Depr Reporting Table


The issue can be reproduced at will with the following steps:
1. Add a New Asset with the following Details:
Transaction / Accounting Date / In-Service Date = 01/23/2018
Cost = 28000
Useful Life = 60
Convention = FM(Following Month)
Method = Straight Line
Navigation: Asset Management > Asset Transactions > Owned Assets > Express Add
2. Calculate the Depreciation:
Navigation: Asset Management > Depreciation > Processing > Calculate Depreciation
3. Run the Load Depr Reporting Table Process:
Navigation: Asset Management > Financial Reports > Load Reporting Tables > Load Depr Reporting Table
4. Set an End Date of 09/30/2021 as of Transaction / Accounting Date 07/28/2021
Navigation: Asset Management > Asset Transactions > Asset Book Information > Define Tax/Depr Criteria
5. Calculate the Depreciation:
Notice that the Depreciation ends in 2021 Period 9 as expected:
6. Run the Load Depr Reporting Table Process
7. Notice the meager amounts in Periods 10, 11, and 12 (After the Asset End Date)

Expectations:
Expecting the depreciation to sum up to 0 in Periods 10,11, and 12.


Detailed DEMO Replication Steps Attached

Cause

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

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


In this Document
Symptoms
Cause
Solution
References


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