Get the domain knowledge you need to develop real-world business apps for and in the cloud. You'll see how Oracle APEX has made the life of web developers much easier and how it helps you create web-based data-centric applications easily and instantly without writing screeds of code.

In Cloud Computing Using Oracle Application Express, you will develop 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.

This new edition also incorporates the new application page creation process, which differs from the previous version. You'll cover other new areas, such as the updated UI elements and properties, and the interactive grid. Besides the development of a full application that you can deploy in your organization, the book teaches many new techniques to further enhance your APEX development skills.

You will:

Discover new development techniques for APEX developers
Develop cloud-based ERP applications
Build a cloud-based application on Oracle APEX
Integrate the free JasperReports server and report designing tool with Oracle APEX

Auteur

Riaz Ahmed is an IT professional with more than 25 years' experience. He started his career in early the early 90s as a programmer, and has been employed in a wide variety of information technology positions, including analyst programmer, system analyst, project manager, data architect, database designer, and senior database administrator. His core areas of interest include web-based development technologies, business intelligence, and databases. Riaz possesses extensive experience in database design and development. Besides all versions of Oracle, he has worked intensively in almost all the major RDBMSs on the market today. During his career he has designed and implemented numerous databases for a wide range of applications, including ERP.

Contenu
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 com...