My Oracle Support Banner

Duplicate Depreciation Journals Created For ALC-Enabled Asset Book When Asset Description Is Included In Custom Journal Line Description (Doc ID 1925346.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.


Duplicate depreciation journal lines/amounts are getting created for asset books which are enabled for ALC (Alternate Ledger Currency) and which use an Application Accounting Definition having a custom Journal Line Description attached which includes the Asset Description (or any other MLS/translated source).

No duplication happens for the other journal types, for example, Additions.

For example;

For a certain period, let's say an asset has depreciation amount 885.09 calculated in fa_deprn_summary (for primary ledger) and 69041.21 calculated in fa_mc_deprn_summary (for reporting ledger). These amounts are correct and there is no duplication at the FA level. The duplication exists at SLA and GL levels only.
In xla_ae_lines, there are two depreciation expense debit rows of 885.09 each, and two depreciation reserve credit rows of 885.09 each.
The same behavior is also seen for the reporting ledger, so there are two depreciation expense debit rows of 69041.21 each, and two depreciation reserve credit rows of 69041.21 each.
These duplicate SLA entries get transferred also to GL.




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

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