EAM 9.2: AM_AMAEDIST Fails With Ora-01476 Divisor Is Equal To Zero Error For Leased Asset

(Doc ID 2312570.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

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

Symptoms

On : 9.2 version, Accounting Entries

When attempting to create accounting entries for a leased asset,
the following error occurs.

Error
File: e:\pt85514b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 453 Return: 1476 - ORA-01476: divisor is equal to zero Failed SQL stmt: UPDATE PS_AM_DST_DL_TMP4 SET PS_AM_DST_DL_TMP4.TXN_AMOUNT=PS_AM_DST_DL_TMP4.AMOUNT- ((((PS_AM_DST_DL_TMP4.AMOUNT) * (( SELECT SUM(A.OBLIGATION_REDUCE) FROM PS_LEASE_CHART2_VW A WHERE A .BUSINESS_UNIT=PS_AM_DST_DL_TMP4.BUSINESS_UNIT AND A.ASSET_ID=PS_AM_DST_DL_TMP4.ASSET_ID AND A.LEASE _BOOK=PS_AM_DST_DL_TMP4.BOOK AND A.PYMNT_DT<PS_AM_DST_DL_TMP4.JOURNAL_DATE AND PS_AM_DST_DL_TMP4.DIS TRIBUTION_TYPE='LO' AND PS_AM_DST_DL_TMP4.PROCESS_INSTANCE=122912)))) / (( SELECT SUM(A.COST) FROM P S_COST A WHERE A.BUSINESS_UNIT=PS_AM_DST_DL_TMP4.BUSINESS_UNIT AND A.ASSET_ID=PS_AM_DST_DL_TMP4.ASSE T_ID AND A.BOOK=PS_AM_DST_DL_TMP4.BOOK AND A.TRANS_DT<=PS_AM_DST_DL_TMP4.JOURNAL_DATE AND A.TRANSFER


Steps
1. Create a new Leased Asset with Trans and Acctg Date in previous month. Make sure that the 1st payment date is smaller than the accounting date.
2. Run depr and accounting.
3. Do an interunit transfer with dates from a week later than the asset add date.
4. Run depr and accounting.
5. Do an intraunit transfer within departments with dates from a week later than the asset add date.
6. Run depr and accounting.

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps containing the complete configuration and the replication steps necessary to reproduce the issue.

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