Tuesday, 18 March 2014

Overview of Oracle Apps Financial

WHAT IS ORACLE FINANCIALS?

Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with

Oracle Assets: Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.

Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.

Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.

Oracle Order Entry: Provides organizations with a sophisticated order entry system for managing customer commitments.

Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payments.

Oracle Cash Management: Lets you perform bank reconciliation and cash forecasting.

Oracle Personnel: Improves the management of employee- related issues by retaining and making available every form of personnel data.

Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.

Oracle Revenue Accounting Gives an organization timely and accurate revenue and flexible commissions reporting.

Oracle Sales Analysis: Allows for better forecasting, planning. and reporting of sales information.

Saturday, 22 February 2014

Oracle Apps Financial R12 Online Training Course Content


Apps Financial R12 Summary Course Content:


 Payables (AP)
 Receivables (AR)
 General Ledger (GL)
 Fixed Assets (FA)
 Cash Management (CE)
 Multi Org Access Control (MOAC)
 Sub Ledger Accounting (SLA)

Apps Financial R12 Detailed Course Content:


Basic Concepts of R12:
 Architectural Overview - System Administration
 UI Navigation changes in R12 Vs 11i
 Flex fields
 Access and Controls
 Functional overview of Products
 Concepts of LE/OU/Chart of Accounts
 Differences between R11 Vs 11i-sneek peek review
 Creation of Users and assignment of Responsibilities
 Profile Options and security controls
Payables:
 Invoice Vs Inv Batch
 Creation of Invoices (All types of Invoices)
 Prepayment Application and Unapplication
 Payment of Invoices- Full and Partial
 Invoice Accounting
 Payables Options
 Financials Options
 System Hold and Manual Holds
 Distribution Set Vs Distribution Accounts
 Retainage Release Calculation
 WH Taxes
 Recurring Invoices
 Supplier Setup
 Multi Currency payments
Payables Intergration Areas:
 Procure to Pay (end to end flow)
 Creation of PO
 Receipt
 Inspection
 Invoice Matching and Payment for the same
 2/3/4 way matching with PO
 Auto Invoice from PO
 Automatic Offset
 Creation of isupplier portal
 Supplier PO Management
 Data Model Analysis
 AP Backend data model
 Tables impacted on updation
 Retainage Release
 Fixed Assets Integration
Oracle Payments (IBY): 
 Funds Disbursement
 Changes in R12 Vs 11i
 Role of New Payment Set up Administrator
 Creation of Payment Process Profile
 Creation of Payment methods
 Mapping PPP and Payment Documents with Internal bank Accounts
 Payment Process Request Templated and Submission
 Manual Vs Automatic completion
 Overview of Federal formats
 Scheduling Requests in Real time
 Assignment of Bank Accounts and PPP
 Paying different supplier and OU’s in single pay run
 Review proposed payments
 Add & Remove invoices during payments
 Electronic and Printed Payments
 Multi Currency Payments
 Validations during payment
 Resolve document & payment validation errors
 Payment Limits  MOAC Payments
 Decentralised AP and Payments
 Centralized AP and Payments
 Terminate
 Void and Stop Payments
 Void by overflow
 Skipped documents
Funds Capture: 
 Process flow for funds capture
 Auths Vs Settlements
 Credit Card Creation
 Brand activation Vs Inactivation’s
 Assignment of credit card and Bank accounts to customer
 Encryption Vs Masking
 Creation of Funds Capture Process Profile
 Creation of Payee
 Mapping FCPP, PSA and Payees with OU
 Transaction testing auths & settlements
 Auth Capture  Credit Card refund
 Invoking FC from AR/OM and collections
DATA MODEL: 
 Data Model Analysis for Funds Disbursement
 Data Model Analysis for Funds Capture
Multi Org Access Control(MOAC): 
 Changes in 11i Vs R12
 Security Profile Options
 Security list maintenance
 Assigning security to users and responsibilities
Fixed Assets: 
 Asset Books vs Finance Book
 Asset Creation
 Calculation of Depreciation
 Paying a capital asset PO via AP
 Mass Addition
 Retirement
 Transfer of Asset
 Group Vs Member Assets
Cash Management: 
 Changes in R12 Vs 11i
 Creation of Banks/Branches/Accounts
 Distinction between Internal bank accounts and external bank accounts
 Controls in Cash Management
 Reconciliation Manual and Auto Reconciliation
 UMX Security Controls
 Back end SQL data model for internal and external bank accounts
 Cash Clearing
 Bank Account Transfers
 Cash Positioning and Forecasting
Accounts Receivable: 
 Creation of Transaction
 Receivable Options
 Receipt Manual Vs Automatic
 Receipt Application Vs Unapplication
 Remittances  Refund Manual Vs Credit Card
 Charge Back  Customer setups
 Auto Cash Rule set
 Balance Forward Billing
 Type of Transactions and set off with Credit Memo
 Accounts Overview
iModules: 
 I Receivables
 I Supplier Portal
Sale Order Management integration with Financial Modules(AR): 
 Auto Import Orders
 Creation of Invoices in AR using import from OM
 Payment of Sales Order using Credit card
Sublegder Accounting Methods (SLAM): 
 Architectural Overview
 Even Model in R12 Vs 11i
 Accounting Events Definition
 Accounting Events in Payables
 Accounting Events in Receivables
 Modifying seeded AAD, JLT and JLD
Oracle General Ledger: 
 Creation of Ledger
 Accounting Setup Manager
 Open and Close periods
 Mapping of 4 C’s =Currency, Calendar, COA and Convention
 Primary and Secondary Ledger
 Reporting Currency Ledger
 Transfer/Post Accounting entries to GL
 Creation of recurring journals
 Data Conversion Levels
 COA Mapping
 Ledger Vs Ledger Sets
 Consolidations
 Data Access Set Vs Definition Access Set
 Budgets
 Consolidations
Financial Statement Generator:
 Prepare Income statement
 Balance Sheet