Oracle Apps Functional Development
The Oracle E-Business Suite Financials family of applications provide organizations with solutions to automate and streamline a wide range of long- and short-term accounting system issues . These solutions or applications are used extensively in businesses around the world. Oracle groups these applications into "suites", which it defines as sets of common, integrated applications designed to execute specific business processes.
ORACLE APPS FUNCTIONALR12 Summary Course Content • 1.Payables (AP) • 2.Receivables (AR) • 3.General Ledger (GL) • 4.Fixed Assets (FA) • 5.Cash Management (CE) • 6.Multi Org Access Control (MOAC) • 7.Sub Ledger Accounting (SLA)
R12 Detailed Course Content:Basic Concepts of R12 • 1.Architectural Overview – System Administration • 2.UI Navigation changes in R12 Vs 11i • 3.Flex fields • 4.Access and Controls • 5.Functional overview of Products • 6.Concepts of LE/OU/Chart of Accounts • 7.Differences between R11 Vs 11i-sneek peek review • 8.Creation of Users and assignment of Responsibilities • 9.Profile Options and security controls Payables: • 1.Invoice Vs Inv Batch • 2.Creation of Invoices (All types of Invoices) • 3.Prepayment Application and Unapplication • 4.Payment of Invoices- Full and Partial • 5.Invoice Accounting • 6.Payables Options • 7.Financials Options • 8.System Hold and Manual Holds • 9.Distribution Set Vs Distribution Accounts • 10.Retainage Release Calculation • 11.WH Taxes • 12.Recurring Invoices • 13.Supplier Setup • 14.Multi Currency payments Payables Intergration Areas: • 1.Procure to Pay (end to end flow) • 2.Creation of PO • 3.Receipt • 4.Inspection • 5.Invoice Matching and Payment for the same • 6.2/3/4 way matching with PO • 7.Auto Invoice from PO • 8.Automatic Offset • 9.Creation of isupplier portal • 10.Supplier PO Management • 11.Data Model Analysis • 12.AP Backend data model • 13.Tables impacted on updation • 14.Retainage Release • 15.Fixed Assets Integration Oracle Payments(IBY): • 1.Funds Disbursement • 2.Changes in R12 Vs 11i • 3.Role of New Payment Set up Administrator • 4.Creation of Payment Process Profile • 5.Creation of Payment methods • 6.Mapping PPP and Payment Documents with Internal bank Accounts • 7.Payment Process Request Templated and Submission • 8.Manual Vs Automatic completion • 9.Overview of Federal formats • 10.Scheduling Requests in Real time • 11.Assignment of Bank Accounts and PPP • 12.Paying different supplier and OU's in single pay run • 13.Review proposed payments • 14.Add & Remove invoices during payments • 15.Electronic and Printed Payments • 16.Multi Currency Payments • 17.Validations during payment • 18.Resolve document & payment validation errors • 19.Payment Limits • 20.MOAC Payments • 21.Decentralised AP and Payments • 22.Centralized AP and Payments • 23.Terminate • 24.Void and Stop Payments • 25.Void by overflow • 26.Skipped documents Funds Capture: • 1.Process flow for funds capture • 2.Auths Vs Settlements • 3.Credit Card Creation • 4.Brand activation Vs Inactivation's • 5.Assignment of credit card and Bank accounts to customer • 6.Encryption Vs Masking • 7.Creation of Funds Capture Process Profile • 8.Creation of Payee • 9.Mapping FCPP, PSA and Payees with OU • 10.Transaction testing auths & settlements • 11.Auth Capture • 12.Credit Card refund • 13.Invoking FC from AR/OM and collections DATA MODEL: • 1.Data Model Analysis for Funds Disbursement • 2.Data Model Analysis for Funds Capture Multi Org Access Control(MOAC): • 1.Changes in 11i Vs R12 • 2.Security Profile Options • 3.Security list maintenance • 4.Assigning security to users and responsibilities Fixed Assets: • 1.Asset Books vs Finance Book • 2.Asset Creation • 3.Calculation of Depreciation • 4.Paying a capital asset PO via AP • 5.Mass Addition • 6.Retirement • 7.Transfer of Asset • 8.Group Vs Member Assets Cash Management: • 1.Changes in R12 Vs 11i • 2.Creation of Banks/Branches/Accounts • 3.Distinction between Internal bank accounts and external bank accounts • 4.Controls in Cash Management • 5.Reconciliation Manual and Auto Reconciliation • 6.UMX Security Controls • 7.Back end SQL data model for internal and external bank accounts • 8.Cash Clearing • 9.Bank Account Transfers • 10.Cash Positioning and Forecasting Accounts Receivable: • 1.Creation of Transaction • 2.Receivable Options • 3.Receipt Manual Vs Automatic • 4.Receipt Application Vs Unapplication • 5.Remittances • 6.Refund Manual Vs Credit Card • 7.Charge Back • 8.Customer setups • 9.Auto Cash Rule set • 10.Balance Forward Billing • 11.Type of Transactions and set off with Credit Memo • 12.Accounts Overview iModules: • 1.I Receivables • 2.I Supplier Portal Sale Order Management integration with Financial Modules(AR): • 1.Auto Import Orders • 2.Creation of Invoices in AR using import from OM • 3.Payment of Sales Order using Credit card Sublegder Accounting Methods (SLAM) • 1.Architectural Overview • 2.Even Model in R12 Vs 11i • 3.Accounting Events Definition • 4.Accounting Events in Payables • 5.Accounting Events in Receivables • 6.Modifying seeded AAD, JLT and JLD Oracle General Ledger: • 1.Creation of Ledger • 2.Accounting Setup Manager • 3.Open and Close periods • 4.Mapping of 4 C's =Currency, Calendar, COA and Convention • 5.Primary and Secondary Ledger • 6.Reporting Currency Ledger • 7.Transfer/Post Accounting entries to GL • 8.Creation of recurring journals • 9.Data Conversion Levels • 10.COA Mapping • 11.Ledger Vs Ledger Sets • 12.Consolidations • 13.Data Access Set Vs Definition Access Set • 14.Budgets • 15.Consolidations Financial Statement Generator: • 1.Prepare Income statement • 2.Balance Sheet