Cloud Computing Using Oracle Application Express
Home > Computing and Information Technology > Computer networking and communications > Cloud computing > Cloud Computing Using Oracle Application Express
Cloud Computing Using Oracle Application Express

Cloud Computing Using Oracle Application Express


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Develop cloud-based applications rapidly using the Oracle Application Express (APEX) platform. You will learn to develop a comprehensive functional business application which can be deployed in your organization. Cloud Computing Using Oracle Application Express will teach you how to develop a complete general ledger accounting system which will be accessible through a variety of devices, including desktops, laptops, and the latest smartphones. What You Will Learn: Use new Oracle APEX 5.0 techniques Develop a complete general ledger accounting system named The Cloud Accountant Create cloud-based business apps accessible anywhere and anytime Enhance your APEX development skills Who This Book Is For: Web developers who possess some working knowledge of Oracle Application Express, and developers who have been using Oracle Forms and now wish to use their existing SQL and PL/SQL expertise.

Table of Contents:
Chapter 1: Introduction to Cloud Computing and Application Project 1The 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 9First 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 13The 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 15Each 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 25You 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 29You 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 35Assigning 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 43In 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 47The 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 53Different 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 57Cost 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 63Financial 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 71The 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 75After 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 85It’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 89This 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 95It 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 103In 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 109The 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 117You 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 121This 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 127After 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 131In 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 135The 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 141By 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 147After 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 153In 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 159The 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 169The executive dashboard comprises several charts. This graphical representation reveals the financial status of the organization to interested parties. Chapter 30: Application Feedback 175The application feedback is a feature which is added to allow interaction between the application users and its administrator. Chapter 31: Mobile Version 179In 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 189After 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. Chapter 33: Appendix 199The file available at http://www.creating-website.com/Book_Code.rar 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 :
Author Bio for the FM: Riaz Ahmed is an IT professional with more than 23 years experience. He started his career in early 90's 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. Currently he is working as head of IT for a group of companies. 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 major RDBMS on the market today. During his career he designed and implemented numerous databases for a wide range of applications, including ERP.


Best Sellers


Product Details
  • ISBN-13: 9781484225011
  • Publisher: Apress
  • Publisher Imprint: Apress
  • Height: 235 mm
  • No of Pages: 403
  • Weight: 6496 gr
  • ISBN-10: 1484225015
  • Publisher Date: 14 Dec 2016
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Width: 155 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Cloud Computing Using Oracle Application Express
Apress -
Cloud Computing Using Oracle Application Express
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Cloud Computing Using Oracle Application Express

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!