My Oracle Support Banner

AR - Modify Oracle Asset Logic for Calculation of Periodic Lease Rate (Doc ID 2307435.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Goal

Expect formula for changing from an annual percentage rate to a semiannual, quarterly, or monthly one to be:

Effective rate for period = (1 + annual rate)(1 / # of periods) – 1

Per Oracle Asset User Guide, Annual Interest is divided evenly by payment periods:

Section: Lease Evaluation
Example 1: Set Up Lease
12% annual, with 12 payment periods per year:
(a) The interest rate per period (in this example, 12%/12=1%) multiplied by
the prior period lease obligation, except for the 3/1/93 payment; since no
time has elapsed, no interest has accrued.

Example 2: Set Up Payment Schedule
10% annual, with 2 payment period per year (Jan & Jul)
(a) The interest rate per period (in this example, 10%/2=5%) multiplied by
the prior period lease obligation, except for the 3/1/93 payment; since no
time has elapsed, no interest has accrued.

 

 

Solution

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
Goal
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.