Property Manager

Variable Rent
Data Model Document
Author: Oracle Support Services
Creation Date: 01-May-2017 Last
Updated:
Document Ref:
Version: 1A

Organization: Oracle India Private Limited.

Contents
Scope .............................................................................................................................................................
4

Introduction ..................................................................................................................................................
4
Profile Options that govern Variable Rent .................................................................................................... 6

PN: Volume Status Default .................................................................................................................... 6

PN: Show Calculate and Calculate All Buttons for Variable Rent ......................................................... 6

PN: Require Volume for Entire Invoice Period ...................................................................................... 7

Pre-requisites ................................................................................................................................................
7

Automatic Variable Rent Number Generation ......................................................................................... 7

PN System Options ....................................................................................................................................

7

PN Lookups ...............................................................................................................................................
8

Creating a Lease ........................................................................................................................................

8

Creating Term Template ...........................................................................................................................

8

Variable Rent Cycle ....................................................................................................................................... 9

Steps to Add a Variable Rent Agreement ................................................................................................... 10

Defining Breakpoint and its Types .............................................................................................................. 23

Natural Breakpoint ..................................................................................................................................

23

Artificial Breakpoint ................................................................................................................................

26

Entering Volumes ........................................................................................................................................

34

Entering Volumes by Lines ......................................................................................................................

34

Entering Volumes Using Variable rent Gateway: .................................................................................... 35

Variable Rent Agreement Calculation Methods ......................................................................................... 41

Using the Cumulative Calculation Method ............................................................................................. 41

Using the Noncumulative Calculation Method ....................................................................................... 45

 Using the Year-to-Date Calculation Method ...........................................................................................
48 Using the True Up Calculation Method ..................................................................................................
54

Partial Year Calculation Methods................................................................................................................ 60

Variable Rent Important Tables .................................................................................................................. 70

Entity Relation Diagram for Variable Rent .................................................................................................. 72

Table Association with Screens and Sample Data ...................................................................................... 73

Code Flow....................................................................................................................................................
81

Variable Rent Concurrent Programs ........................................................................................................... 82

Scope
This Document covers the Variable rent creation process and all attributes that affect the calculation of
Variable Rent which is finally added as a term to the lease. It includes how each attributes affects the
calculation and most used scenarios with those attributes. We can add a Variable Rent agreement via the
form as well as the API. It covers package details with the flow of the code i,e How it flows from one
package to another? And what all table are affected when a Variable Rent is added. This document does
not cover adjustments performed on Variable Rent and how they affect calculations in the end.

Introduction
Variable Rent is a structured system that allows rent to be calculated based on varying volumes from
month to month. You can create variable rent agreements and calculate rent on any variable volume such
as sales volumes, utility consumption, hours, or services provided. For example, you can calculate rent
based on a percentage of the sales volume on the leased premises.

Before you can calculate rent, you must create a variable rent agreement to define the attributes that
Oracle Property Manager uses for rent calculation. These attributes include calculation methods, rent
periods, breakpoints, constraints, and allowances.

To calculate rent, you must periodically collect and report the volumes against which you calculate rent.
The calculation process applies agreement attributes to the reported volumes to determine the rent
amount for each invoice. If actual volumes are not available for rent calculation, Oracle Property Manager
enables you to use forecast volumes to calculate rent. You can later reconcile the difference between
actual and forecast rent and if necessary, generate an adjustment to settle the difference.
Profile Options that govern Variable Rent
The following profile options must be set:
Profile Option Name Profile Option Value

PN: Volume status default Approved

PN: Show Calculate and Calculate All Buttons for Variable Rent Yes

PN: Require Volume for Entire Invoice Period No

PN: Volume Status Default

Use the profile option PN: Volume Status Default to determine the initial status of volumes you enter for
a variable rent agreement. You can modify the status when required. You can set the profile option to one
of the following:

• Approved: Oracle Property Manager sets the status to Approved when you create a new volume
record.
• Draft: Oracle Property Manager sets the status to Draft when you create a new volume record.
• On Hold: Oracle Property Manager sets the status to On Hold when you create a new volume
record.

PN: Show Calculate and Calculate All Buttons for Variable Rent

Use the profile option PN: Show Calculate and Calculate All Buttons for Variable Rent to determine
whether variable rent calculation begin from the first period of the agreement or from a selected period.

Note:- PN: Show Calculate and Calculate All Buttons for Variable Rent governs the display of buttons on
the Annual Periods tab of the Variable Rent window and the Line Item Review window. From the
Agreement tab of the Variable Rent window, you always calculate for all periods, irrespective of the profile
option value.

You can set the profile option to one of the following:

• Yes: You can calculate variable rent for a selected annual period and any subsequent periods with
volume data.
• No: You always calculate variable rent from the beginning of the agreement regardless of the
selected annual period. Calculating variable rent for all periods ensures that all calculations,
including those from previous years, are current.
PN: Require Volume for Entire Invoice Period

Use the profile option PN: Require Volume for Entire Invoice Period to determine the volume information
Oracle Property Manager requires to create variable rent terms. You can specify one of the following
values:

• Yes: You must enter volume data for the entire invoice period before creating a variable rent term.
Note that you can create one or more volume records as long as they span the entire length of the
period without any gaps.

• No: You need not enter volume data for the entire period before creating a variable rent term.

Pre-requisites
Automatic Variable Rent Number Generation
Navigation: Property Manager Responsibility -> Setups ->Options -> System Option(query of respective
Operating Unit)

PN System Options
There is only one option to be concerned with, the automatic number generation. The automatic number
generation determines if the system will automatically generate the Variable Rent Agreement number or
if it needs to manually be entered. If you select YES, the system will automatically generate the number
for each variable rent agreement. Table that stores data is PN_SYSTEM_SETUP_OPTIONS
PN Lookups
Here are the different lookups and a description of each. Most of these lookup values have default values,
you would only need these if you were adding additional lookup values.

Lookup name are:

a. PN_BATCH_TRANS_STATUS : The statuses of the batch imported using the Variable Rent Gateway (for
example whether the batch has been imported).

b. PN_DEDUCTION_TYPE : The deductions you can enter against volumes (for example employee sales).

c. PN_SALES_CHANNEL : The different sales channels used to classify sales volumes (for example
wholesale or retail).

d. PN_UNITS_OF_MEASURE : The units in which volume is measured (for example USD).

e. PN_VOL_HIST_TYPE : The types of volume you can import (for example deductions or actual).

f. PN_ITEM_CATEGORY : The type of products (for example food or clothing) used while calculating
variable rent.

Table where all these lookups are stored is: FND_LOOKUP_VALUES

Creating a Lease
A lease must be created before creating a variable rent agreement because the agreement is tied to
the lease. Navigation: PN > Leases and Documents > Main Lease > Enter Leases and Documents

For the lease you must have at a minimum the Details and Locations Tab / tenancy defined.

Each VR is associated with a specific lease.

Creating Term Template

The Billing / Payment term template will be used to create the terms for the VR agreement. The setup
of the billing term template also requires the setup of the customer or supplier as well as the
accounting distribution of the terms.

Navigation: PN > Leases and Documents > Billings > Billing Term
Template Navigation: PN > Leases and Documents > Payments > Payments Term Template

As stated before the Billing / Payment term template will be used to create the terms for the VR
agreement. The setup of the billing term template also requires the setup of the customer or supplier
as well as the accounting distribution of the terms.
Variable Rent Cycle

Entering Variable Enter

Generate Define Breakpoitn
Information
Rent For a Allowances,
Constraints
Leas AndLine Abedme
Existing Periods and (Option)
Items
e nts al

Review & Create Calculate Variable Ent Volum

Terms Rent er es

Query Lease and EnteAdjustmen

Approve
Term if
check is added to r neede
ts
Terms
Lease d
Steps to Add a Variable Rent Agreement

Calculation is based on :

Calculation method: Cumulative Partial year Method: Standard Invoice On: Actual Negative Rent: Ignore
Volume type: Percentage
Category: Base Rent

Defining Breakpoints
Created 3 natural breakpoints below is the screenshot
Commercial clothing: 10%
Commercial Footwear: 20%
Direct Men’s Shoes: 15%
Start date: 01-Jan-2008
End Date: 31-Dec-2010

Entering Volumes

Entered Volumes for Commercial clothing from Jan-2008 to Apr-2008

Now before calculating the gross variable rent we need to approve volumes. Also in the below screenshot
we can see the actual and the cumulative amounts marked

We can either perform calculation using the button at the down or following the navigation
Navigation: Property Manager Responsibility -> Leases and Documents -> Variable Rent -> Calculate Variable
Rent

The moment you run calculate it kicks of concurrent program “Calculate Variable Rent”

Output is
Now lets check the same from front end period wise, by following below navigation

Property Manager Responsibility -> Leases and Documents-> Variable Rent-> Enter Variable rent (query for
the variable rent number) -> Annual Periods Tab -> Line Items
Creating and Approving Term

You must create terms for amounts that you calculate as rent or as adjustment against rent for an invoice
period and approve them before you can pay or receive payment for them. In Oracle Property Manager,
you create and approve terms for the following types of amounts:

Net variable rent amount for an invoice period

Gross forecast variable rent amount for an invoice period

Variance amount between gross forecast variable rent for an invoice period and net variable rent for the
same period

Adjustment amount after recalculating rent for an invoice period

Property Manager Responsibility -> Leases and Documents-> Variable Rent-> Enter Variable rent (query for
the variable rent number) -> Annual Periods Tab-> Invoice Review

Create Terms. Select this check box for one or more invoice periods to create terms for the invoice periods.
When you save your selections, Oracle Property Manager runs the Create Variable Rent Terms concurrent
program to create terms and enable the Term Details button. You can then review the term in the Term
Details window, and approve it to transfer it to the main lease. If you change data and recalculate rent
after you create a term, then Oracle Property Manager deletes the existing term and deselects the Create
Terms check box for the old rent amount.
Concurrent program “Create variable Rent Terms”

Below is the Output

Checking the term created from front end

Property Manager Responsibility -> Leases and Documents-> Variable Rent-> Enter Variable rent (query for
the variable rent number) -> Annual Periods Tab-> Invoice Review -> Actual Tab

Now the Term Detail Button is enabled

Click on the term Details tab to check the term created

Approving Term

It kicks concurrent program” Approve Variable Rent Terms” on click of save

Below is the Output for the above
Post approving the term it should get attached to the lease lets query and check it in the lease
Navigation: Property Manager Responsibility -> Leases and Documents->Main Lease -> View Lease
History(Query For the Lease here and click open) -> Billings tab here since Revenue Lease type

Move to right and source will be Variable Rent

Above we see that frequency is one time so below is screenshot since invoicing at VR is set annually
Now Let’s check the calculation for the above
So the calculation goes
Volume*rate

Rate is 0.1
Volumes are as below: 1-Jan-2008 -31-Jan-2008 =1000
1-Feb-2008-29_Feb-2008=2000
1-Mar-2008-31-mar-2008 =3000
1-Apr-2008-30-Apr-2008 =4000
Calculation is: (1000*.01)+(2000*.2)+(3000*.1)+(4000*.1) =1000
Defining Breakpoint and its Types
You define breakpoints for a line item in the Setup window. For a breakpoint, you define a range of
volumes, a rate, and a period when the rate is applicable. Each breakpoint can have its own set of
breakpoint details. Each breakpoint detail has its own range of volumes, rate, and period. Oracle Property
Manager uses the applicable breakpoint detail volume for the calculation period to calculate rent.
Breakpoints for a line item and breakpoint details for a breakpoint must not overlap. Neither must dates
nor volumes for breakpoints and breakpoint details overlap.
To calculate rent, Oracle Property Manager uses the calculation method to determine the reported
volume and applicable breakpoint detail volume that it must compare. If you are calculating rent for a
partial annual period, Oracle Property Manager uses the partial year method to determine the volumes.
If the reported volume exceeds the breakpoint detail volume, Oracle Property Manager applies the
breakpoint detail rate to the overage volume to calculate variable rent.
You can choose to define either natural or artificial breakpoints. For natural breakpoints, Oracle Property
Manager creates breakpoint details. For artificial breakpoints, you must create breakpoint details. You can
change breakpoint definitions for both natural breakpoints and artificial breakpoints at any time. To
change artificial breakpoints, you must first undo the breakpoints, make your changes, and then generate
the changed breakpoints. For natural breakpoints, Oracle Property Manager automatically updates them
with your changes. In either case, you must recalculate rent after making changes.
Note: - Deleting a breakpoint deletes all breakpoint details for the breakpoint. Deleting a line item deletes
breakpoints, breakpoint details, and all associated volumes and deductions

There are two types of breakpoints:

• Natural Breakpoint
• Artificial Breakpoint

Natural Breakpoint
It uses the specified breakpoint rates and dates to derive the annualized basis amount, and calculate
breakpoint detail volumes and rates. Only one natural break can exist per line item per period. If you
select natural as the break type, you also need to include the base rent amount, base rent type, and natural
break rate. This information is used to calculate the breakpoint volume. The breakpoint volume is
automatically calculated and the rate is defaulted to the natural breakpoint rate.

• Property Manager calculates the period breakpoint volume as: Base Rent/Natural Break Rate

• Property Manager calculates the group breakpoint volume as: Base Rent/Natural Break Rate x
No. of Reporting Periods

• You can have only a single breakpoint volume record.

• The base rent, base rent type, and natural break rate are required.
 • Property Manager defaults the natural break rate into the Rate field.

Below is the calculation using a natural breakpoint .

Calculation is based on :

Calculation method: Cumulative Partial year Method: Standard Invoice On: Actual Negative Rent: Ignore
Volume type: Percentage
Category: Base Rent
Defining Natural Breakpoint and checking the calculation

Commercial clothing: 10%

Commercial Footwear: 20%
Direct Men’s Shoes: 15%
Start date: 01-Jan-2008
End Date: 31-Dec-2010
Entered Volumes for Commercial clothing from Jan-2008 to Apr-2008

Calculation for the above

So the calculation goes
Volume*rate

Rate is 0.1
Volumes are as below: 1-Jan-2008 -31-Jan-2008 =1000
1-Feb-2008-29_Feb-2008=2000
1-Mar-2008-31-mar-2008 =3000
 1-Apr-2008-30-Apr-2008 =4000
Calculation is: (1000*.01)+(2000*.2)+(3000*.1)+(4000*.1) =1000

Artificial Breakpoint
For artificial breakpoints, you must manually enter the ranges of volumes and corresponding rates for
breakpoint details. For breakpoint details, you can either enter period breakpoint volumes or group
breakpoint volumes, and Oracle Property Manager calculates the other using the following formula. A
period breakpoint volume is for an annual period; a group breakpoint volume is for a calculation period.

Group breakpoint detail volume equals Period breakpoint detail volume divided by Number of calculation
periods in an annual period

You can enter multiple breakpoint volumes and change them at any time. A variable rent agreement can
have the following artificial breakpoint types each with its own method of applying breakpoint rate.

• The period breakpoint volume is user entered.

• You can have multiple breakpoint volume records.

• You cannot enter the same breakpoint volume in two rows for the same line item.

• You cannot enter overlapping breakpoints eg: 1- 100 and 50- 150

• The period breakpoint and rate are required. You must specify the rate that will be charged for
each revenue band.
Stratified. This breakpoint type has multiple breakpoint details with different volume ranges for the same
set of dates. For stratified breakpoints, Oracle Property Manager calculates overage volumes separately
for each range and multiplies each volume with the rate associated with that range. The total gross
variable rent for the calculation period is the sum of the gross variable rents for all ranges.

Below is the example of a stratified breakpoint Calculation

Creating breakpoint, entering volumes and checking calculation further

Below is the calculation
 Gross Cumulative
Date Date Periodic Periodic Group Grouup Variable Gross
Range Range Breakpoin Breakpoi Breakpoint Breakpoint Volume rent(Overa Variable
From To t From nt To From(GBF)* To(GBT)* Rate Entered Overage ge*rate) rent
(15000-833.33) -
(15000-
1-Jan-14 31-Jan-14 10000 15000 833.33 1250 0.1 15000 1250)=416.67 41.67 41.67
1-Jan-14 31-Jan-14 15000 1250 0.15 15000 (15000-1250)=13750 2062.5 2104.17

(15000-833.33) -
1-Feb- 28-Feb- (15000-
14 14 10000 15000 833.33 1250 0.1 18001 1250)=416.67 41.67 2145.837
1-Feb- 28-Feb- 15000 1250 0.15 18001 (18001-1250)=16751 2512.65 4658.49
14 14
(15000-833.33) -
1-Mar- 31-Mar- (15000-
14 14 10000 15000 833.33 1250 0.1 15000 1250)=416.67 41.67 4700.16
1-Mar- 31-Mar- 15000 1250 0.15 15000 (15000-1250)=13750 2062.5 6762.66
14 14
Note:

*GBF periodic breakpoint from/12 *GBT Periodic breakpoint to/12

Flat. This breakpoint type supports only one breakpoint detail with one range of volume for a set of dates.
For a flat breakpoint, Oracle Property Manager calculates variable rent on the reported volume above the
breakpoint detail volume per the rate of the last included breakpoint detail volume. Below is the example
of a Flat Breakpoint Calculation
Below is the calcualtion
Gross
Group Variable
Breakpoin Grouup YTD rent(Curre Cumulativ
Date Date Periodic Periodic t Breakpoin Breakpoin YTD nt e Gross
Range Range Breakpoin Breakpoin From(GBF t t Breakpoin Volume Current overagr*r Variable
From To t From t To )* To(GBT)* From(YBF) t to(YBT) Rate Entered Overage Overage ate) rent
1-Jan- 31- YBT=416.6
08 Jan-08 0 5000 0 416.67 0 416.67 0 2000 7 416.67 0 0
(2000416.67)=1
1-Jan- 31- 583.33
08 Jan-08 5000 416.67 416.67 0.15 2000 1583.33 237.5 237.5
29- YBT=833.3
1-Feb- Feb- 3
08 08 0 5000 0 416.67 833.33 0 4000 833.33 0 237.5
29- (4000833.33)=5 (5167.331583.33)=
1-Feb- Feb- 166.67 3583.34
14 08 5000 416.67 833.33 0.15 4000 537.5 775.00
1- 31-
Mar- Mar-
08 08 0 5000 0 416.67 1250 0 6000 YTB= 1250 1250 0 775
1- 31- (120001250)=10 (107505166.67)=
Mar- Mar- 750 5583.33
08 08 5000 416.67 1250 0.15 6000 837.5 1612.5

Sliding. This breakpoint type has multiple breakpoint details with different volume ranges for the same
set of dates. For a sliding breakpoint, Oracle Property Manager calculates variable rent on the total
reported volume per the rate of the last included breakpoint detail volume.
For example, if the volume is $3,000 and the agreement states that the tenant pays 5 percent for any
volume over $1,000, and 10 percent for any volume over $2,000, then the tenant must pay $300 ($3,000
at 10 percent).

Below is an example of Sliding Breakpoint Calculation

Entering Volumes and checking calculation

Now lets check the output
Processing variable rent number: 12144
Processing period number: 1 The
ACTUAL rent amount is: 4000

Below is the calculation done by system

 Group
Breakpoin Grouup Cumulativ
Date Periodic Periodic t Breakpoin Gross Variable e Gross
Range Date Range Breakpoin Breakpoin From(GBF t Volume rent(Volume*ra Variable
From To t From t To )* To(GBT)* Rate Entered te) rent
1-Jan-14 31-Jan-14 10000 833.33 0.2 5000 1000 1000

1-Feb-14 28-Feb-14 10000 833.33 0.2 15000 3000 4000.00

Note:-For each breakpoint detail, Oracle Property Manager calculates the period breakpoint volume and
then uses this period breakpoint volume to calculate the group breakpoint volume. The period breakpoint
volume is for an annual period whereas the group breakpoint volume is for a calculation period. See the
following formulas:

1. Period breakpoint volume equals annualized basis amount divided by Breakpoint rate for the
annual period

2. Group breakpoint volume equals Period breakpoint volume divided by Number of calculation
periods in an annual period
Entering Volumes
Oracle Property Manager enables you to record volumes that the tenant reports on a regular
basis. The Calculate Variable Rent concurrent program considers these volumes for calculating
rent. You enter volumes for a reporting period. You can enter volumes manually by line items or
in a batch for multiple leases in the Variable Rent Gateway. You can also use the Variable Rent
Gateway to enter batches of volumes directly from the tenant's application.

The calculation process only uses volumes with approved status. The VR Volume Status Default
profile option controls the default status value. You can set the default value for the profile option
to Draft or Approved, depending on your business process.

You can change a volume in the Line Items window till you approve the variable rent term using
this volume. You can change volumes in the Variable Rent Gateway at any time. However, if you
change a volume after approving the variable rent term based on this volume, you must
recalculate variable rent.

Entering Volumes by Lines:

Reported volumes can be entered by line items in the Volume tab of the Line Items window. If
you select to invoice on forecast volumes, you can enter actual volumes in the Line Items window
only after you enter forecast volumes and calculate rent based on forecast volumes

Since the calculation process only uses approved volumes, you must ensure that you set the status
to Approved for volumes before running the variable rent calculate process.

Below screenshot shows volumes entered by lines

Entering Volumes Using Variable rent Gateway:

The Variable Rent Gateway enables you to view volumes for multiple agreements and leases on a single
page, and quickly enter in a single batch, relevant volumes reported by the tenant. You can create a batch
for actual volumes, forecast volumes, or deductions for different variable rent agreements. You can create
a new batch of volumes that you enter manually in the Create Volume History page from Variable Rent
Gateway Volume Import. Alternatively, you can design a custom process to automatically load batches of
volumes into the Variable Rent Gateway directly from another application.

The Variable Rent Gateway consists of interface tables in which you enter volumes for import into Oracle
Property Manager using the Variable Rent Gateway Import Process concurrent program. To create a batch,
you specify a range of leases or locations, and dates for which you want to enter volumes. You can then
enter volumes for each reporting period of the variable rent agreements associated with the lease or
location.

You can also edit reporting period dates for a volume in the Variable Rent Gateway. When you edit reporting
dates, Oracle Property Manager validates the new dates against the defined calculation frequency. You can
save the batch, search for it later, and continue editing and adding to the batch before you import volumes.
After you enter volumes, you can import a single batch from the Create Volume History page or run the
Variable Rent Gateway Import Process concurrent program from the concurrent manager to import
multiple batches.

After you import batches, you can revise volumes including volumes used in calculations for approved
variable rent terms. After you revise volumes, you must re-import and recalculate rent. To revise volumes
in the Variable Rent Gateway, create a new batch and select the Show Period Volumes for Revision check
box on the Create History page to display existing volumes for editing. This batch includes existing volumes
for the specified date range and leases or locations, and reporting periods that do not have any existing
volumes. When you import changed volumes, the Variable Rent Gateway Import Process concurrent
program saves the original volumes in a volume archive table. You can also update the status and report
types for volumes in the Variable Rent Gateway.
Create a new batch
name

Enter Volume
History Data

Submit For Import

or Save Later

Purge Batch or
Volume History
Navigation: Oracle Property Manager Responsibility -> Open Interfaces -> variable Rent Gateway
We will enter volumes using Variable rent gateway for a Variable rent.

After Querying click create volume history

Provide reporting date low and high with date values for which volume needs to be entered. Above we
are entering volumes from Jan-2006 to Feb-2006
Click Continue on the right top of the page

Enter Volumes and click finish button

Once Finished is clicked it will kick Variable Rent Gateway Import concurrent program

Output for the above Variable Rent Gateway Import program

Verifying the same from Variable Rent screen also

Tables Used are: PN_VOL_HIST_BATCH_ITF and PN_VOL_HIST_LINES_ITF

Variable Rent Agreement Calculation Methods

To calculate gross variable rent for a calculation period, Oracle Property Manager uses the calculation
method that you select to derive the volume and the breakpoint volume that it must consider.
Basically current there are four type Variable Rent calculation Methods

• Cumulative Calculation Method

• Non Cumulative Calculation Method

• Year To Date Calculation Method

• True Up Calculation Method

Using the Cumulative Calculation Method

The cumulative calculation method compares the year-to-date cumulative volume for the
calculation period with the cumulative breakpoint volume for each breakpoint rate in the same
period. For the volume, this method considers the cumulative cycles of the agreement. A
cumulative cycle starts and ends with an annual period unless the breakpoint rate changes. A
change in the breakpoint rate starts a new cumulative cycle.

If a breakpoint changes in the middle of a cumulative cycle, and particularly if it changes in the
middle of a calculation period, the calculation for gross variable rent is as follows.

For the cumulative cycle, Oracle Property Manager follows the steps below to determine annual
breakpoints:

1. Determines prorated group breakpoints using the proration factor for each calculation
subperiod
2. Adds group breakpoints for all calculation periods and subperiods in the cumulative cycle to
arrive at annual breakpoint

It follows the steps below to calculate gross variable rent for each calculation period:

1. Determines the net volume to date, as of the end of the calculation period
2. Determines overage for the calculation period by comparing the annual breakpoints with the
year-to-date volume
3. Calculates gross variable rent for the calculation period by multiplying the rate with the
overage

Variable Rent created with below setups:

Defined 2 breakpoints:

Commercial- Clothing Breakpoint Type: Natural

Commercial Food Breakpoint Type: Artificial
 Entering Volumes:

Volumes entered for clothing

Entering volumes for Food

Calculating VR using cumulative method

Below is the output

The ACTUAL rent amount is 2850

So the calculation is like : for natural breakpoint: actual cumulative * rate=6000*.1=600
For artificial Breakpoint calculation will be done at the end of each period after comparison from
previous period. Final calculation will be like :

(Actual amount- previous period cumulative amount) * rate=(25000- 1000)*.15

=2250
Total value: 600+2250=2850
Using the Noncumulative Calculation Method
The noncumulative calculation method compares the total volume for the current calculation period with
the breakpoints for the same period to determine the overage, then multiplies the overage with the rate
for the gross variable rent.

A calculation period can have a sub period if the calculation period is at the start or end of the agreement
or if the calculation period has a change in breakpoint or breakpoint rate. In this case, Oracle Property
Manager uses the following steps to calculate the gross variable rent:

1. Determines prorated group breakpoints using the proration factor for the sub period
2. Determines prorated net volume for the sub period
3. Determines overage for the calculation sub period by comparing prorated breakpoints with
prorated volumes
4. Calculates segment gross variable rents for calculation sub periods by multiplying the rate with
the overage for each sub period
5. Adds segment gross variable rents for the calculation period Creating variable rent with non-

cumulative calculation method

Creating breakpoint, entering volumes and checking calculation further

Output is:
Parameters
Lease number
from:
Lease number to:
Location code from:
Location code to:
Variable rent number from: Variable
rent number to:
Period number from:
Period number to:
Responsible user:
For sales month ended:
(PT_NAME=) (PT_CODE=)
Processing variable rent number: 11143
Processing period number: 1 The
ACTUAL rent amount is: 6762.66

Below is the calculation

Gross
Date Periodic Periodic Group Grouup Variable Cumulative
Range Date Range Breakpoin Breakpoi Breakpoint Breakpoint Volume rent(Overa Gross
From To t From nt To From(GBF)* To(GBT)* Rate Entered Overage ge*rate) Variable rent
(15000-833.33) -(15000-
1-Jan-14 31-Jan-14 10000 15000 833.33 1250 0.1 15000 1250)=416.67 41.67 41.67
1-Jan-14 31-Jan-14 15000 1250 0.15 15000 (15000-1250)=13750 2062.5 2104.17

(15000-833.33) -(15000-
1-Feb-14 28-Feb-14 10000 15000 833.33 1250 0.1 18001 1250)=416.67 41.67 2145.837
1-Feb-14 28-Feb-14 15000 1250 0.15 18001 (18001-1250)=16751 2512.65 4658.49

(15000-833.33) -(15000-
1-Mar-14 31-Mar-14 10000 15000 833.33 1250 0.1 15000 1250)=416.67 41.67 4700.16
1-Mar-14 31-Mar-14 15000 1250 0.15 15000 (15000-1250)=13750 2062.5 6762.66

Note:

*GBF periodic breakpoint from/12 *GBT Periodic breakpoint to/12

Using the Year-to-Date Calculation Method
The Year-to-Date calculation method compares the year-to-date cumulative volumes with year-to-date
breakpoints. This method considers the cumulative cycles in the agreement. For information on
cumulative cycles, see Cumulative Calculation Method.

As with the cumulative method, if a breakpoint changes in the middle of a cumulative cycle, and
particularly if it changes in the middle of a calculation period, Oracle Property Manager follows the steps
listed below to determine year-to-date breakpoints:

1. Determines prorated group breakpoints using the proration factor for each calculation sub period
2. Adds group breakpoints for all calculation periods and sub periods up through the end of the
current calculation period to derive the year-to-date breakpoint

Next, Oracle Property Manager follows the steps listed below to calculate gross variable rent for each
calculation period:

1. Determines the net volume to date, as of the end of the calculation period
2. Determines overage for the calculation period by comparing the year-to-date breakpoints with
the year-to-date volume
3. Calculates gross variable rent for the calculation period by multiplying the rate with the overage

Creating variable Rent

Entering volumes for all 3 breakpoints and calculating rent
Here to check calculation breakpoint wise approved volumes for Product category Goods and ran
Calculate Variable rent program
Below is the output
Processing variable rent number: 11144
Processing period number: 1 The
ACTUAL rent amount is: 1612.5

Below is the Calculation

Gross
Group YTD Variable
Breakpoi Breakpoi rent(Curr
Date Date nt Grouup n YTD Volum e Cumulati
Rang Rang Periodic Periodic From(GB Breakpoi t Breakpoi e nt v e Gross
e e Breakpoi Breakpoi F) nt From(YB nt Rat Entere Current overagr* Variable
From To n t From n t To * To(GBT)* F) to(YBT) e d Overage Overage r ate) rent
1- 31- YBT=416.6
Jan- Jan- 7
08 08 0 5000 0 416.67 0 416.67 0 2000 416.67 0 0
1- 31- (2000416.67)=
Jan- Jan- 0.1 1
08 08 5000 416.67 416.67 5 2000 583.33 1583.33 237.5 237.5
1- 29- YBT=833.3
Feb- Feb- 3
08 08 0 5000 0 416.67 833.33 0 4000 833.33 0 237.5
1- 29- (4000833.33)= (5167.331583.33
Feb- Feb- 0.1 5 )=
14 08 5000 416.67 833.33 5 4000 166.67 3583.34 537.5 775.00
1- 31-
Mar- Mar-
08 08 0 5000 0 416.67 1250 0 6000 YTB= 1250 1250 0 775
1- 31- (120001250)= (107505166.67)=
Mar- Mar- 0.1 10 5583.33
08 08 5000 416.67 1250 5 6000 750 837.5 1612.5

Note:
*GBF periodic breakpoint from/12
*GBT Periodic breakpoint to/12
*YBF GBF*number of current period in fiscal year
*YBT GBT*number of current period in fiscal year
 Approving volumes for other 2 breakpoints and checking the calculation

Processing variable rent number: 11144

Processing period number: 1 The
ACTUAL rent amount is: 4012.5

Final Calculation is explained below:

Here for natural breakpoint the calculation works same as for cumulative breakpoint for breakpoint
type natural, which means: cumulative volume *rate

So For product category Clothing at the end of quarter the cumulative volume is 6000 and rate is .1

Calculation is like =6000*.1 =600

For product category Food at the end of quarter the cumulative volume is 9000 and rate is .2

Calculation is like =9000*.2=1800

So total calculated VR for all 3 categories will be 600+1800+1612.5=4012.5

Using the True Up Calculation Method
The True Up calculation method is a combination of the cumulative and noncumulative calculation
methods. The calculation process first performs a noncumulative calculation for each invoice period. You
then create a variable rent term for this rent amount that is essentially an estimated payment or billing
term.

At the end of the annual period, you must run the Variable Rent True Up concurrent program to calculate
the actual rent amount for the annual period. This program compares the cumulative annual period
volume with the annual breakpoint. If the breakpoint changes in the annual period, Oracle Property
Manager determines and uses a blended annual breakpoint.

If the calculated gross variable rent amount for the annual period using the cumulative method is different
from the sum of the estimated terms, you must create an adjustment term called the true-up term for the
difference.

Note: -The true-up process considers approved and draft estimated terms when calculating the difference
between estimated terms and the cumulative true-up rent amount for the entire annual period.

You can run the Variable Rent true Up concurrent program for agreements by a selected lease or property.
Creating variable rent with below parameters

Below are the breakpoint details

Entering volumes
Approving volumes and calculating Variable Rent

Processing variable rent number: 12148

Processing period number: 1 The
ACTUAL rent amount is: 2740.04

Date Periodic Periodic Group Grouup Annual Annual Cumulative

Range Date Breakpoint Breakpoint Breakpoint Breakpoint Breakpoint Breakpoint Volume Gross Variable Variable
From Range To From To From(GBF)* To(GBT)* From To Rate Entered Overage rent(Overage*rate) Rent
1-Jan-14 31-Jan- 1000 12000 83.33 1000 500 6000 0.1 2000 916.67 91.67 91.67
14

1-Feb-14 28-Feb- 1000 12000 83.33 1000 500 6000 0.1 900 816.67 81.67 173.34
14

1-Mar-14 31-Mar- 1000 12000 83.33 1000 500 6000 0.1 2000 916.67 91.67 256.01
14

1-Apr-14 30-Apr- 1000 12000 83.33 1000 500 6000 0.1 2000 916.67 91.67 356.68
14

1-May-14 31-May- 1000 12000 83.33 1000 500 6000 0.1 2000 916.67 91.67 448.35
14

1-Jun-14 30-Jun- 1000 12000 83.33 1000 500 6000 0.1 2000 916.67 91.67 540.02
14
 1-Jul-14 31-Jul-14 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 906.69

1-Aug-14 31-Aug- 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 1273.36
14

1-Sep-14 30-Sep- 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 1640.03
14

1-Oct-14 31-Oct- 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 2006.70
14

1-Nov-14 30-Nov- 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 2373.37
14

1-Dec-14 31-Dec- 2000 24000 166.66 2000 1000 12000 0.2 8000 1833.33 366.67 2740.04
14

Note:- If the volume entered is between the range of Annual breakpoint then overage = GBT-GBF

Creating Terms and approving them before running True Up concurrent program
Now running PN – Variable Rent True Up Concurrent program to get the final calculation
Here output needs to be checked in the log file
l_total_period_rent2750
Let’s check the calculation that has

So true UP program actually breaks the calculation based on breakpoints defined

al
Breakpoi
Date Group Grouup nt To-
Rang Date Periodic Periodic Breakpoi Breakpoi Annual Annual Volu Annual Cumulati
e Rang Breakpoi Breakpoi nt nt Breakpoi Breakpoi me Breakpoi Variab ve
Fro e nt nt From(GB To(GBT) nt nt Rat Enter nt le Variable
m To From To F)* * From To e ed From) Rent rent
1- 30- 1000 12000 83.33 100 500 6000 0. 10900 5500 550 500
Jan- Jun- 0 1
14 14
1- 31- 2000 24000 166.67 200 1000 12000 0. 48000 11000 2200 2750
Jul- Dec- 0 2
14 14
Overage(Annu
Partial Year Calculation Methods
When an agreement has first or last years that are partial years, you can select from the various partial
year methods that Oracle Property Manager provides to calculate rent for these periods. To calculate rent
for a partial period, Oracle Property Manager must prorate volumes and breakpoints.

Partial year methods ensure that variable rent amounts are appropriate to the duration of the first or last
year of an agreement. For example, many retailers in the US make more than half of their yearly sales in
the three months leading up to Christmas. For these retailers, using a prorated annual breakpoint for a
partial year can lead to a very high or very low percentage of rent.

If $1,800,000 of annual sales, instead of being steady, comes from six months at $100,000 followed by six
months at $200,000 per month. If the six-month partial year is in the first half of the year and the annual
prorated breakpoint is $750,000, the overage is (6 x $100,000) - $750,000 = $0. If it falls, however, in the
last half of the year, the overage volume is (6 x $200,000) - $750,000 = $450,000. Neither of these is fair.
Consequently, lease negotiation is likely to result in a blended annual breakpoint with an overage rate of
approximately $25,000 per month, as it would be, on average, during a full year.

For the other years of the agreement that have complete annual periods, Oracle Property Manager uses
the calculation method you select to calculate rent.

Oracle Property Manager provides the following partial year methods:

• Standard
• First Year
• Last Year
• First Year and Last Year
• Combined Sales with Breakpoint Proration
• Combined Sales Without Breakpoint Proration
• No Proration

Note: For agreements with a last partial year, Oracle Property Manager uses the Standard Proration partial
year method to calculate rent unless you select a Last Year or a First Year and Last Year partial year
method.
Only certain partial year methods are compatible with certain calculation methods. The table below shows
valid and invalid combinations.

Cumulative Year-to-Date True Up

Calculation Calculation Calculation
Partial Year Noncumulative Method Method Method
Calculation Method Calculation Method

Standard Yes Yes Yes Yes

First Year No Yes Yes Yes

Last Year No Yes Yes Yes

First Year and Last No Yes Yes Yes

Year

Combined Sales No Yes Yes Yes

Without Breakpoint
Proration
Combined Sales with No Yes Yes Yes
Breakpoint Proration

No Proration Yes Yes No No

Note:- If the agreement has an Invoice On value of Forecasted, then Oracle Property Manager only uses
the Standard and No Proration partial year methods.

First Year:

For a first partial year, the calculation process determines the volume for a full year by combining the
actual volume for the partial year with the actual volume from the first part of the next year to make up
for the missing volumes in the year. For example, if the sales year starts on January 1, but the agreement
begins on April 1, the variable rent for the first annual period is based on the nine months of volumes from
April to December, plus the volumes from January to March of the second sales year.

Oracle Property Manager calculates variable rent as if it was for a full year and prorates the result so that
the actual percentage rent is proportional to the fraction of the year covered by the agreement. First Year
Proration is always based on 365 or 366 days.

The calculation formula for the first partial year is as follows:

((Sales for first 365 or 366 days – 365 or 366 days Breakpoint volume) *Rate) * (Number of days in the
partial year/365 or 366 days)

Note: You can only create a term for an invoice for the first partial year at the end of the first full year.
Negative rent rules apply starting with the first full year. If the agreement also has a last partial year,
Oracle Property Manager applies the standard proration method to calculate the rent for the last partial
year.

If you select the true-up, cumulative, or year-to-date calculation method with the First Year partial year
method, Oracle Property Manager performs all true-up, cumulative, and year-to-date calculations only
after you enter volumes for the first twelve months.
Processing variable rent number: 12146
Processing period number: 1
The ACTUAL rent amount is: 6666.67
Now let’s check the calculation and how First period has worked here

Periodic Variable
Group Annual rent(Current period
Breakpoin Grouup Annual Breakpoin Current Gross Cumulative cumulative Gross Variabel
Date Periodic Periodic t Breakpoin Breakpoit t Variable Gross Variable rent-Previous period
Range Date Range Breakpoin Breakpoin From(GBF t From(ABF to(ABT)++ Volume Cumulative rent(cumulaive rent(final cumulative gross vairable
From To t From t To )* To(GBT)* )++ + Rate Entered Volume Overage volume *rate) overage *rate) rent)
1-May-05 31-May-05 0 10000 0 833.33 0 6666.67 0.1 1000 1000 1000 100 100 100

1-May-05 1-May-05 10000 833.33 6666.67 0.2 1000 1000 0 100 100 100

1-Jun-05 30-Jun-05 0 10000 0 833.33 6666.67 0.1 2000 3000 3000 300 300 200

1-Jun-05 30-Jun-05 10000 833.33 6666.67 0.2 2000 3000 0 300 300 200

1-Jul-05 31-Jul-05 0 10000 0 833.33 6666.67 0.1 3000 6000 6000 600 600 300

1-Jul-05 31-Jul-05 10000 833.33 6666.67 0.2 3000 6000 0 600 6000 300

1-Aug-05 31-Aug-05 0 10000 0 833.33 0 6666.67 0.1 4000 10000 *6666.67 666.67 666.67 66.67

1-Aug-05 31-Aug-05 10000 833.33 6666.67 0.2 4000 10000 **3333.33 667.67 667.67 66.67

1-Sep-05 30-Sep-05 0 10000 0 833.33 6666.67 0.1 5000 15000 6666.67 666.67 1666.67 1000

1-Sep-05 30-Sep-05 10000 833.33 6666.67 0.2 5000 15000 8333.33 ***1666.67 ***1666.67 1000

1-Oct-05 31-Oct-05 0 10000 0 833.33 6666.67 0.1 6000 21000 6666.67 666.67 2866.67 1200

1-Oct-05 31-Oct-05 10000 833.33 6666.67 0.2 6000 21000 14333.33 2866.67 2866.67 1200

1-Nov-05 30-Nov-05 0 10000 0 833.33 0 6666.67 0.1 7000 28000 6666.67 666.67 4266.67 1400

1-Nov-05 30-Nov-05 10000 833.33 6666.67 0.2 7000 28000 21333.33 4266.67 4266.67 1400

1-Dec-05 31-Dec-05 0 10000 0 833.33 6666.67 0.1 12000 40000 6666.67 666.67 6666.67 2400

1-Dec-05 31-Dec-05 10000 833.33 6666.67 0.2 12000 40000 3333.33 6666.67 6666.67 2400
++ GBF*remaining number of periods in current fiscal year

+++ GBT* remaining number or periods in current fiscal year

* the moment cumulative volume reaches the periodic breakpoint threshold overage for first rate will be
annual breakpoint to

** the overage for next row of rate will be cumulative volume - overage (which is annual breakpoint to)
and overage will be compared to the annual breakpoint to figure out the rate applicable. It would either
of one row only one rate will be applicable

*** for a volume single rent will be applicable and if annual breakpoint is less than the overage than the
second one will be applicable this has happened in current scenario

Last Year Partial Year Calculation Method

The method is the same as the First Year method, except that it uses the volume from the last 12 months
of the lease instead of the first 12 months. However, if you select this method for an agreement with
partial first and last years, Oracle Property Manager uses the Standard Proration method to calculate rent
for the first partial year.

First Year and Last Year Partial Year Calculation Method

This method uses the First Year partial year method for a partial first year and the Last Year partial year
method for a partial last year.

Using the Combined Sales with Breakpoint Proration Calculation Method

This method evens out the overage amount for the partial period by blending it with a full year of sales.
The calculation process for this method compares the sum of the sales for the first partial year and the
first full year with the total breakpoint for the combined period.

For example, if the annual breakpoint is $1,500,000, the effective annual breakpoint is $750,000 for a
combined period of 6 months, and $2,250,000 for a combined period of 18 months. If you select a
cumulative calculation method, the calculation process uses a breakpoint value of $750,000 for 6 months
and $2,250,000 for 18 months. The monthly breakpoint stays at $125,000 for either combined period.

You can use this method with the cumulative, year-to-date, or true-up calculation methods. The
calculation process uses the calculation method to calculate rent for the first combined period that
combines the first two years making the first annual period more than 12 months. Thus, the cumulative
cycle, normally one year or less, may be longer than a year. The calculation process must determine both
volumes and breakpoints for this cumulative cycle.
Unlike with the First Year and Last Year partial period methods, Oracle Property Manager creates terms
throughout the combined period. If you select the true-up calculation method, Oracle Property Manager
performs a single true-up calculation for the combined period of partial year and first full year.

Note: The combined rules do not deal with last partial years. If the agreement has a last partial year, Oracle
Property Manager uses standard proration to calculate rent for the last partial period.

Lets create and variable rent for partial year combined sales with breakpoint proration calculation method
Entering Volume and checking Calculation

For sales month ended:

(PT_NAME=) (PT_CODE=)
Processing variable rent number: 12147
Processing period number: 1
The ACTUAL rent amount is: 4666.67
Below is the calculation done by system

Cumulative Periodic Variable

Group Gross rent(Current period
Breakpoin Grouup Annual Current Gross Variable cumulative Gross
Date Date Periodic Periodic t Breakpoin Breakpoit Annual Variable rent(final Variabel rent-Previous
Range Range Breakpoin Breakpoin From(GBF) t From(ABF) Breakpoin Volume Cumulative rent(cumulaive overage period cumulative
From To t From t To * To(GBT)* * t to(ABT)* Rate Entered Volume Overage volume *rate) *rate) gross vairable rent)
1-May- 31-May- 0 10000 0 833.33 0 16666.67 0.1 1000 1000 1000 100 100 100
05 05

1-May- 1-May-05 10000 833.33 16666.67 0.2 1000 1000 0 100 100 100
05

1-Jun-05 30-Jun-05 0 10000 0 833.33 16666.67 0.1 2000 3000 3000 300 300 200

1-Jun-05 30-Jun-05 10000 833.33 16666.67 0.2 2000 3000 0 300 300 200

1-Jul-05 31-Jul-05 0 10000 0 833.33 16666.67 0.1 3000 6000 6000 600 600 300

1-Jul-05 31-Jul-05 10000 833.33 16666.67 0.2 3000 6000 0 6000 600 300

1-Aug- 31-Aug- 0 10000 0 833.33 0 16666.67 0.1 4000 10000 10000 1000 1000 400
05 05

1-Aug- 31-Aug- 10000 833.33 16666.67 0.2 4000 10000 10000 0 1000 400
05 05

1-Sep-05 30-Sep- 0 10000 0 833.33 16666.67 0.1 5000 15000 15000 1500 1500 500
05

1-Sep-05 30-Sep- 10000 833.33 16666.67 0.2 5000 15000 15000 0 1500 500
05

1-Oct-05 31-Oct-05 0 10000 0 833.33 16666.67 0.1 6000 21000 16666.67 1666.67 866.67 -633.33

1-Oct-05 31-Oct-05 10000 833.33 16666.67 0.2 6000 21000 4333.33 866.67 866.67 -633.33

1-Nov- 30-Nov- 0 10000 0 833.33 0 16666.67 0.1 7000 28000 16666.67 1666.67 2266.67 1400
05 05

1-Nov- 30-Nov- 10000 833.33 16666.67 0.2 7000 28000 11333.33 2266.67 2266.67 1400
05 05

1-Dec-05 31-Dec- 0 10000 0 833.33 16666.67 0.1 12000 40000 16666.67 1666.67 4666.67 2400
05

1-Dec-05 31-Dec- 10000 833.33 16666.67 0.2 12000 40000 23333.33 4666.67 4666.67 2400
05

*(remaining number of periods in current fiscal year +periods in next fiscal year)*GBF or GBT

Using the Combined Sales Without Breakpoint Proration Calculation Method

This partial year method compares the sum of the sales for the first partial year and the first full year to
an annual blended breakpoint for the combined period.

An annual blended breakpoint is the average monthly breakpoint for the combined period multiplied by
12 (the number of months in a period). The average monthly breakpoint for the combined period is the
sum of the monthly breakpoints for the combined period divided by the number of months in the
combined period. The blended annual breakpoint is, in effect, one that does not change with the length
of the combined period though the sales does.

Note: Because the breakpoint is calculated for 12 months rather than for the combined period which is
longer than 12 months, the breakpoint is considered not prorated.

You can use this method with the cumulative, year-to-date, or true-up calculation methods. The
calculation process also uses a blended monthly breakpoint if you select the true-up or year-to-date
calculation methods with this partial year method. Oracle Property Manager creates noncumulative terms
throughout the combined period. If you select the true-up calculation method, Oracle Property Manager
also performs a single true-up calculation for the combined period of partial year and first full year.

Using the No Proration Calculation Method

This partial year method does not prorate the annual breakpoint for the partial year. The calculation
process for this method compares the volume for the partial annual period with the breakpoint for the
annual period. Oracle Property Manager creates terms during the partial year if the volume exceeds the
breakpoint.
Variable Rent Important Tables

• PN_VAR_RENTS_ALL: Stores variable rent agreement information such as lease associated, variable
rent number, critical date information, location. This table is portioned based on org

• PN_VAR_RENT_SUMM_ALL: Stores the calculated variable rent for a line item fora group date and
related volumes used to calculate the variable rent for forecasted and/or actual volumes based on the
option chosen in the variable agreement

• PN_VAR_PERIODS_ALL: Stores periods critical date information, period number, proration factor and
the associated variable variable rent id. This table is partitioned by org.

• PN_VAR_RENTS_ALL: Stores variable rent agreement information such as lease associated, variable
rent number, critical date information, location.

• PN_VAR_RENT_DATES_ALL: Stores GL Calendar to be used and variable agreement related date

frequencies

• PN_VAR_GRP_DATES_ALL: Stores critical dates related to the variable rent agreement generated by
the periods generation program

• PN_VAR_RENT_DATES_ALL: Stores GL Calendar to be used and variable agreement related date

frequencies

• PN_VAR_TRX_HEADERS_ALL: stores details of variable rent calculations

• PN_VAR_LINE_DEFAULTS_ALL: This table stores Breakpoint Detail information to be cascaded from

VR setup tables to main tables of Variable rent agreement

• PN_VAR_BKHD_DEFAULTS_ALL: Breakpoint Header defaults like type, start and end date, frequency
etc

• PN_VAR_BKDT_DEFAULTS_ALL: stores setup information for breakpoint details by organization.

• PN_VAR_ABATEMENTS_ALL: Stores information about the main lease payment/billing terms to be
used for calculating the recurring abatement amount applicable to an invoice.

• PN_VAR_CONSTRAINTS_ALL: Stores constraints to be applied to a period for the calculation of

variable rent, constraint type and classification

• PN_VAR_DEDUCTIONS_ALL: Stores deductions to be applied to each line item for calculation of

variable rent, deduction type, related start and end dates, deduction type and account information

• PN_VAR_LINES_ALL: Stores information related to line items such as item category, type, associated
period id
• PN_VAR_VOL_HIST_ALL: Stores volume history related to a line item and related start and end date,
reporting date information, associated account information for actual, forecasted volumes reported

• PN_VOL_HIST_BATCH_ITF: This is interface table which contains information of Variable Rent Volume
History Batch which is being imported into Variable Rent Volume History table.

• PN_VOL_HIST_LINES_ITF: This is interface table which contains information of Variable Rent Volume
History Batch lines which is being imported into Variable Rent Volume History table.
Entity Relation Diagram for Variable Rent
Table Association with Screens and Sample Data

Table : PN_LEASE_DETAILS_ALL

Data present for the above in variable rent trace

Table: PN_VAR_RENTS_ALL

Data present for the above in variable rent trace

Table: PN_VAR_RENTS_ALL

Data present for the above in variable rent trace

Table: PN_VAR_PERIODS_ALL

Data present for the above in variable rent trace

Click on Invoice review tab

Table: PN_VAR_RENT_INV_ALL

Data present for the above in variable rent trace

Setup button in variable rent main page stores data for breakpoints and its details

Table: PN_VAR_LINE_DEFAULTS_ALL

Data present for the above in variable rent trace

Table: PN_VAR_BKHD_DEFAULTS_ALL

Data present for the above in variable rent trace

Above it is linked via bkhd_default_id which is breakpoint id

Table: PN_VAR_BKDT_DEFAULTS_ALL

Data present for the above in variable rent trace

Next to breakpoint tab navigate to Constraints tab

Table:PN_VAR_CONSTRAINTS_ALL

Data present for the above in variable rent trace

Next tab is Allowances and Abatements

Table: PN_VAR_ABAT_DEFAULTS_ALL

Data present for the above in variable rent trace

In Line Review tab lets check the volumes entered

Table: PN_VAR_VOL_HIST_ALL

Data present for the above in variable rent trace

Next is deductions tab

Table: PN_VAR_DEDUCTIONS_ALL

Data present for the above in variable rent trace

Moving to Rent Actuals tab

Table: PN_VAR_RENT_SUMM_ALL

Data present for the above in variable rent trace

In Variable rent main page annual periods-> Term History

Table: PN_PAYMENT_TERMS_ALL

Data present for above in variable rent trace

Variable rent can also be added via API if bulk data needs to be loaded. Refer note for sample code:
Property Manager Create/Update Variable Rent APIs (Doc ID 2066548.1)

For generating variable rent trace: R12 Variable Rent Trace Script (Doc ID 2122031.1)
Code Flow
PN_VAR_RENT_PKG
(Validates the lease attached and creates variable rent
and generate periods)

PN_VAR_RENT_CALC_PKG (Validates and calculation

method, proration rule, volume type etc for variable r ent
before period is generated)

PN_VAR_TRX_PKG (Post validation and creation of variable

rent from above packages it create transaction level
details period wise)

PN_VRA_CLIENT_EXTN(Checks if variable rent override is

present and if so perform override calculation)

PN_VAR_RENT_CALC_PKG (Here it calculates the variable

rent based on setup )

PN_VAR_ABATEMENT_AMOUNT_PKG( Function to calculate

recurring abatement amount for an invoice DATE and period)

PN_VARIABLE_AMOUNT_PKG (Create Term and Approve Term )

Variable Rent Concurrent Programs
Program name: Create Variable Rent Terms
Short name: PNVRTERM
Package: PN_VARIABLE_TERM_PKG.Create_Payment_Term_Batch ([Link])

Program name: Calculate Variable Rent

Short name: PNVRCALC
Package: pn_var_rent_calc_pkg.Process_Rent_Batch ([Link])

Program name: Approve Variable Rent Payment Terms

Short name: PNVRAPPR
Package: PN_APPROVE_VARENT_PKG.Approve_Payment_Term_Batch ([Link])

Program name: PN - Variable Rent True Up

Short name: PNVRTRUP
Package: pn_var_trueup_pkg.trueup_batch_process([Link])