Oracle Property Management Interview Questions

1	What type(s) of rental customers do you have?
2	How do you group your rental customers?
3	How do you group your rental customers for statements?
4	How do you group your rental customers for interest charges for late payments?
5	How do you group your customers for payment rules?
6	Do terms and conditions of customer agreements and/or payment terms change based upon the status of their accounts?
7	Do you do miscellaneous invoicing? Please explain with examples.
8	Do you send customers statements?   If so please describe the process and highlight any exceptions.
9	What is the Present Property Hierarchy in Organization?
10	What is the critical information to be captured for Property? Please provide the details
11	What are the reporting requirement with respect to properties?
12	Are properties associated with the leases?
13	What are the details that are to be captured for the contacts that are related to the property?
14	Are the properties organized into geographical regions?
15	Please provide the list of the geographical regions
16	Are the regions organized into office Parks?
17	Please provide the list of the office parks and associated regions
18	Provide the list of the different kind of the properties to be defined (Building, Floors, Office or Land, Parcel and sections), Also provide the short name for the same.
19	Are property spaces currently assigned to employees or Cost Center?
20	What is the reporting requirement with respect to space utilization?
21	Do you want to assign Space to Employees?
22	Do you want to assign spaces to Cost Center?
23	Do tou want automatic Space Assignment?
24	Do you Assign one employee to multiple locations?
25	What are the Critical details captured for the leases?
26	What are the types of leases entered into? Gross Lease or Net lease.
27	What are the type of lease classes entered into? Direct, Third Party and Sub Lease.
28	Do you use Master Lease and Child leases?
29	What are the billing as well as payment terms?
30	What are the different services that are provided or availed under lease agreement?
31	How rent is calculated for the leases?
32	Is the Lease Numbering Manual or Automatic?
33	Who authorizes the Payment as well as billing schedule for the Leases for creation of invoices in AP and AR?
34	Who makes the amendment to the Lease Agreement?
35	What are the GL Account used for thr Different Expense Classes (Revenue, Receivable and Accrued Asset)?
36	Who all are the parties to the Lease? Please give the list of the all the contacts for the relevant leases?
37	Who Approves the lease definition?
38	Who can Edit the Lease Information?
39	Are there any milestones attached for the leases?
40	Do you have multiple locations under the same lease?
41	Do you have rights and obligations under the lease?
42	Do you have the options under the lease agreement?
43	Do you have leases for which you pay lease rentals?
44	What are the milestones of your lease rental cycle?
45	Do you maintain mandatory and/or optional reviews in your lease rental cycle for credit risk, legal compliance, and/or other approvals?
46	Do you automatically determine the general ledger accounts for  specific transactions (I. e. receivables, freight, tax, unearned revenue, unbilled receivables, etc.) during Invoice Entry?
47	How do you receive notice to create/generate an invoice to bill a customer?
48	How do you link the specific properties that you manage, with general ledger accounts at Invoice Entry?
49	Do you regularly invoice customers for the same items?
50	How are the revenue, receivable and tax accounts configured for each lease type?
51	Do you bill customers in a foreign currency?
52	How many invoice types do you have? Provide invoice samples.
53	How frequently do you invoice your customers?
54	How do you track rental revenue on invoices? How is it reported?
55	How do you number your invoices?
56	Where are your rental schedules maintained?
57	What items appear on your invoices? (Rent, Electricity and Insurance)
58	Can payment terms be assigned at the invoice level?
59	How do you calculate your tax charges?  What are the rates?
60	How do you keep your tax rate information up to date?
61	Are there any other foreign currency issues regarding invoice generation? If so please categorize the issues and describe them.
62	Are there businesses in  different  GL Set of Books has you will need to invoice ?  If so please list out these business and their differentiating aspects.
63	Do you regularly invoice customers for the same items?  If so please provide examples.
64	Do you require taxes to be established for use when preparing invoices?  If so please describe how.
65	Do you validate the tax rate against a Customer’s address when preparing invoices?    If so please describe how.
66	How are the revenue, receivable, freight and tax accounts configured for each invoice type?
67	How do you number your invoices?
68	What are all prerequisites to invoicing?
69	What are the units of measure you use when you bill customers for rentals?
70	What are the invoice grouping rules requirement for the invoices related to Lease rentals?
71	Provide an overview of Property Manager related invoice processing.
72	Are Property manager invoicing processes documented?
73	Are these Property Manger processes that should be changed, streamlined or eliminated?
74	How many rental invoices are canceled in a month?
75	How many rental invoices do you send in a month?
76	Do you ever recognize revenue from a single transaction over multiple periods?
77	When do you recognize revenue?
78	How many General Ledger accounts do you distribute to (Revenue and Receivables)?
79	When do you create or recognize outstanding receivables?
80	Do you have special revenue recognition for long-term agreements?
81	Do you index the rent? If yes, so on what basis.
82	Please provide the Index history?
83	How often do you increase the rent?
84	Are any constraints used for the rent increase?
85	What is the criteria used for calculating Annualized basis for rent indexing? Fixed Basis Calculation, Rolling Basis Calculation and Compound basis calculation.
86	How the rent increase factor is calculated? Index Only, Basis Only, Greater of and lesser of.
87	How do you allocate the rent Increase?
88	Do you calculate Variable or fixed rent?
89	How do you invoice and report on Variable Rent?
90	Do you normalize your variable rent?
91	Do you enter Deductions for calculating variable rent?
92	Do you enter constraint for calculating variable rent?
93	How are adjustments to closed periods handled?
94	How often do you adjust rental invoices?
95	How often do you cancel rental invoices?
96	What are the reasons for canceled rental invoices?
97	What are your policies and procedures about canceling rental invoices?
98	How often do you "post" information to your General ledger?
99	Do you post (or wish to post) in detail or in summary to the general ledger?
100	How often do you "post" information to your General ledger?
101	Do you post (or wish to post) in detail or in summary to the general ledger?
102	Do you allow posting invoices back to prior periods?
103	If you have multiple organizations, do they all close at the same time or separately?
104	What reports do you currently generate for Rental Revenue and Revenue tracking? Provide samples including frequency and distribution.
105	What is the requirement Company Number Generation?
106	What is the requirement for Recovery Agreement Number Generation?
107	What is the requirement for Recovery Area Class Number Generation?
108	What is the requirement for Recovery Expense Class Number Generation?
109	What is the requirement for Recovery Expense Number Generation?
110	What is the requirement for Rent Increase Number Generation?
111	What is the requirement for Lease Number Generation?
112	What is the requirement for Variable Rent Number Generation?
113	Do you want to Allow Tenancy Overlap Within Lease?
114	Do you want to allow Automatic Space Distribution?
115	Do you want to allow Calculate Annualized Basis for Index Rent?
116	What should be Default Landlord/Tenant View?
117	What should be Default Location Areas for Lease?
118	What should be Extend Index Rent Terms Upon Lease Extension?
119	What Should be the Location Code Separator?
120	Do you want to allow Multiple Tenancy Lease for same location?
121	Do you want to allow Tenancy Overlap within Lease for different customers?
122	What are the requirements for Milestones?
123	What are your different Reporting Currencies?
124	In how many organization property manager will be implemented?

Oracle Property Manager

Overview – Property Manager

You can use Oracle Property Manager to manage your properties. You use the information in Oracle Property Manager for the following purposes:

·         To identify and define a property, so that you can associate it with a lease in the Leases window.

·         To define office space, so that you can assign employees and customers to specific offices using the Space Assignment feature.

·         To maintain a comprehensive record of the physical features of a property.

·         To maintain a comprehensive record of contacts associated with the property, including company names, roles, and site information.

·         To simplify reporting.

·         To group buildings together to allow more flexibility in your property management.

Hierarchy of Properties

We can define property in Oracle Property Manager at several levels. When we define a building within a property, the building consists of floors and offices. When we define land within a property, the land consists of parcels and sections.

Properties

We can define a property in the Properties Manger, including the property name and code, and information about the location of the property, such as the region and office park name.

Buildings

We can define buildings in the Property Manager, including the name, alias, tenure, and from and to dates of the building you are defining. Most of the information in the Area and Occupancy tabbed regions is display only at this level, and must be defined at the office level, with the exception of the unit of measure and the gross measurement of the building in the Area tabbed region.

Floors

We can define floors in the Floor window, which we access by selecting the Floors button on the Building window.

Offices

We can define offices in the Office window, which we access by selecting the Offices button on the Floor window. We can define the individual office spaces by office number and suite.

Land, Parcels, and Sections

Defining land is identical to defining buildings. We define land using a three-layered structure that includes defining land in the Land window, defining parcels in the Parcel window, and defining sections in the Section window.

Space Assignment

Use the Space Assignment window to assign, modify, search, and view space assignments. We can assign locations to employees and cost centers. We can modify space assignments to update records or correct assignment information. We can query all space assignments for a particular building, floor, office, land, parcel, or section. We can also query space assignments for a particular employee, customer, or cost center.

We can search for assignments in effect on a specific date. This functionality enables us to plan space assignments in advance and search for future vacancies

Lease Administration

We can automate our lease administration processes by using the lease management features included in the Leases window. We can also manage the calculation of rent amounts and the creation of schedules for invoices. We can set up milestones that correspond to required decisions and actions our need to take at specific times. Milestones help us keep track of these decisions and actions and handle them on a timely basis.

Payments and Billings

Oracle Property Manager includes two features that we use to manage financial transactions for our property. We manage payment schedules to suppliers with the payments feature, and we manage billing schedules to customers with the billings. We set up both types of transactions in Property Manager, and then we export the transaction information to Oracle Payables or Oracle Receivables as shown in the following table:

Approval Rules for Schedules

When Oracle Property Manager first generates the schedule, its status is Draft. We approve a schedule by changing its status to Approved and saving our work. The approval takes effect when we save our work. We can change the payment/billing terms for an item in an approved schedule. This change is incorporated into all items, belonging to the term, that are not exported.

Exporting Payment Items to Oracle Payables

We can export any individual payment item that is included in an approved payment schedule.

Prerequisite:

• Create suppliers.

• Approv

Exporting Billing Items to Oracle Receivables

We can export any individual billing item that is included in an approved billing schedule.

Prepaying Rent Payments or Billings

We can record rent prepayments for both payments and billings. We enter separate payment terms for prepayments. The start date and end date are the same. We enter a target date, which is the rent payment date that the prepayment pays.

Index Rent Increases

We can use Oracle Property Manager's Rent Increase feature to automatically increase base rent either by a fixed percentage or by an amount proportional to the index change for the remainder of the lease term. Fixed increases raise rental costs, while index increases protect landlords against inflation by raising rent every year in proportion to hikes in consumer price indexes.

Variable Rent

The Variable Rent feature allows landlords to collect rent based on a variety of variable factors, such as sales volumes, weight, and usage. The most common type of variable rent is percentage rent. In this case, landlords can collect a portion of rent based on a percentage of the volume of a tenant's sales made on the leased premises.

Recoveries

The Recoveries feature supports the calculation and reconciliation of common area maintenance (CAM) expenses. CAM is important to any landlord that has multiple tenants in a single property and any tenant that shares a property with other tenants.

Oracle Property Manger Setups

1 . Region

2. Office Park

3.Property

4. Building

5.floor

6.Office

7. Lease and Document

8.Status change Draft to Final

9. concurrent request

10 Approve the Bill

11.Export the Bill to AR

12. Concurrent Request

12 Out put

13. Auto invoice import In AR