LINE_ACCUMULATED_DEPRN Is Not Returning The Correct Value Where There Is A Daily Pro-rate

(Doc ID 2305630.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.


Asset Books have been defined to use a daily pro-ration for Depreciation.
During a Termination the seeded Formula LINE_ACCUMULATED_DEPRECIATION is being used.
This Formula is returning a value based on the full month of the termination.

Expect the Formula to provided the amount for the quote effective date as daily pro-ration is being used in Assets.

The issue can be reproduced at will with the following steps:
1. Setup Books in Assets to use daily pro-raqtion for Depreciation.
2. Use the seeded Formula LINE_ACCUMULATED_DEPRECIATION in an Accounting Template for the Termination Transaction Type.
3. Process a termination with a Quote Effective Date that is in the middle of an Asset month.

The issue has the following business impact:
Due to this issue, users cannot get the correct amounts accounted for in these terminations.




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