EAM 9.2: AM_AMAEDIST Fails With Ora-01476 Divisor Is Equal To Zero Error For Leased Asset
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.
On : 9.2 version, Accounting Entries
When attempting to create accounting entries for a leased asset,
the following error occurs.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms