HOME

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 and Prerequisites
Students must know the Concepts in Oracle and Knowledge required on Financial Accounting. Basic Knowledge on Planning and Bill of Material principles

Oracle APPS R12 Functional Course Content

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

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