Skip navigation

Do you collect Security Deposits for your leases, keys, utility or any variety of options?  Did you know that JD Edwards EnterpriseOne Real Estate Management can assist you with maintaining and recording this information as well as refunding the full or partial deposit when the time comes to return the monies to the tenant?


The Security Deposit requirements can be entered in Security Deposit Maintenance (P1565).  It is also possible to create an invoice if necessary for the customer to submit this deposit.  This invoice will not be created in Accounts Receivable. 


The actual security deposit is entered in RE Cash Receipts (P15103) with a Bill code associated with Security Deposits. 


The Security Deposits Required vs. Received report can be run to verify all required deposits have been received or which are still pending.


When ready to refund the deposit, there are a number of options.  It can be refunded in full or partially depending on the processing options of the Security Deposit Refund Application (R15654).  This means there is an option to refund only a portion of the deposit if there are open invoices that a portion of this balance needs to be applied to.


It is necessary to use RE Cash Receipts to apply this balance to the open invoices.


How to Manage Security Deposits in Real Estate Management (Doc ID 1469834.1) provides more detailed instructions on how to use this functionality.

JD Edwards EnterpriseOne One View Reporting is a real time operational reporting solution designed specifically for end users. An intuitive interface empowers users to access and personalize transactional data into lists, charts, graphs, and tables. With One View Reporting, users can select the data fields and perform specific data selection from within JD Edwards EnterpriseOne applications and leverage the layout capabilities within Oracle BI Publisher to define the report output formatting. It was first introduced with JD Edwards EnterpriseOne Applications release 9.1 and later it was also offered for Applications release 9.0.


One View Reporting enables end users to create and run One View reports based on Business Views using search criteria in applications (standard or custom Find Browse Forms) or even in Data Browser. These reports are typically specific to the user or role and are those that the user will run on a daily, weekly, or other periodic basis as part of their normal activities. With this type of report users are allowed a high degree of personalization regarding data selection, sequencing, data columns included, and data visualization (charts, tables, graphs). These end-user reports improve user productivity by providing users with better visibility into operational data as part of their standard day-to-day business process. Common use cases are customer reports, supplier reports, sales reports, and employee reports.

Together with the One View reporting feature a number of dedicated standard One View Applications and Reports were added for various JD Edwards EnterpriseOne modules.


In Financial Management new One View Applications were added for General Accounting, Accounts Payable and Accounts Receivable. Standard One View Reports for various use cases are delivered with each One View Application.


General Accounting

  • One View G/L Inquiry (P09219). One View G/L Inquiry can be used to analyze General Ledger transactions. It is based on the One View G/L Inquiry (F0911-F0901-F0006) Business View (V09219), which includes columns from the Account Ledger table (F0911), Account Master table (F0901), and Business Unit Master table (F0006).
  • One View Account Balance Inquiry application (P09217). One View Account Balance Inquiry can be used to report on account balances. It is based on the One View Account Balance Inquiry business view (V09217), which includes columns from the Account Balance table (F0902), F0901, and F0006.


Accounts Receivable

  • One View Customer Ledger Inquiry application (P03B2022). One View Customer Ledger Inquiry uses the One View Customer Ledger Inquiry Business View (V03B11I) (which includes columns from the Customer Ledger table (F03B11) and Customer Line of Business Master table (F03012)) to analyze the Customer Ledger.
  • One View Customer Receipt/Draft Inquiry application (P03B720). One View Receipt/Draft Inquiry should be used to inquire on Receipt/Draft transactions. It is based on the One View Receipt Draft Inquiry Business View (V03B720), which includes columns from the Receipt Detail table (F03B14), Receipt Header table (F03B13), and Customer Master table (F03012).
  • One View Supplier Ledger Inquiry application (P042022). One View Supplier Ledger Inquiry can be used to analyze supplier ledger transactions. It is based on the One View Supplier Ledger Inquiry Business View (V042022), which includes columns from the Accounts Payable Ledger table (F0411), Supplier Master table (F0401), and the Address Book table (F0101).
  • One View Supplier Payment Inquiry application (P04720). One View Supplier Payment Inquiry can be used to inquire on supplier payment transactions. It is based on the One View Supplier Payment Inquiry Business View (V04720), which includes columns from the Payment Detail table (F0414), Payment Header table (F0413), F0401, and F0101.  


JD Edwards EnterpriseOne Applications One View Reporting User Guide


With the One View Reporting for Financial Management Chapter


For an Administrative perspective check the JD Edwards EnterpriseOne Tools One View Administration Guide

Does your company use an Oracle product to reduce its environmental footprint while improving its operational efficiency? Reducing energy usage? Reducing gas usage? Going paperless? For example, your organization may use Oracle Cloud Solutions to help drive down power consumption, Oracle Exadata Database Machine to decrease power and cooling needs while increasing database performance, or one of many other Oracle products. Your company may be a likely nominee for Oracle’s Sustainability Innovation Award, part of the Oracle Excellence awards. These awards will be presented during Oracle OpenWorld 2016 by Jeff Henley, Oracle Executive Vice Chairman of the Board, in a special conference session.

Get details and submit your nominations by June 7, 2016.

JD Edwards released a new tutorial that demonstrates how you can add a Watchlist Pane in Page Composer. Watchlists enable you to easily set alerts for items that you want to proactively monitor. Page Composer provides a simple, intuitive interface that enables business analysts and users to create their own EnterpriseOne Pages.

Watch the new tutorial here or navigate to > New Releases and Initiatives > Tools 9.2 > User Defined Objects.

JD Edwards recently published an Oracle by Example (OBE) tutorial for Active Content EnterpriseOne Pages on LearnJDE. This OBE tutorial provides hands-on, step-by-step instructions on how to build an Active Content Page. Active Content EnterpriseOne Pages are Classic EnterpriseOne Pages that include enhanced functionality provided by the Oracle JET (JavaScript Extension Toolkit) library. Learn more about EnterpriseOne pages here.

New recordings discussing practical scenarios for JD Edwards and Oracle Software as a Service (SaaS) Coexistence are now available on LearnJDE. To enable you to recognize the best hybrid opportunities, this new series of practical coexistence scenarios provides guidance on how to achieve high-value hybrid solutions that solve your business problems.

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see for instructions.