Oracle Apps Finance Functional R12

Overview :

Oracle Apps Finance Functional R12 is the basics of ORACLE Financial Applications and it is used to maintain the financial lifecycle in an organization. It includes General Ledger, Multi ORG structure, Purchasing, Payables, Receivables, Systems Administration and Asset Management. You will learn all these concepts that are included across these applications and how all these work together in different flows to best suit the required business needs.

Training Objectives of Finance Functional R12 :

Students will learn all the functional aspects of Financial R12. The course will be covering all the modules which are exist in financial (Accounts Receivable-AR/General Ledger-GL/Accounts Payable-AP/Fixed Assets-FA/Cash Management-CM).

Target Students / Prerequisites :

Students must know the Concepts in Oracle and Knowledge required on Financial Accounting. Basic Knowledge on Planning and Bill of Material principles

I. Introduction to ERP :

Introduction to ERP
What is Oracle
History of Oracle
What is E-Business Suite
Versions in Oracle
Versions Oracle Application
Modules in Oracle application
Modules in Oracle Financials
ERP’s available in the Market
How ERP is going to Work
ERP Vs Accounting Package
Why Oracle Apps popular
What Is Implementation
Companies Imp Oracle Apps
Hardware requirements

II. General Ledger :

Flexfields in Oracle Apps
Key flexfields in GL
Business requirement
Design Chart of Accounts
Setup Value Sets
Setup Structure
Setup Segments
Setup Segment Values
Define or Enable Currencies
Setup Period Types for Calendar
Setup Accounting calendar
Ledger Mandatory Accounts
Define Ledger
Assign Ledger to Profile Option
Open/Close Accounting Periods
Understanding Balance types
Understanding Effective data
Understanding Journal Category
Understanding Journal Source
Understanding Control totals
Enter Journals
Review Journals
Posting Journals
Entering Suspense Journals
User define suspense journals
Account Aliases
Document Sequence
Trail Balance-Detail
Auto Positing Journals
Reversing Journal
Auto Reversal Journals
Recurring Journals
Security Rules
Cross Validation Rules
Rollup Groups
Summary Accounts
Intra-company Journals
Multi Reporting Currencies
Ledger Set
Data Access Set

III. Budgets in General Ledger :

Introduction to Budgets
What is Budget
Types of Budgets
Define Planning Budget
Define Budget Organization
Enter Budget Amounts
Inquiry Account Balances
Define Funding Budget
Define Funding Organization
Enable Reserve for Encumbrance
Setup Budget controls
Enter Budget Journals
Enquiry Funds availability
Passing Actual Against Budget
Passing Encumbrance against Budget

IV. Purchasing Module :

Introduction to Purchasing
Prepare Purchase Order
Understand Matching Levels
Setup Matching Level at PO
Enter and Maintain Goods Receipts
Perform Inspection Accept/Reject
Transfer Stock to Inventory
Verify Stock at Inventory Level
Cancelling Purchase Order

V. Account Payables :

Setup Payment Terms
Setup Distribution Sets
Setup Internal Banks
Setup Supplier Banks
Setup Supplier
Invoice Workbench
Invoices Types in AP
Match Invoice with PO
Maintain Standard Invoice
Understanding types Payments
Maintain Payments
Maintain Debit Memo
Refund from Supplier
Types of Prepayment
Prepayment with Supplier
Prepayment with Employee
Generating Expense Report
Maintain Mixed Invoice
Define special Calendar
Withholding Tax Invoice
Maintain Recurring Invoices
Maintain Interest Invoice
Setup Payable Options
e tables

VI. Account Receivables :

Introduction to Receivables
Key flexfields in Receivables
Setup Receivables Quick Codes
Define Customer Class
Define Customer Category
Define FOB
Define Freight Terms
Define Freight Carriers
Setup Payment Terms
Setup Distribution Sets
Define Remittance Banks
Setup Customers Banks
Define Collectors
Define Statement Cycle
Define Auto Cash Rule set
Setup Customer Profile-Class
Enter Standard Customers
Define Transaction Types
Define Transaction Sources
Maintain Invoice
Maintain Debit Memo
Maintain Credit Memo
Maintain Deposit Invoice
Maintain Chargeback Invoice
Accounting for Invoice
View Accounting for Invoice
Define Receipt Class
Define Receipt Source
Maintain Receipts
Accounting for Receipt
View Accounting for Receipt
Raising Remittances
View Account Overview
View Account Details

VII. Cash Management :

AP Setup for Cash Management
AR Setup for Cash Management
Setup Required in Cash Management
Maintain Invoice in AP
Maintain Payment in AP
Perform Bank Reconciliation
Maintain Invoice in AR
Maintain Receipt in AR
Perform Remittances
Update Bank Statement
Auto Reconciliation AP Payments
Auto Reconciliation AR Receipts
Clearing of Transactions
Un clearing of Transactions

VIII. Sub-Ledger Accounting :

Mapping Set
Accounting Derivation Rules
Journal Line Definition
Application Accounting Definition
Sub-Ledger Accounting Method
Assign SAM to Ledger
Invoice with Type Supplier
Accounting with Type Supplier
Transfer to General Ledger
Invoice with Type Contractor
Accounting with Type Contractor
Transfer to General Ledger

IX. E-Business Tax :

Introduction to E-Business Tax
Setup Tax at State Level
Setup Tax at County Level
Setup Tax at City Level
Creating Tax Regime
Create Tax and Link to Geography Type
Create the Tax Status for each Tax
Define Tax Jurisdictions
Define Tax Rates
Set Default Tax Rules
Enable Tax available for Transactions
Enter Invoice Using above Tax Codes
Verify whether Tax calculated or not
Disable Tax Regime

X. Fixed Assets :

Fixed Assets Overview
Flex Fields in Assets
Setup Asset Location & Values
Setup Asset Key & Values
Setup Asset Category & Values
Register Asset Location
Register Asset Key
Define Fiscal Year
Define Depreciation Calendar
Define Prorate Convention Calendar
Define Depreciation Methods
Define Depreciation Book
Define Asset Categories
Addition of Asset
CIP additions
Capitalize CIP Asset
Soft & Hard Close Depreciation
Run Retirement

XI. Oracle Payments :

System Security Options
XML Publisher Format Template
Payment Setup Administrator
Payment Format
Payment Methods
Payment Method Defaulting Methods
Payment Process Profile(PPP)
Payment Process Request Templates
Automatic Payment Process Requests
Manual Payment Process Requests

XII. System Administration :

Define Application User
Control Application User
Setup Password Limitations
Setup Profile for Password Length
Assign Responsibility to the User
Control Responsibility
Define Responsibility
Update System Profile Options
Types of Descriptive Flexfield
Enable Descriptive Flexfield
Disabling Descriptive Flexfield

XIII. Multi Org and MOAC Setups :

Understanding Multi Org Structure
Setup Responsibilities for Multi Org
Assign the Responsibilities to User
Setup Location
Setup Business Group with HR Org
Setup System Profile Options
Update “HR Security Profile”
Assign Business Group to Responsibilities
Legal Entity with Using New Location
Setup Ledger & Assign to Legal Entity
Setup Operating Unit
Setup Work Day Calendar
Setup 1 or 2 Inventory Org
Assign it to Operating Unit
Setup Inventory Organization
Open Financials Options & verify
Setup System Profile Options
Assign MO operating Profile
Re-Check Financials Options
Setup System Profile Options
HR Security Profile
Verify Organization Form & Check
MOAC Setups for Payables
MOAC Setups for Receivables
Run Security Maintenance Report
User Management
Setup Roles and Role Inheritance
Security Wizard