Friday, 18 December 2015

Develop Business Applications in Oracle APEX

I'm excited to announce the release of my book "Cloud Computing Using Oracle Application Express".  Get a FREE PDF with the print edition. The book demonstrates how to rapidly develop internet facing business applications accessible anywhere and anytime. Please go through the contents of this book:

Chapter 1 - Introduction to Cloud Computing and Application Project 1
The book focuses on developing business applications for the cloud and provides step by step guidance in developing a financial accounting system to give you a taste of cloud computing with respect to building business applications in Oracle APEX. This chapter provides an overview of cloud computing and the application project.

Chapter 2 - Application Navigation 9
First of all you will be guided through the creation of a navigation structure for the application including its menus, submenus, and a navigation bar. Using this structure users can access different segments of the application according to their respective privileges, which is granted to them by the application administrator.

Chapter 3 - Companies 13
The application is capable of maintaining accounts of multiple companies simultaneously. This setup allows you to create as many companies as you need. Each company is provided with a unique code that distinguishes its transactions from that of the others.

Chapter 4 - Fiscal Year 15
Each company created in the application must have a fiscal year to keep records of its financial proceedings. You can create different fiscal years for different companies. However, this book follows a fiscal year which starts from 1st July and ends on 30th June.

Chapter 5 - Voucher Types 25
You can create multiple voucher types to record financial transactions. This approach is handy to distinguish between transactions of various natures. For example, you can create two different voucher types to record payments made through cash and bank.

Chapter 6 - Application Segments 29
You will create a robust security module for this application to control its access. The application consists of several segments that need protection from unauthorized access. In this chapter you will spot all those segments which will be utilized in the next chapter to handle the application security.

Chapter 7 - User Groups 35
Assigning application access privileges to individual users is not an easy task, especially when they are in large numbers and belong to different positions. To make things simple, you will create a few groups, each of which will be granted different application privileges. Then you will create individual user accounts and assign them a group. Using this approach the users inherit their privileges from the group they belong to.

Chapter 8 - Create Users 43
In this chapter you will create the application users. Each user is associated with a group and is assigned to a company. After making a successful log-in attempt, the application provides the users with the privileges of the group they belong to allowing them to maintain the accounts of the company assigned to them.

Chapter 9 - Reset Password 47
The application stores encrypted password for each user. The interface created in this  chapter will be used to set initial passwords for all application users. The same interface is provided to the users (with fewer privileges) so that they can change their own passwords when they want to.

Chapter 10 - Switch Company, Year and Month 53
Different users in the application are granted different privileges. Some users are allowed to maintain accounts of multiple companies, while some are restricted to handle just one company. The former group of users can switch to other companies, years, and fiscal periods from this interface.

Chapter 11 - Cost Centers 57
Cost conscious organizations always keep both eyes on their expenses. With the help of a two level cost center setup you allow them to keep track of all costs incurred on different departments in different locations.

Chapter 12 - Chart of Accounts 63
Financial accounting applications follow a pre-defined accounts list which is called the chart of account. It is created to maintain accounts in an organized manner. In this chapter you will create an interface where users will create a chart of account comprising four levels for each company.

Chapter 13 - Copy Chart of Accounts 71
The Copy Chart of Accounts utility is provided to avoid the labor involved in creating a chart of account for each company individually. It will allow the application administrator to copy an existing (master) chart of accounts to all companies created in the application.

Chapter 14 - Enter Vouchers 75
After completing the setup phase, you create an interface to record business transactions. This interface is called a Voucher, where you select a type, provide a number, select a date, enter a description, pick accounts and cost centers from their respective setups, and enter debit and credit figures. It is a real time process. Once you save a voucher, all financial reports in the application are updated immediately.

Chapter 15 - Search Transactions 85
It’s a routine work for an accountant to search for a transaction recorded in the past. In this chapter you will create a utility which searches transactions for a user-specified criterion.

Chapter 16 - Vouchers Verification 89
This interface is created for authorized users to verify vouchers created by data entry clerks. Once a voucher is marked as verified, no one can manipulate it unless the authorized person reverses its state to unverified.

Chapter 17 - Vouchers Report 95
It is a usual accounting practice to print vouchers after creation. This chapter will teach you how to create parameterized group reports with custom layouts.

Chapter 18 - Ledger Report 103
In this application you will create some generic financial reports. The ledger report is one of them which provide details of an account in a tabular form. To get this report, the user must provide a couple of parameters comprising account range and duration.

Chapter 19 - Trial Balance Report 109
The trial balance report presents opening, activity, and closing balances of accounts in a tabular form. You can generate this report for a specific cost center and for a selected level.

Chapter 20 - Opening Bank Transactions 117
You will next enable the accountant to reconcile his ledger transactions with his bank. This is the first step in the bank reconciliation process where the accountant records all bank transactions which remained unreconciled prior to starting this application.

Chapter 21 - Bank Reconciliation 121
This is the interface which you provide to the accountant for bank reconciliation. Besides the transactions entered through vouchers, this interface contains a region to display opening unreconciled transactions, recorded in the previous chapter.

Chapter 22 - Bank Reconciliation Report 127
After reconciling ledger transactions with the bank statement, the accountant generates this report which shows the remaining unreconciled transactions and balances as per ledger and bank statement.

Chapter 23 - Month Closure 131
In the application the fiscal year of a company comprises twelve periods. All transactions are recorded in their respective periods. After recording all transactions in a period it can optionally be marked as closed to prevent data manipulation.

Chapter 24 - Year End Processes 135
The yearend process comprises two options: Temporary and Permanent. The former process generates a new fiscal year and transfers closing balances of accounts to the new fiscal year. The permanent closing process marks a year as permanently closed. After executing the TYE process you can manipulate data in all open months of that year, whereas the PYE process doesn’t allow any kind of data manipulation.

Chapter 25 - Budget Allocation 141
By allocating budgets for accounts an accountant can keep things under control. You will allow the accountant to allocate budget in three ways: manual, last year actual, and last year budget.

Chapter 26 - Budget Report 147
After allocating a budget to an account its value is compared with the actual amount spent and the variance between these figures is reported in the budget report.

Chapter 27 - Setup Accounts for Financial Statements 153
In this chapter you will create an interface where users will define accounts (from the chart of accounts) to produce the two most common financial statements: Profit & Loss and Balance Sheet.

Chapter 28 - Financial Statements 159
The accounts defined in the previous chapter are used here to generate the two financial statements. These two statements reveal the financial health of an organization.

Chapter 29 - Executive Dashboard 169
The executive dashboard comprises several charts. This graphical representation reveals the financial status of the organization to interested parties.

Chapter 30 - Application Feedback 175
The application feedback is a feature which is added to allow interaction between the application users and its administrator.

Chapter 31 - Mobile Version 179
In this chapter you will create some high-end graphical financial reports for the busy business community to keep them in touch with their businesses wherever they go.

Chapter 32 - Application Security 189
After implementing a custom authentication scheme in chapters 7, 8, and 9 your next task is to implement the authorization policy. In this chapter you will create some authorization schemes to protect the application menus, pages, buttons, and processes.

Appendix 199
The file available at contains all source code used in this book. To facilitate you further, the appendix section lists the code as a handy reference. Please note that the file name (Book_Code.rar) is case sensitive.

About the Author

Thursday, 12 November 2015

Cloud Computing Using Oracle Application Express

Rapidly Develop Internet Facing Business Applications Accessible Anywhere and Anytime

Buy from Amazon
If someone had asked me to write this book two decades ago, I would have simply refused the suggestion - not because I couldn't do so, but because of the mountain of code necessary to create the application along with its menus, forms, reports, and so on. Thanks to the appearance of GUIs and RAD. The load of overburdened developers has not only reduced, but has also enabled application development to be easily demonstrated in book form.

Oracle Application Express is a unique development platform that helps you develop cloud-based applications rapidly. In the previous three editions of my book (that focused on beginners), I practically demonstrated almost every significant feature of Oracle APEX; this book is an attempt to take my readers to the next level with some more useful stuff.

You might be one of those readers who is already familiar with Oracle APEX having some experience in developing simple applications but who lacks the required knowledge that is needed to develop a comprehensive system. In this book you will bridge this gap by developing a complete general ledger accounting system named The Cloud Accountant which will be accessible through a variety of devices including desktops, laptops, and the latest smartphones. Besides the development of a functional application (which you can deploy in your organization or even in other organizations to earn some handsome bucks), the book demonstrates many new techniques to further enhance your APEX development skills.
This book is also ideal for those who have been developing applications in Oracle Forms, and now wish to get their feet wet in the world of web development using their existing expertise. 

If you know what Oracle Application Express is, and are also comfortable with SQL and PL/SQL, then grab this book to learn something that is not available anywhere else. If you are a novice, then you are encouraged to read my book Oracle Application Express 5 For Beginners (ISBN-13: 978-1-512-00330-7).

Special Offer: Get a FREE PDF of this book with the print edition.

Buy the Kindle Edition for just $9.99!

Saturday, 7 March 2015


This page is dedicated to identify errors in the book: Cloud Computing Using Oracle Application Express

Book Code URL 

The correct URL to download the book code is:

If you get the message "Server Not Found", then manually type the "-" between "creating" and "website".


Page 51 (Section 9.4): The Point attribute should be set to Processing instead of After Submit. If you set this attribute to After Submit, then the password is reset in the database table even if the two passwords do not match. This is because the After Submit process event fires before the Match Passwords validation. Once you set the Point attribute to Processing, the Update Password process fires after passing the validation.