4

7

 

 Oracle Financial

[05 Modules]

 Overview 

The data is the most critical part of any organization. Oracle is the most popular database management system. It was developed in 1977 and since then it has made progress by leaps and bounds. All the mission critical database systems using Oracle. 

Learning Objectives 

The objective of this course is to:

  Provide Information and importance of Databases.

  Identify various components of the Oracle architecture

  How Oracle works

  Roles of Database Administrator

  and Personally I want to share my experience of working with Pakistanis to avoid re-inventing the wheel as it falls under my vision           

Course Contents

System Administrator

 

  Define Users

  Define Responsibilities

  Assign Responsibility to Users

  Define Menu

  Assign Menu to Responsibilities

  Define Request Group

  Assign Request Group to Responsibility

  Request Inquiry

  Setting Profile options

  Customize Menu

  Customize Functions

 

General Ledger (GL)

 

1.1  Defining Chart of Accounts (in Excel)

1.2  Define Currency

1.3  Defining Calendar

a.       Define Calendar type

b.      Define Transaction Calendar

1.4  Defining General Ledger Accounting Flex fields

a.       Defining Segments

b.      Defining Value sets

c.       Defining Values in Value sets

1.5  Defining Legal Entity

1.6  Defining Ledger (Set of Books)

a.       Assign Accounting Flex field

b.      Assign calendar

c.       Assign Currency

d.      Assign accounting convention (Cash Basis, Accrual Basis)

1.7  Completion of Ledger options

a.       Define and update the journal processing options for your ledger

b.      Balancing Segment Value Assignments

c.       Sub-ledger Accounting Options

d.      Document Sequencing

1.8  Set mandatory Profile Options for creating Link with Ledger and Responsibility

1.9  Define Journal Source

1.10    Define Journal Category

1.11    Open/ Close GL Periods

1.12    Document Sequencing

a.       Define Sequence

b.      Assign Sequence

1.13    Processing Journals

a.       Entering Journal

b.      Posting Journals

c.       Reversing Journals

d.      Processing Foreign Currency Journals

e.       Auto-copying Journals

f.       Entering Recurring Journals

1.14    Account Inquiry

1.15    Define Shorthand Aliases

1.16    Define Security rules

1.17    Define Cross validations

1.18    Define Budget

1.19    Define Budget Organization

1.20    Enter Budget Journals

1.21    Variance Analysis of Budget

1.22    Trial Balance Report

1.23    Line Drill Down (for AP/AR Invoices)

1.24    Define Accounts Combination

1.25    Disable Accounts Combination

1.26    Preparing financial statements (FSG)

1.27    Run and View standard Reports

 

 

Accounts Payable (AP)

 


2.1              Defining Financial options

2.2              Defining Payable options

2.3              Defining Payable system setup

2.4              Define Payment terms

2.5              Managing suppliers;

a)      Defining Supplier

b)      Supplier inquiry

2.6              Invoice Batch

2.7              Define Withholding tax codes and groups

2.8              Define Payment Process profile

2.9              Define Banks and Branches

2.10          Define Bank Accounts

2.11          Define Payment Documents (Check Book)

2.12          Open/Close Payable Periods

2.13          Processing Invoices, Debit Memo, Credit Memo, Prepayments

2.14          Define Distribution sets

2.15          Processing Payments

2.16          Application of Standard invoices to Prepayments

2.17          Invoice Validation

2.18          Create Accounting

2.19          Create Employee

2.20          Define Control Payables Period

2.21          Define Expense Report Template

2.22          Expense report Export

2.23          Supplier balance Inquiry

2.24          Run and view standard reports

2.25          Transfer data to GL

 

Accounts Receivable (AR)

 

3.1           Define System Options

3.2           Define Payment Terms

3.3           Define Discount Method

3.4           Define Customers

3.5           Inquiring customer

3.6           Define Transaction Types

3.7           Define Transaction Source

3.8           Define Memo Line

3.9           Define Auto Accounting

3.10       Define Banks

3.11       Define Receipt Methods

3.12       Define Receipt Sources

3.13       Processing Transaction (Sales Invoice)

3.14       Processing Debit/Credit Memos

3.15       Processing Customer Advances

3.16       Processing Customers standard Receipts

3.17       Processing Miscellaneous Receipts

3.18       Create Accounting

3.19       Transfer entries to GL

 

 

Cash Management

 

4.1           Define Banks and Branches

4.2           Define Bank Accounts

4.3           Define Payment Documents (Check Book)

4.4           Open/Close Payable Periods

4.5           Create Bank Statement and Reconciliation

 

 

Who Should Attend

  Business Individuals

  Salaried Individuals

  Financial Lawyers

  Accountants

  Other personnels dealing with Finance matters

  Payroll Accountants

  Students with career in Finance

 

Starting From

Timings

Last Date of Registration

Fee

30-09-17

0900-1700

(Sat - Sun)

27-09-17

Rs:15,000

Per Participant

* 10% Discount for students

Duration = 16 Hours

 

Home | Site Map | Contact Us | About Us

SKILL DEVELOPMENT COUNCIL
Plot No: 205, Korang Road, I-10/3, Islamabad| 051-4440719 / +0331-7888990 - 4
Copyright 2008 Skill Development Council