SUMMARY

SEARCH

Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.

BOOK CLOUD COMPUTING USING ORACLE APPLICATION EXPRESS

SUMMARY

554

Chapter 1: Introduction to Cloud Computing and the Application Project
1.1 An Introduction to Cloud Computing
1.2 Public vs. Private Cloud
1.3 What Is Accounting?
1.4 Accounting System
1.5 General Ledger
1.6 The Cloud Accountant General Ledger Project
1.7 Development Environment
1.8 Application Segments
Chapter 2: Application Navigation
2.1 Create the Main Application Menu
2.2 Modify/Add Navigation Bar Entries
Chapter 3: Companies
3.1 Create Application Tables
3.2 Create Pages for Company Setup
Chapter 4: Fiscal Year
4.1 Create List of Values
4.2 Create Page and Parameters Region
4.3 Create a Fiscal Year Grid
4.4 Add Items to Hold Months/Dates
4.5 Create Buttons to Generate,Save,and Remove a Fiscal Year
4.6 Generate Fiscal Year Process
4.7 Save Fiscal Year Process
4.8 Delete Fiscal Year Process
4.9 Fetch Fiscal Year Dynamic Action
4.10 Create Validation: Check Transaction
4.11 Create Branch
4.12 Dynamic Actions to Hide Buttons
4.13 Test Your Work
Chapter 5: Voucher Types
5.1 Create List of Values
5.2 Create Pages for Voucher Types Setup
5.2.1 Convert Text Item to Radio Group
5.3 Create Validation: Check Transaction
5.4 Test Your Work
Chapter 6: Application Segments
6.1 Create LOVs
6.2 Create Segments Setup Pages
6.3 Modify Segments Form
6.4 Add Tree View Region
6.5 Create Buttons
6.6 Create Validations
6.7 Create Branch
6.8 Test Your Work
Chapter 7: User Groups
7.1 Page and Parameters Region
7.2 Buttons
7.3 New Group Process
7.4 Delete Group Button
7.5 Delete Group Process
7.6 Group Privileges Region
7.7 Tree Region
7.8 Add Classic Report Region
7.9 Dynamic Action to Refresh Region
7.10 Add Button and a Process to Allow/Revoke Segment Access
Right
7.11 Test Your Work
Chapter 8: Create Users
8.1 Create Pages
8.2 Create/Modify Items
8.3 Create a Process to Set Company,Year,and Month
8.4 Test Your Work
Chapter 9: Reset Password
9.1 Add Custom Functions
9.2 Create Page
9.3 Check User ID and Match Password Validations
9.4 Update Password Process
9.5 Change Authentication Scheme
Chapter 10: Switch Company,Year,and Month
10.1 Create Page
10.2 Add Button
10.3 Add Validations
10.4 Update User Profile Process
10.5 Display Company,Year,and Month
Chapter 11: Cost Centers
11.1 Create Pages
11.2 Delete Processes
11.3 Modify Delete Button
11.4 Add Button
11.5 Modify Page Items
11.6 Add Dynamic Action: Evaluate Level
11.7 Validation: Check Level
11.8 Validation: Check Parent Level
11.9 Validation: Check Child Level
11.10 Validation: Check in Transaction
11.11 Validation: Disallow Code Modification
11.12 Process: Save Record
11.13 Process: Delete Record
11.14 Add Button: Refresh
11.15 Test Your Work
Chapter 12: Chart of Accounts
12.1 Create Three Lists of Values
12.2 Copy Pages
12.3 Modify the Report Page (Page 15)
12.4 Modify the Form Page (Page 16)
12.5 Modify/Create Dynamic Actions
12.6 Modify Validations
12.7 Create Validation: Check Account Type
12.8 Modify Processes
12.9 Create a Highlight Rule
12.10 Test Your Work
Chapter 13: Copy Chart of Accounts
13.1 Create Page
13.2 Add Button
13.3 Add Validations
13.4 Copy COA Process
13.5 Test Your Work
Chapter 14: Enter Vouchers
14.1 Create List of Values
14.2 Create Pages
14.3 Modify the Master Page (Page 42)
14.4 Add Items (Page 42)
14.5 Modify Button (Page 42)
14.6 Modify the Detail Page (Page 43)
14.7 Add/Modify Items
14.8 Modify Validations on Page 43
14.9 Add Validations to Page 43
14.10 Modify Process
14.11 Create Process
14.12 Control Buttons
14.13 Test Your Work
Chapter 15: Search Transactions
15.1 Create Page and Parameters Region
15.2 Create an Interactive Report Region
15.3 Add a Dynamic Action
15.4 Test Your Work
Chapter 16: Vouchers Verification
16.1 Create Page and Parameters Region
16.2 Create Interactive Report Region
16.3 Create Verification Page
16.4 Modify,Delete,and Create Page Buttons
16.5 Modify Page-Rendering Process
16.6 Delete Validations
16.7 Delete Processes
16.8 Add Processes
16.9 Handle Branches
16.10 Test Your Work
Chapter 17: Vouchers Report
17.1 Create a List of Values
17.2 Create the Parameters Form
17.3 Create Report Query
17.4 Download and Install BI Publisher Desktop
17.5 Create Report Template in Microsoft Word
17.6 Template Formatting
17.7 Create the Report Layout
17.8 Attach the Report Layout to Report Query
17.9 Send the Print Request
17.10 Create Validation
17.11 Test Your Work
Chapter 18: Ledger Report
18.1 Create Page and Parameters Form
18.2 Create an Interactive Report Region
18.3 Formatting Ledger Report
18.4 Get Ledger Report in PDF
18.5 Drill Down to Source Voucher
18.5.1 Create Link in Interactive Report
18.5.2 Create Voucher Page
18.6 Test Your Work
Chapter 19: Trial Balance Report
19.1 Trial Balance Report Table
19.2 Create a List of Values
19.3 Create Page and Parameters Form
19.4 Create the Interactive Report Region
19.5 Create a Process to Generate Trial Balance
19.6 Formatting the Trial Balance Report
19.7 Print the Selected Level
19.7.1 Create Process
19.8 Eliminate Zero Balances
19.8.1 Create a Process
19.9 Create a Validation
19.10 Get the Trial Balance Report in PDF
19.10.1 Template Formatting
19.11 Drill Down to the Ledger Report
19.12 Test Your Work
Chapter 20: Opening Bank Transactions
20.1 Create Page
20.2 Modify Region Source Query
20.3 Handling Default Validations
20.4 Add Validation
20.5 Test Your Work
Chapter 21: Bank Reconciliation
21.1 Create Page and Parameters Form
21.2 Display Outstanding Opening Transactions
21.3 Modify Reconcile Opening Form
21.4 Current Transactions Region
21.4.1 Create a Button and a Process
21.5 Test Your Work
Chapter 22: Bank Reconciliation Report
22.1 The Bank Reconciliation Report Table
22.2 Create the Parameters Form
22.3 Create the Interactive Report
22.4 Create the Reconciliation Report Generation Process
22.5 Format the Reconciliation Report
22.6 Generate the PDF Report
22.7 Test Your Work
Chapter 23: Month Closure
23.1 Create Page and Page Items
23.2 Show Unverified Vouchers
23.3 Add Validation
23.4 Close Month Process
23.5 Hide Buttons
Chapter 24: Year-End Processes
24.1 Enter Opening Balances
24.2 Temporary Year-End (TYE)
24.3 Create the Page and Page Items
24.4 Create a Validation
24.5 Generate the Fiscal Year Process
24.6 A Process to Generate a Closing Entry
24.7 Test Your Work
24.8 Permanent Year End (PYE)
24.9 Create the Page and Page Items
24.10 Create the Validations
24.11 A Process to Close the Year Permanently
24.12 Test Your Work
Chapter 25: Budget Allocation
25.1 Budget Allocation Table
25.2 Create the Page and Parameters Form
25.3 Create a Tabular Form
25.4 Budget Processes
25.5 Test Your Work
Chapter 26: Budget Report
26.1 Budget Report Table
26.2 Create Page and Parameters Form
26.3 Create Computations
26.4 Create Interactive Report
26.5 Budget Report Generation Process
26.6 Generate PDF Report
26.7 Test Your Work
Chapter 27: Set Up Accounts for Financial Statements
27.1 Accounts Table for the Financial Statements
27.2 Create a List of Values
27.3 Create Page and Page Items
27.4 Create a Tabular Form
27.5 Create Validations
27.6 Create Process
27.7 Test Your Work
Chapter 28: Financial Statements
28.1 Financial Statements Table
28.2 Create Page and Page Items
28.3 Create Interactive Report and Buttons
28.4 Create Computations
28.5 Create On-Demand Processes
28.6 Create Branches
28.7 Create Page for Financial Statements Notes
28.8 Create Column Link
28.9 Generate PDF Report
28.10 Enter Vouchers
28.11 Test Your Work
Chapter 29: Executive Dashboard
29.1 Dashboard Table
29.2 Copy Components to the Home Page
29.3 Create Regions
29.4 Create Chart Subregion
29.5 Create a Hidden Item
29.6 Copy Chart Regions
29.7 Test Your Work
Chapter 30: Application Feedback
30.1 Application Feedback Table
30.2 Create Feedback Input Form
30.3 Create Feedback Report Page
30.4 Test Your Work
Chapter 31: Mobile Version
31.1 Create an Interface for a Mobile Application
31.2 Region and Page Items
31.3 Copy Computations and Branches
31.4 Add Entries to Mobile Navigation Menu
31.5 Create Profit and Loss Statement Report
31.6 Create Other Mobile Report Pages
31.7 Test Your Work
Chapter 32: Application Security
32.1 Authorization Schemes for the Main Menu
32.2 Test Menu Authorization
32.3 Authorization Schemes for Application Pages
32.4 Test Page Authorization
32.5 Authorization Schemes for Buttons
32.6 Test Buttons Authorization
32.8 Conclusion
Chapter 1: Introduction to Cloud Computing and the Application Project
1.1 An Introduction to Cloud Computing
1.2 Public vs. Private Cloud
1.3 What Is Accounting?
1.4 Accounting System
1.5 General Ledger
1.6 The Cloud Accountant General Ledger Project
1.7 Development Environment
1.8 Application Segments
Chapter 2: Application Navigation
2.1 Create the Main Application Menu
2.2 Modify/Add Navigation Bar Entries
Chapter 3: Companies
3.1 Create Application Tables
3.2 Create Pages for Company Setup
Chapter 4: Fiscal Year
4.1 Create List of Values
4.2 Create Page and Parameters Region
4.3 Create a Fiscal Year Grid
4.4 Add Items to Hold Months/Dates
4.5 Create Buttons to Generate,Save,and Remove a Fiscal Year
4.6 Generate Fiscal Year Process
4.7 Save Fiscal Year Process
4.8 Delete Fiscal Year Process
4.9 Fetch Fiscal Year Dynamic Action
4.10 Create Validation: Check Transaction
4.11 Create Branch
4.12 Dynamic Actions to Hide Buttons
4.13 Test Your Work
Chapter 5: Voucher Types
5.1 Create List of Values
5.2 Create Pages for Voucher Types Setup
5.2.1 Convert Text Item to Radio Group
5.3 Create Validation: Check Transaction
5.4 Test Your Work
Chapter 6: Application Segments
6.1 Create LOVs
6.2 Create Segments Setup Pages
6.3 Modify Segments Form
6.4 Add Tree View Region
6.5 Create Buttons
6.6 Create Validations
6.7 Create Branch
6.8 Test Your Work
Chapter 7: User Groups
7.1 Page and Parameters Region
7.2 Buttons
7.3 New Group Process
7.4 Delete Group Button
7.5 Delete Group Process
7.6 Group Privileges Region
7.7 Tree Region
7.8 Add Classic Report Region
7.9 Dynamic Action to Refresh Region
7.10 Add Button and a Process to Allow/Revoke Segment Access
Right
7.11 Test Your Work
Chapter 8: Create Users
8.1 Create Pages
8.2 Create/Modify Items
8.3 Create a Process to Set Company,Year,and Month
8.4 Test Your Work
Chapter 9: Reset Password
9.1 Add Custom Functions
9.2 Create Page
9.3 Check User ID and Match Password Validations
9.4 Update Password Process
9.5 Change Authentication Scheme
Chapter 10: Switch Company,Year,and Month
10.1 Create Page
10.2 Add Button
10.3 Add Validations
10.4 Update User Profile Process
10.5 Display Company,Year,and Month
Chapter 11: Cost Centers
11.1 Create Pages
11.2 Delete Processes
11.3 Modify Delete Button
11.4 Add Button
11.5 Modify Page Items
11.6 Add Dynamic Action: Evaluate Level
11.7 Validation: Check Level
11.8 Validation: Check Parent Level
11.9 Validation: Check Child Level
11.10 Validation: Check in Transaction
11.11 Validation: Disallow Code Modification
11.12 Process: Save Record
11.13 Process: Delete Record
11.14 Add Button: Refresh
11.15 Test Your Work
Chapter 12: Chart of Accounts
12.1 Create Three Lists of Values
12.2 Copy Pages
12.3 Modify the Report Page (Page 15)
12.4 Modify the Form Page (Page 16)
12.5 Modify/Create Dynamic Actions
12.6 Modify Validations
12.7 Create Validation: Check Account Type
12.8 Modify Processes
12.9 Create a Highlight Rule
12.10 Test Your Work
Chapter 13: Copy Chart of Accounts
13.1 Create Page
13.2 Add Button
13.3 Add Validations
13.4 Copy COA Process
13.5 Test Your Work
Chapter 14: Enter Vouchers
14.1 Create List of Values
14.2 Create Pages
14.3 Modify the Master Page (Page 42)
14.4 Add Items (Page 42)
14.5 Modify Button (Page 42)
14.6 Modify the Detail Page (Page 43)
14.7 Add/Modify Items
14.8 Modify Validations on Page 43
14.9 Add Validations to Page 43
14.10 Modify Process
14.11 Create Process
14.12 Control Buttons
14.13 Test Your Work
Chapter 15: Search Transactions
15.1 Create Page and Parameters Region
15.2 Create an Interactive Report Region
15.3 Add a Dynamic Action
15.4 Test Your Work
Chapter 16: Vouchers Verification
16.1 Create Page and Parameters Region
16.2 Create Interactive Report Region
16.3 Create Verification Page
16.4 Modify,Delete,and Create Page Buttons
16.5 Modify Page-Rendering Process
16.6 Delete Validations
16.7 Delete Processes
16.8 Add Processes
16.9 Handle Branches
16.10 Test Your Work
Chapter 17: Vouchers Report
17.1 Create a List of Values
17.2 Create the Parameters Form
17.3 Create Report Query
17.4 Download and Install BI Publisher Desktop
17.5 Create Report Template in Microsoft Word
17.6 Template Formatting
17.7 Create the Report Layout
17.8 Attach the Report Layout to Report Query
17.9 Send the Print Request
17.10 Create Validation
17.11 Test Your Work
Chapter 18: Ledger Report
18.1 Create Page and Parameters Form
18.2 Create an Interactive Report Region
18.3 Formatting Ledger Report
18.4 Get Ledger Report in PDF
18.5 Drill Down to Source Voucher
18.5.1 Create Link in Interactive Report
18.5.2 Create Voucher Page
18.6 Test Your Work
Chapter 19: Trial Balance Report
19.1 Trial Balance Report Table
19.2 Create a List of Values
19.3 Create Page and Parameters Form
19.4 Create the Interactive Report Region
19.5 Create a Process to Generate Trial Balance
19.6 Formatting the Trial Balance Report
19.7 Print the Selected Level
19.7.1 Create Process
19.8 Eliminate Zero Balances
19.8.1 Create a Process
19.9 Create a Validation
19.10 Get the Trial Balance Report in PDF
19.10.1 Template Formatting
19.11 Drill Down to the Ledger Report
19.12 Test Your Work
Chapter 20: Opening Bank Transactions
20.1 Create Page
20.2 Modify Region Source Query
20.3 Handling Default Validations
20.4 Add Validation
20.5 Test Your Work
Chapter 21: Bank Reconciliation
21.1 Create Page and Parameters Form
21.2 Display Outstanding Opening Transactions
21.3 Modify Reconcile Opening Form
21.4 Current Transactions Region
21.4.1 Create a Button and a Process
21.5 Test Your Work
Chapter 22: Bank Reconciliation Report
22.1 The Bank Reconciliation Report Table
22.2 Create the Parameters Form
22.3 Create the Interactive Report
22.4 Create the Reconciliation Report Generation Process
22.5 Format the Reconciliation Report
22.6 Generate the PDF Report
22.7 Test Your Work
Chapter 23: Month Closure
23.1 Create Page and Page Items
23.2 Show Unverified Vouchers
23.3 Add Validation
23.4 Close Month Process
23.5 Hide Buttons
Chapter 24: Year-End Processes
24.1 Enter Opening Balances
24.2 Temporary Year-End (TYE)
24.3 Create the Page and Page Items
24.4 Create a Validation
24.5 Generate the Fiscal Year Process
24.6 A Process to Generate a Closing Entry
24.7 Test Your Work
24.8 Permanent Year End (PYE)
24.9 Create the Page and Page Items
24.10 Create the Validations
24.11 A Process to Close the Year Permanently
24.12 Test Your Work
Chapter 25: Budget Allocation
25.1 Budget Allocation Table
25.2 Create the Page and Parameters Form
25.3 Create a Tabular Form
25.4 Budget Processes
25.5 Test Your Work
Chapter 26: Budget Report
26.1 Budget Report Table
26.2 Create Page and Parameters Form
26.3 Create Computations
26.4 Create Interactive Report
26.5 Budget Report Generation Process
26.6 Generate PDF Report
26.7 Test Your Work
Chapter 27: Set Up Accounts for Financial Statements
27.1 Accounts Table for the Financial Statements
27.2 Create a List of Values
27.3 Create Page and Page Items
27.4 Create a Tabular Form
27.5 Create Validations
27.6 Create Process
27.7 Test Your Work
Chapter 28: Financial Statements
28.1 Financial Statements Table
28.2 Create Page and Page Items
28.3 Create Interactive Report and Buttons
28.4 Create Computations
28.5 Create On-Demand Processes
28.6 Create Branches
28.7 Create Page for Financial Statements Notes
28.8 Create Column Link
28.9 Generate PDF Report
28.10 Enter Vouchers
28.11 Test Your Work
Chapter 29: Executive Dashboard
29.1 Dashboard Table
29.2 Copy Components to the Home Page
29.3 Create Regions
29.4 Create Chart Subregion
29.5 Create a Hidden Item
29.6 Copy Chart Regions
29.7 Test Your Work
Chapter 30: Application Feedback
30.1 Application Feedback Table
30.2 Create Feedback Input Form
30.3 Create Feedback Report Page
30.4 Test Your Work
Chapter 31: Mobile Version
31.1 Create an Interface for a Mobile Application
31.2 Region and Page Items
31.3 Copy Computations and Branches
31.4 Add Entries to Mobile Navigation Menu
31.5 Create Profit and Loss Statement Report
31.6 Create Other Mobile Report Pages
31.7 Test Your Work
Chapter 32: Application Security
32.1 Authorization Schemes for the Main Menu
32.2 Test Menu Authorization
32.3 Authorization Schemes for Application Pages
32.4 Test Page Authorization
32.5 Authorization Schemes for Buttons
32.6 Test Buttons Authorization
32.8 Conclusion