My Oracle Support Banner

EAM: Process AMDPREPT Fails with Error: "ORA-01476: divisor is equal to zero" (Doc ID 2834289.1)

Last updated on JUNE 17, 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


AMDPREPT fails with the following error

ERROR
----------


The issue can be reproduced at will with the following steps:
1. Create an operating lease for 1 month. commencement date = 10/01/2021, Termination date = 10/31/2021. Rent is Advance. Activate lease.
Navigation: Lease Administration, Payables Lease, Create New Lease
2. Create amendment to extend to 10/31/2022. Activate the amendment.
Navigation: Lease Administration, Payables Lease, Maintain Lease
3a. Create amendment to shorten lease to 11/30/2021.
Navigation: Lease Administration, Payables Lease, Maintain Lease
3b. Make rent for November = .01. Activate lease.
4. Run AM_DEPR_CALC
Navigation: Asset Management, Depreciation, Processing, Calculate Depreciation
5. Run AMDPREPT
Navigation: Asset Management, Financial Reports, Load Reporting Tables, Load Depr Reporting Table

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.